hey there!

Well I tried somethig else but Is till get errors .. here's my revised code:

*********

aConnect = "Provider=SQLOLEDB.1;Persist Security Info=False;Data Source=DEV-SVR;Initial Catalog=Alchemy;User ID=Guest;Password=;ConnectionTimeout=10;"

Set conn = Server.CreateObject("ADODB.Connection")
conn.Mode = abModeReadWrite
conn.ConnectionString = aConnect
conn.Open "SELECT * from Users"

'Set objRec = Server.CreateObject("ADODB.Connection")


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

conn.Close

*********

An here's the new Erroe

*********

Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNMPNTW]ConnectionOpen (CreateFile()).

thanks for your help