Re: sql server login

"Eddy Chang" <EddyChang@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:341BF3CA-9CF0-4F7D-B89C-A4AAF4BBA959@xxxxxxxxxxxxxxxx
> Thank you for your reply.
>
> I tried both of your suggestions but the dialog box keeps appearing. Any
> other suggestion?
>
> Thank you
>
> --
> Eddy
>
>

The only other thing I can think of is to pass in NULL for the first
parameter...

Set MyDb = MyWs.OpenDatabase(0, dbDriverNoPrompt, False,
"ODBC;DSN=Servinca;user=sa;pwd=AA")

or

Set MyDb = MyWs.OpenDatabase(, dbDriverNoPrompt, False,
"ODBC;DSN=Servinca;user=sa;pwd=AA")

--
============
Frank Hickman
Microsoft MVP
NobleSoft, Inc.
============
Replace the _nosp@m_ with @ to reply.


.