MS-SQL Connection

[parames]

Hello list..

How to connect to a sql-server using odbc connectivity in asp.. My web pages(asp pages) are in different server..and my database is in sql server... 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

 

[Geee]

Simple...

<%
set ADOConn = Server.CreateObject(&quot;ADODB.Connection&quot
ADOConn.Open &quot;MyDSNname&quot;, &quot;MyUserName&quot;, &quot;MyPassword&quot;
%>

Hope this helps...
Gary