adding odbc username + password to script

[johnv20]

Hi,
using DSN connection to access sql database with the DSN setup to use the sql server authentication username and password. However once I run the asp its defaulting back to my NT login name.

How do I add the username sa to the following script

<%@ Language=JavaScript %>
<%
DSN = &quot;DSN=EMRDATA1&quot;;
Conn = Server.CreateObject(&quot;ADODB.Connection&quot;
Conn.Open(DSN);

 

[Bastien]

HI

DSN = &quot;DSN=EMRDATA1&quot;;UID=userID;pwd=password&quot;;

hth

Bastien

There are many ways to skin this cat,
but it still tastes like chicken

 

[johnv20]

perfect - thanks