Best connection string to connect to SQL dbase...

[Mike Hill]

I need to connect to a dbase. I will be using ASP.NET, Windows 2003 Server,
and SQL 2000. What would the best connection method be:

OLE DB :
<%
Set cnn = Server.CreateObject("ADODB.Connection")
cnn.open "PROVIDER=SQLOLEDB;DATA
SOURCE=sqlservername;UID=username;PWD=password;DAT ABASE=mydatabase "
%>

With DSN :
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "DSN=MyDSN;UID=user;PWD=password;DATABASE=mydataba se"
%>

Without DSN :
<%
Set Conn = Server.CreateObject("ADODB.Connection")
DSNtest="DRIVER={SQL
Server};SERVER=ServerName;UID=USER;PWD=password;DA TABASE=mydatabase"
Conn.open DSNtest
%>

I go these off of MS web site. (Or would there be a beter way?)

Thanks,

M

[CJM]

[url]http://www.aspfaq.com/show.asp?id=2126[/url]

Chris

[Aaron [SQL Server MVP]]

OLEDB (the first one). However, please post further asp.net questions to an
asp.net newsgroup.

--
[url]http://www.aspfaq.com/[/url]
(Reverse address to reply.)




"Mike Hill" <mhill7272(at)hotmail.com> wrote in message
news:uLcIbfjTEHA.808@tk2msftngp13.phx.gbl...

> I need to connect to a dbase. I will be using ASP.NET, Windows 2003

Server,

> and SQL 2000. What would the best connection method be:
>
> OLE DB :
> <%
> Set cnn = Server.CreateObject("ADODB.Connection")
> cnn.open "PROVIDER=SQLOLEDB;DATA
> SOURCE=sqlservername;UID=username;PWD=password;DAT ABASE=mydatabase "
> %>
>
> With DSN :
> <%
> Set Conn = Server.CreateObject("ADODB.Connection")
> Conn.open "DSN=MyDSN;UID=user;PWD=password;DATABASE=mydataba se"
> %>
>
> Without DSN :
> <%
> Set Conn = Server.CreateObject("ADODB.Connection")
> DSNtest="DRIVER={SQL
> Server};SERVER=ServerName;UID=USER;PWD=password;DA TABASE=mydatabase"
> Conn.open DSNtest
> %>
>
> I go these off of MS web site. (Or would there be a beter way?)
>
> Thanks,
>
> M
>
>
>