Login failed for user ''

[Keith]

Using ASpDBProEval. Attempting to connect to SQL server 7.0
Using NT authentication. I was able to connect yesterday with AspDBFree but not today so I am trying ASpDBProEval and still I cannot connect?

ODBC reports "SUCCESS"

Yesterday this worked
Mydb.dbDSN="DSN=test"
After I added myself to the database as a user.

Today I get the Error Msg:
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ''.
/aspdbpro/test.asp, line 36
ANY IDEAS?

[John]

Hi Keith,

Try putting the userid and password on the DSN line. I.E.:

Mydb.dbDSN="DSN=test;UID=myID;PW=myPassWd"

Thanks,
John



------------
Keith at 12/3/99 6:40:16 PM

Using ASpDBProEval. Attempting to connect to SQL server 7.0
Using NT authentication. I was able to connect yesterday with AspDBFree but not today so I am trying ASpDBProEval and still I cannot connect?

ODBC reports "SUCCESS"

Yesterday this worked
Mydb.dbDSN="DSN=test"
After I added myself to the database as a user.

Today I get the Error Msg:
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ''.
/aspdbpro/test.asp, line 36
ANY IDEAS?

[Keith]

Thanks John for the quick responce,
But I have used every combination possible with using the exact UID and PWD you have described, but the variables don't seem to be picked up and it continues to kick back the same error.
Keith...


------------
John at 12/3/99 6:42:58 PM

Hi Keith,

Try putting the userid and password on the DSN line. I.E.:

Mydb.dbDSN="DSN=test;UID=myID;PW=myPassWd"

Thanks,
John



------------
Keith at 12/3/99 6:40:16 PM

Using ASpDBProEval. Attempting to connect to SQL server 7.0
Using NT authentication. I was able to connect yesterday with AspDBFree but not today so I am trying ASpDBProEval and still I cannot connect?

ODBC reports "SUCCESS"

Yesterday this worked
Mydb.dbDSN="DSN=test"
After I added myself to the database as a user.

Today I get the Error Msg:
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ''.
/aspdbpro/test.asp, line 36
ANY IDEAS?

[Frank]

Forget ASPdb for a minute and login using pure ASP first. That'll be the connect string (XXX) you use for X.dbDSN="XXX"

FK



------------
Keith at 12/3/99 6:46:59 PM

Thanks John for the quick responce,
But I have used every combination possible with using the exact UID and PWD you have described, but the variables don't seem to be picked up and it continues to kick back the same error.
Keith...


------------
John at 12/3/99 6:42:58 PM

Hi Keith,

Try putting the userid and password on the DSN line. I.E.:

Mydb.dbDSN="DSN=test;UID=myID;PW=myPassWd"

Thanks,
John



------------
Keith at 12/3/99 6:40:16 PM

Using ASpDBProEval. Attempting to connect to SQL server 7.0
Using NT authentication. I was able to connect yesterday with AspDBFree but not today so I am trying ASpDBProEval and still I cannot connect?

ODBC reports "SUCCESS"

Yesterday this worked
Mydb.dbDSN="DSN=test"
After I added myself to the database as a user.

Today I get the Error Msg:
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ''.
/aspdbpro/test.asp, line 36
ANY IDEAS?