database connection

[parames]

Hi list.. Need help from you all..

My asp codes is in different server and my MS-SQL database is in another server. How to connect to the database in asp using the dsn that i've created in sql server?
Normally we use something like this if the database and the asp is in the same server:
Set AdoDb=Server.CreateObject("ADODB.Connection&quot
AdoDb.Open "dsn=nmpm;UID=popop;passwd=oppiu"

But how to do this connection if the database and asp is in different server?

Please help..

Thanks and Best Regards,
Parames.s

 

[Bernadette]

Hi there

Try


OLE DB Method for SQL
<% set cnn = server.createobject(&quot;ADODB.Connection&quot
cnn.open &quot;PROVIDER=SQLOLEDB;DATA SOURCE=sqlservername;UID=username;PWD=password;DATABASE=databasename &quot;
%>

Hope This Helps
Bernadette