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

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" <andyza@webmail.co.za> wrote in message
news:69476b6f.0310310305.34a88454@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-----[color=blue]
>I'm using a connection string in my asp pages similar to:
>
>cst[/color]
= "Provider=SQLOLEDB;Server=MyServerName;Database=My DbName;
"[color=blue]
>cst = cst & "Network Library=DBMSSOCN;User[/color]
ID=MyUserid;Password=MyPass"[color=blue]
>set conn = Server.CreateObject("ADODB.Connection")
>conn.open cst
>
>Do I need to declare the cst and conn variables?
>
>ie:
>
>dim cst
>cst[/color]
= "Provider=SQLOLEDB;Server=MyServerName;Database=My DbName;
"[color=blue]
>cst = cst & "Network Library=DBMSSOCN;User[/color]
ID=MyUserid;Password=MyPass"[color=blue]
>
>dim conn
>set conn = Server.CreateObject("ADODB.Connection")
>conn.open cst
>
>Thanks
>.
>[/color]


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