Validate connections

Hi.. its me ...again!! =P

I already open the connection.. but now.. i want to validate the errors..

anybody could help me with this...?

Take care

'Something like this?

'cnn is your adodb.connection
Dim myErr as ADODB.error

for Each myErr In cnn.Errors
Debug.print cnn.myErr.Description
Debug.print cnn.myErr.NativeError
Debug.print cnn.myErr.Number
Debug.print cnn.myErr.Source

next




Special thanks to Lothar "the Great" Haensler, Tom Archer, Chris Eastwood, TCartwright, Bruno Paris, Dr_Micahel
and all the other wonderful people who made and make Codeguru a great place.
Come back soon, you Gurus.

The Rater

that´s right... !

but now.. i have this little problem..
im trying to validate if i want a trusted connection (win nt) or using password and user.. (sql server 7)
But.. when im working with truste.. i can open the connection,,,, and if i want too use sql... i doesn´t work...

do u have any ideas?


take care!
from monterrey, mexico