Database

Re: Recover the Sql data.....

5-Aug-05 3:00

Hopefully you can restore a backup and try again. You did make a backup first, didn't you?

Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
All that is necessary for the triumph of evil is that good men do nothing.
Edmund Burke

imshally815-Aug-05 3:11

imshally81

5-Aug-05 3:11

no i have not any backup .....

Problem when installing Microsoft SQL Server Desktop Engine

MarcLaheij4-Aug-05 23:15

MarcLaheij

4-Aug-05 23:15

Hi,

We develop a CAM application which makes use of a SQL Server database. We used to ship our product with MSDE version 7.0, but we were having more and more problems with users who wanted to install the software on a Windows XP system.
For these users we manually installed the MSDE 2000 version and this worked for these customers.
We desided to upgrade our installation CD to have the MSDE2000 version default.

But now I have problems installing this version on Windows XP (SP2) systems.

The error message is:
"Setup failed to configure the server. Refer to the server error logs and setup error logs for more information."
The event viewer has a warning :

The description for Event ID ( 19011 ) in Source ( MSSQL$CAM ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: (SpnRegister) : Error 1355.

To solve the problem I already googled the internet and tried the following possible soultions:
- Change the computer name to uppercase characters
- Remove unused SQL folders that were created on earlier attempts.
- Tried the MSDE2000A version as well as the MSDE 2000 SP4 version
- Tried diffrent instance names (defined in the setup.ini file)
- Check if the file/printer sharing is switched on.
- Switched off the windows firewall

The installation WORKS on my Toshiba laptop, but fails on our test-pc and test-server, both with the same error. All systems have Windows XP SP2 and all windows updates installed.

Any suggestions anybody??

Thanks!
Marc Laheij

I want to use store procedure with table argument

manish k patel4-Aug-05 19:37

manish k patel

4-Aug-05 19:37

I have one store procedure with table as input parameter

can i use that store procedure in asp.net ?

how i give the tabel variable type in asp.net coding to that input parameter.

Re: I want to use store procedure with table argument

4-Aug-05 20:51

This is an Example where i use stored procedure in C#.net

string strInsert="[sp_InsertAuthorRecord]"; //Stored Procedure For Insert record In Author Table.

conn =new SqlConnection (conStr); //Established Connection.

SqlCommand cmdText=new SqlCommand (strInsert,conn); //SqlCommand which contain Query

cmdText.CommandType =CommandType.StoredProcedure ;

SqlParameter param=cmdText.Parameters .Add ("@artid",SqlDbType.Int,4);
param.Direction =ParameterDirection .Input ;
param.Value=txtArticleID .Text; //declare first input parameter for stored procedure and also assing value to tht variable.

param=cmdText.Parameters .Add ("@title",SqlDbType.VarChar,50);
param.Direction =ParameterDirection .Input ;
param.Value =(string)txtArticleTitle.Text ;

param=cmdText.Parameters .Add ("@topic",SqlDbType.VarChar,50);
param.Direction =ParameterDirection .Input ;
param.Value =(string)txtArticleTopic .Text ;

param=cmdText.Parameters .Add ("@authorid",SqlDbType.Int ,4);
param.Direction =ParameterDirection .Input ;
param.Value =txtAuthorId .Text;

param=cmdText.Parameters .Add ("@lines",SqlDbType.Int,4);
param.Direction =ParameterDirection.Input ;
param.Value =txtNumOfLines.Text;

param=cmdText.Parameters.Add ("@dateOfPublishing",SqlDbType.DateTime,8);
param.Direction =ParameterDirection.Input ;
param.Value =(string)txtDateOfPublishing.Text ;

conn.Open ();//open connection
cmdText.ExecuteNonQuery ();//Execute Query

Stored procedure for this example is:

Create PROCEDURE sp_InsertArticleRecord
@artid integer ,
@title varchar(50),
@topic varchar(50),
@authorid int,
@lines integer,
@dateofpublishing datetime

AS
Begin

Insert into article(artid,title,topic,authorid,lines,dateofpublishing)
values (@artid,@title,@topic,@authorid,@lines,@dateofpublishing)

End
Smile | :)

Annpurna Tiwari
IIPL Company
Nagpur
India

NHibernate and DataGrid paging

devvvy4-Aug-05 16:35

devvvy

4-Aug-05 16:35

Hi, I need to implement custom DataGrid paging: http://dotnetjunkies.com/Tutorial/EA868776-D71E-448A-BC23-B64B871F967F.dcik

Basically, idea is called a stored proc and retrieve only those records you need on "Current" page, thereby reducing processing and data transfer. The stored procedure takes as parameters "PageNumber" and "PageSize" to compute the records to return.

Normally, without stored proc:

