Connecting sql server database thru asp

[shahina]

Hi all..

i just started learning asp and i am not able to establish the connection to my db. db is in sql server..am writing the asp code like this
set conn = Server.CreateObject("ADODB.Connection")
conn.ConnectionString="Provider=MSDASQL.1;" "Data Source=dbname"
conn.Open

when previewed, the following error occured..
Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/asptest/sqltest.asp, line 9, column 44
conn.ConnectionString="Provider=MSDASQL.1;" "Data Source=dbname"

Please help me..

Thanx in advance..

shahina.

 

[ChrisHirst]

check the FAQs and search the forum. hundreds of examples and threads around.


Chris.

Indifference will be the downfall of mankind, but who cares?

http://www.candsdesign.co.uk

A website that proves the cobblers kids adage.

http://www.cram-system.com

Nightclub counting systems

So long, and thanks for all the fish.

 

[FesterSXS]

try this:

strConn = "DRIVER={SQL Server};SERVER=[b]myServerName[/b];DATABASE=[b]myDatabaseName[/b];UID=[b]myUserName[/b];pwd=[b]myPassword[/b];"
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open(strConn)

Tony
________________________________________________________________________________

http://www.SpiraxSarco.com

 

[shahina]

Thank u FesterSXS..

now i am getting this error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'Servername\IUSR_Servername'.
/asptest/sqltest.asp, line 13

 

[FesterSXS]

has the database actually got any protection on it? If not then you can leave the UID and pwd bits blank in the connection string.


Tony
________________________________________________________________________________

http://www.SpiraxSarco.com