[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