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