Error with connection to DB

Hi ther Guy's

I'm trying to connect to a DB from with-in a ASP page we tried using a DLL but no joy. so I'm writing them over to connect from with-in a asp page.

My code are as follow:

<%
Set conn = Server.CreateObject("ADODB.Connection")
Set objRec = Server.CreateObject("ADODB.Connection")

conn.Open "Provider=SQLOLEDB;DSN=196.33.166.151;UID=guest;PWD=;Database=Alchemy"
objRec.ActiveConnection = conn
objRec.Open "SELECT * from Users"

While not objRec.EOF
Response.Write objRec("Users_UID") & " "
Response.Write objRec("Users_PWD") & " "
objRec.MoveNext
Wend

objRec.Close
conn.Close
%>

I get the following error:

[DBNMPNTW]Specified SQL server not found.

*********
I tried using the IP Address of the Server as well as the DSN but both way's it's not working.

The Data Sourse name is registered in the System DSN.

Thanks in advance

your DSN should be in the File DSN and in your asp just
give the name of your dsn:

conn.Open "Provider=SQLOLEDB;DSN=yourDsnName;UID=guest;PWD=;Database=Alchemy"

Hey Sebs

Thanks for the help thus far.

I changed it like you said but I still get Specified SQL server not found ... I have it in System DSN, User and File but now go .. what am I doing wrong?

Thanks for the hlep

try this for your connection string:

Provider=SQLOLEDB;Data Source=196.33.166.151;UID=guest;PWD=;Database=Alchemy