[thelist] Formating connection string

Casey Crookston casey at thecrookstons.com
Wed Mar 16 12:59:09 CST 2005


In my asp.net file, I need to connect to an SQL database that is not on the
same machine as the site.  The network path is enterprise\ClientDatabase
where 'Enterprise' is the name of the server (the host has a few Trekies
working for them) and 'ClientDatabase' is the name of the SQL database.
Would I be correct in assuming that this would be a valid connection string:

Dim JBO as SQLConnection
JBO = New
SQLConnection(Server=enterprise;UID=****;PWD=****;database=ClientDatabase")

Thanks,

Casey



More information about the thelist mailing list