Connecting to sql server 2005 DB through asp 2

[Tr0]

I am trying to create a connection to a SQL Server 2005 DB within an ASP page using the following code:

Set Conn= Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=SQLOLEDB; Data Source = "" Initial Catalog = ""; User Id = ""; Password=''"

The error message I am receiving says that the set conn method is outdated. Is there a better way to create a connection?

 

[Sheco]

Everyone should bookmark this page:

http://www.connectionstrings.com/

 

[Tr0]

Thanks for the link to the page...

Its everything I could ever want

 

[anon007]

Are you using windows authencation if not you should it is more secure. My opinion.

If you are using it the link below is how to connect:


set rs = Server.CreateObject ("ADODB.Recordset")
Set conn = Server.CreateObject("ADODB.Connection")
Conn.ConnectionString = "Provider=SQLNCLI;Server=SERVER\SQLEXPRESS;Database=Your_Data_Base_Name_Here;Trusted_Connection=yes;"
Conn.Open

 

[anon007]

Oh for get the express after sql if your using standard. Hope it helps and here is a good source for you:

http://www.connectionstrings.com/?carrier=sqlserver2005

 

[anon007]

Sorry sheco bet me to the link good luck

 

[Tr0]

Thanks for your opinion anon I will keep that in mind.

 

[alex5935]

set cnn = server.createobject("ADODB.Connection")

cnn.open "Provider=SQLOLEDB; Data Source=mydb/sqlexpress;UID=;PWD=;DATABASE= "
set comm=server.createobject("ADODB.Command")

This works for me.