o_session = SetupFESRCConnection(...)<br />
criteria = o_session.CreateCriteria(GetType(mylib.to.Company))<br />
...<br />
conjunc = New NHibernate.Expression.Conjunction<br />
criteria.Add(conjunc)<br />
disjunc = New NHibernate.Expression.Disjunction<br />
conjunc.Add(disjunc)<br />
disjunc.Add(Expression.EqExpression.Eq("CompanyCode", companyCode))<br />
company_list = criteria.List()

But how can I specify criteria "I just want page 3 data given page size = 10 records per page"? However, can I retrieve via stored procedure using NHibernate?

Thanks in advance.

Norman Fung

HELP:identifying table name in a database

girl_lash4-Aug-05 14:13

girl_lash

4-Aug-05 14:13

hi! i just want to know if there is a way to identify the table names in a certain database using ADO in Visual C++...

Please help me...

Re: HELP:identifying table name in a database

Rob Graham4-Aug-05 16:39

SQL Server 2005 Login Screen given error

4-Aug-05 16:39

Look at the OpenSchema method of the Connection class.

Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
All that is necessary for the triumph of evil is that good men do nothing.
Edmund Burke

Record-locking...

Laffis4-Aug-05 4:39

Laffis

4-Aug-05 4:39

Hi
I am a newbee in db programming and I am now using MFC ODBC classes. (I do not use DAO as MSDN says we should not develop new project with it... is this true? D'Oh! | :doh:

)

I see that default locking mechanism, which is optimistic locking, only occurs on Update(). This, however, means that in a multithreaded application, if thread-1 is going to do an AddNew, thread-2 is going to do an Edit, a switching context means that the 2 thread may race against each other hence causes conflict.

Currently what I do is creating a global mutex object for each table. Each db opration, e.g. an edit operation (including Open(), Edit(), Update()) must be guarded by this mutex object.

This gaurantees to fight off race condition. But does anyone know a better solution? Confused | :confused:

thx!

TariqMahmood4-Aug-05 0:09

TariqMahmood

4-Aug-05 0:09

Hi all,
when i start SQL Server Exress Manager it want Server Instance_________. when i enter my computer id its showing error so any buddy tell me what should i have to give on this screeen

Thanks
Regards from
Tariq Mahmood

Selecting Last Row of a Table

Hassanur3-Aug-05 20:58

Hassanur

3-Aug-05 20:58

Hi What will be the SQL SELECT statement to select only the last row of a table. I am using Microsoft SQL server. Please Help me.

Tutul

Anonymous3-Aug-05 22:06

Anonymous

3-Aug-05 22:06

Sorry for my english...

You should to create a new field (for example "created_on") in your table, which type is TIMESTAMP. When you inserting a new record in the table this field will automatically filled within the time of creation of the new record...
So, the request is:

SELECT * FROM myTable ORDER BY created_on DESC LIMIT 1

Member 5569024-Aug-05 2:19

Member 556902

4-Aug-05 2:19

If the table has a unique ID column (primary key) then u can Select the last record from the table as:

Select [Fields Name] from [Table Name] where [Pk Field name] in (Select MAX(Pk Field name) as nID from [Table Name])

e.g.,
Select employeename,Employee_ID from tbl_emp where Employee_ID in (Select MAX(Employee_id) as nid from tbl_emp)

Regards
Anyla

Selecting Last Row of a Table

Mandar Patankar4-Aug-05 8:33

Mandar Patankar

4-Aug-05 8:33

Hi
If you have a date field in your table or some other field which can sort the recordset.If yes then try this

SELECT top 1 * FROM tblA ORDER BY DATE1 DESC
or
SELECT top 1 * FROM tblA ORDER BY DATE1 ASC

i hope this helps

Mandar Patankar
Microsoft Certified professional

Hassanur3-Aug-05 20:50

Hassanur

3-Aug-05 20:50

Hi What will be the SQL SELECT statement to select only the last row of a table. Please Help me

Tutul

Storing Different Language Data

4-Aug-05 20:01

Try This One It Will Help You

SELECT top 1 * FROM <tablename> ORDER BY CloumnName desc

Smile | :)

Annpurna Tiwari
jr.Technology Architect
IIPL Company
Nagpur
(M.S)
India

Anonymous3-Aug-05 19:00

Anonymous

3-Aug-05 19:00

Hi
Can anyone tell me is there any way to store different language data(in particular spanish) into sql server. If yes please tell me

Thanks in advance

Re: Storing Different Language Data

Rob Graham4-Aug-05 4:39

Query Access db where date/time ...

4-Aug-05 4:39

SQL server (or any database that supports Unicode text, for that matter) doesn't care what 'language' the text being stored belongs to. As long as your fireld types ar NVarchar or NText, you can store any sequence of Unicode characters you want, and they will be returned accurately.

