Still not working

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

Try this:

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")
Set rsResults = Server.CreateObject ("ADODB.Recordset")
conn.Mode = abModeReadWrite
conn.ConnectionString = aConnect
Set rsResults = conn.Execute( "SELECT * from Users")


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

conn.Close
rsResults.Close

---

Hey bubba

Thanks for the help ... it worked like a dream .. is see my fault!!!

Cheers!