If you response.write your connection string, do you see what you'd expect
to see, i.e. a user ID and a password? And is your server able to resolve
XXX? Also, do you have adUseClient constant defined somewhere?
Ray at work
"gEEnesis" <gE******@discussions.microsoft.com> wrote in message
news:21**********************************@microsof t.com...
"Ray Costanzo [MVP]" wrote: Perhaps showing a bit of code would help, i.e. your connection string.
Ray at home
With objConexion
If .State = 1 Then .Close
.ConnectionString = "Provider=MSDASQL.1;Persist Security Info =
False;User ID=" & strUser & ";pwd=" & strPassword & ";Data Source=XXX"
.CursorLocation = adUseClient
.Open
If .State = 1 Then ftnConecta = True
End With
Is that what you need?
Thanks in advanced