If you need the sorting algorithms to operate correctly for your language, then you need to change the collation setting for the server to the proper language. This however, just affects what order will result from sorting recordes containing the text. The data is agnostic: what goes in is what comes out.

Note that the results of quees on Unicode data my sometimes look wrong, if the font used to display the data does not contain the unicode charaters in the text, in which case an empty 'box' is usually displayed for the missing character. Arial seems to support the widest range of characters.

Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
All that is necessary for the triumph of evil is that good men do nothing.
Edmund Burke

Laffis3-Aug-05 8:23

Laffis

3-Aug-05 8:23

Hi
I need to query into MS Access database using c++. The search should uses a general date but I could not work out how-to.

i.e. the field in the db is of Date/Time, which formats as dd/mm/yy hh:mm:ss

How should I fill in this sql statement? (the XXXX bit, and DateAndTime is the name of the field.)

SELECT * FROM MyTable WHERE DateAndTime='XXXX';

Thx to anyone who helps!

Re: Query Access db where date/time ...

Rob Graham3-Aug-05 9:07

3-Aug-05 9:07

Since the date is stored with high precision (i would guess as a function of the exact time the entry was made, like Now()), a general date query is likely to have many misses (the hh:mm:ss parts may get defaulted to 00 and cause a candidate to fail the equality match). I would use a range query instead, (i.e Between "XXX - 12H" and 'XXX + 12h', or present a selection list of candidate dates queried from the database. The string format of the date is also dependant on the locale setting of the computer running you app, so using the general date format is risky dd/mm/yy works for some locales, others expect mm/dd/yy. I would format the date using th 'odbc canonical' format which is locale immune:
"XXXX" = "{ts 'yyyy-MM-dd HH:mm:ss'}".

Even better, use a parameterized query and pass the date value(s) as a parameter of type OLEDATE.

You should also be aware that Access stores the dates as local time relative to the zero date , so changing the time zone can cause the dates to appear differently in different time zones...

Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
All that is necessary for the triumph of evil is that good men do nothing.
Edmund Burke

tracking actions in sql

WetRivrRat3-Aug-05 5:35

WetRivrRat

3-Aug-05 5:35

Hey all,
I'm working with a software package that relies on the security of the server to protect the database, meaning the database is entirely in plain english, and there is no double checking or check sum features to verify the data.
The server is accessable by all domain users(go figgure?) and therefore so is the database. The problem I am having is certain users have figgured this out and will go in to the db to change their access level and passwords of others (just for the sake of being malicious)

I have contacted the developers of the package and they basically said, "Sorry, mate, can't help you, we didn't design the system to be used in a hostile environment like yours". So I have no help from them, but still have the problem.

I need a way to track the transactions happening on the access_level column of the users table.

I've tried using the sql profiler, but i only know how to trace current transactions not previous tranactions so if the server gets rebooted, or someone logs into the console they see that its running and shut it off.

Basically, is there anyway to write something that will store the transactions happening on that column? or is there anyway to store the username column that was modified? so if i were user1 and i went in to the db and modified my account access level there would be a log or record of that transaction somewhere else that would store that users name.

I will plan to write any neccessary app in C#, and I would prefer to have the app run on my pc, not the server.
i've thought about just running an app that queries the db every so often (3-5 mins) to see the number of users in each access level, then returns the usernames for each admin access level(the level they are maliciously accessing) but that seems like a awful lot of work on the db, specially since its allready running slow due to the number of hits and request the server allready deals with. (which i can't really change since the server is run and operated by a different team, I just run the software package, there is a server group and a db group)

Is there a better option???
Confused | :confused:

Dim Beautiful As String
Beautiful = "ignorant"
Label1.Text = "The world is full of " & Beautiful & " people."

Why is common sense such an un-common comodity?

Rob Graham3-Aug-05 6:20

3-Aug-05 6:20

What is the underlying database engine? If it is sql server you could add an update trigger on the users table and audit trail the changes to another (new) table. Better yet, the trigger could also reject access level changes by other than specific users, and perhps temporarily disable their access completely...

Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
All that is necessary for the triumph of evil is that good men do nothing.
Edmund Burke

WetRivrRat3-Aug-05 7:05

WetRivrRat

3-Aug-05 7:05

yes it is sql server, and i will have to do some research on these triggers you speak of, any direct links, good books, ideas you can share?

Dim Beautiful As String
Beautiful = "ignorant"
Label1.Text = "The world is full of " & Beautiful & " people."

Why is common sense such an un-common comodity?

Rob Graham3-Aug-05 7:15

3-Aug-05 7:15

The most complete documentation would be in SQL Sever Books On Line, which can be downloaded here.[^]

Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
All that is necessary for the triumph of evil is that good men do nothing.
Edmund Burke