Connection Error -2147217843

Receiving this error
ODBC SQL Server Login failed for user''..
NativeError 18452
when we try to launch an application using vb6.

I receive the error above when trying to run a vb6 program that uses sql
server authentication in the ODBC.
When I checked the ODBC for this DSN it tests fine.
It has been set up to use named pipes and tcpip and no matter the connection
type it always passes when testing the odbc. And always fires the error
above when launching the app.

I am not the programmer of the app, but can get someone to check/do things
as needed.
I just am at a loss on where to look.
Thank you

When I tried to import a database generated by MS POS to MS RMS, I have the
same error-2147217843. I know the logon info is correct.

"Tracey" wrote:

> Receiving this error
> ODBC SQL Server Login failed for user''..
> NativeError 18452
> when we try to launch an application using vb6.
>
> I receive the error above when trying to run a vb6 program that uses sql
> server authentication in the ODBC.
> When I checked the ODBC for this DSN it tests fine.
> It has been set up to use named pipes and tcpip and no matter the connection
> type it always passes when testing the odbc. And always fires the error
> above when launching the app.
>
> I am not the programmer of the app, but can get someone to check/do things
> as needed.
> I just am at a loss on where to look.
> Thank you