[thelist] Connecting to remote daabase?

Ken Schaefer Ken at adOpenStatic.com
Tue Aug 9 17:53:55 CDT 2005


: -----Original Message-----
: From: thelist-bounces at lists.evolt.org [mailto:thelist-
: bounces at lists.evolt.org] On Behalf Of Casey
: Sent: Wednesday, 10 August 2005 4:30 AM
: To: thelist at lists.evolt.org
: Subject: Re: [thelist] Connecting to remote daabase?
: 
: 
: >   Provider=SQLOLEDB.1;UID=abc456;Password=******;Persist Security
: > Info=False;Initial Catalog=abc123;Data Source=fubar.url.com:1433
: 
: Thanks Bryan.  I'll give that a shot.
: 

What Bryan has given you is an OLEDB Connection string using the SQL Server
Provider.

However if you are using .NET, you probably want to use the native SQLClient
to connect rather than OLEDB

Go to www.connectionstrings.com, expand SQL Server, expand SQLConnection
(.NET) node.

Cheers
Ken


More information about the thelist mailing list