From: Primoz Bratina on
"CreateObject" works, "Open" doesnt
how to catch error and see what's wrong
(the same code works on my home computer)

thanks!
Primoz

code:
set myConn = CreateObject("ADODB.Connection")

myConn.open "PROVIDER=SQLOLEDB;DATA SOURCE=" & serverx & ";UID=" & uidx &
";PWD=" & pwdx & ";DATABASE=" & dbx