[thelist] Formating connection string

Matt Warden mwarden at gmail.com
Wed Mar 16 13:30:18 CST 2005


On Wed, 16 Mar 2005 12:59:09 -0600, Casey Crookston
<casey at thecrookstons.com> wrote:
> 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")
> 

I believe it depends on what kind of connection you are using
(DNS-less?). Maybe this will help you:

http://www.google.com/search?&q=remote%20sql%20server%20database%20connection%20string%20asp




-- 
Matt Warden
Miami University
Oxford, OH, USA
http://mattwarden.com


This email proudly and graciously contributes to entropy.


More information about the thelist mailing list