Connection string declarations

[Luis]

I'm using a connection string in my asp pages similar to:

cst = "Provider=SQLOLEDB;Server=MyServerName;Database=My DbName;"
cst = cst & "Network Library=DBMSSOCN;User ID=MyUserid;Password=MyPass"
set conn = Server.CreateObject("ADODB.Connection")
conn.open cst

Do I need to declare the cst and conn variables?

ie:

dim cst
cst = "Provider=SQLOLEDB;Server=MyServerName;Database=My DbName;"
cst = cst & "Network Library=DBMSSOCN;User ID=MyUserid;Password=MyPass"

dim conn
set conn = Server.CreateObject("ADODB.Connection")
conn.open cst

Thanks

[Chris Barber]

Check this out and then decide (it *is* optional but recommended to declare
variables and use 'Option Explicit').

http://www.4guysfromrolla.com/webtec...ate/faq6.shtml

Chris.

"Luis" <an****@webmail.co.za> wrote in message
news:69**************************@posting.google.c om...
I'm using a connection string in my asp pages similar to:

cst = "Provider=SQLOLEDB;Server=MyServerName;Database=My DbName;"
cst = cst & "Network Library=DBMSSOCN;User ID=MyUserid;Password=MyPass"
set conn = Server.CreateObject("ADODB.Connection")
conn.open cst

Do I need to declare the cst and conn variables?

ie:

dim cst
cst = "Provider=SQLOLEDB;Server=MyServerName;Database=My DbName;"
cst = cst & "Network Library=DBMSSOCN;User ID=MyUserid;Password=MyPass"

dim conn
set conn = Server.CreateObject("ADODB.Connection")
conn.open cst

Thanks

-----Original Message-----

I'm using a connection string in my asp pages similar to:

cst = "Provider=SQLOLEDB;Server=MyServerName;Database=My DbName;
"cst = cst & "Network Library=DBMSSOCN;User ID=MyUserid;Password=MyPass"set conn = Server.CreateObject("ADODB.Connection")
conn.open cst

Do I need to declare the cst and conn variables?

ie:

dim cst
cst = "Provider=SQLOLEDB;Server=MyServerName;Database=My DbName;
"cst = cst & "Network Library=DBMSSOCN;User ID=MyUserid;Password=MyPass"
dim conn
set conn = Server.CreateObject("ADODB.Connection")
conn.open cst

Thanks
.

I dont bother creating a connection string variable at all
unless I intend to use it twice, so you could get away
with -
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "Provider=SQLOLEDB;Server=MyServerName;Databas e=M
yDbName;Network Library=DBMSSOCN;User
ID=MyUserid;Password=MyPass"

HTH,

Colin