MS-SQL Connection

[parames]

Hello list..

How to connect to a sql-server using odbc connectivity in asp.. normally we will do something like this..

set oConn = Server.CreateObject("ADODB.Connection&quot
oConn.open "PROVIDER=SQLOLEDB;DATA
SOURCE=sqlservername;UID=username;PWD=password;DATABASE=databasename"

But, i want to use odbc(dsn name) instead of using server ip to do the connection.. How to do it.. Please help..

thanks a lot..

parames.s

 

[tlbroadbent]

Take a look at this article from Micrtosoft.

INF: How to Access SQL Server Within Active Server Pages

http://support.microsoft.com/support/kb/articles/q169/3/77.asp

Terry

X-) "Life would be easier if I had the source code." -Anonymous