Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Compile error

Status
Not open for further replies.

hansu

Programmer
Mar 12, 2002
89
When I create an .exe file of my project I keep receiving the following error message:
[Microsoft][ODBC Microsoft Access Driver] Invalid Password

I connect to a password protected access database with a connection string like:
strConn = "PROVIDER=MSDASQL; DSN=mydatabase; PWD=mt8901;"

So far I have not found what causes the error. Is there a way to find out where in the compiling process the error is generated?
Whe I run the .exe file the program seems to work fine.

Thanks for any help.
 
This is probably because you have an extra character at the end.

"PROVIDER=MSDASQL; DSN=mydatabase; PWD=mt8901;"

Should be (no ending semicolon):

"PROVIDER=MSDASQL; DSN=mydatabase; PWD=mt8901
 
Thanks for your suggestion Dimandja.
I removed the semicolons but for some reason I still get the same error. Any ideas?
 
Found the problem now:
Had an Adodc control where the connection string wasn't set correctly.
Really stupid.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top