help needed Logon Failed DAO Error

[bluerain25]

hello guys,

i need help on this error. when i tried to run a report (crystal report 10)in vb6 (source of data is from a query on a password protected database) a error is displayed (LogonFailed; Details: DAO Error Code: 0xbd7; SourceAO.Workspace;Description: NOT a valid password) but i already put the db password on the connection string. im sure im connected into my db because i can access the other data from it. when i remove the password the report is displayed with all the information needed to be displayed. i use ADODB in connecting to the database. im stuck for two days on the same error. anyone help please...

 

[RonRepp]

DAO is virtually extinct, which is why, I believe, you aren't getting any answers.

Try switching to ADO. Syntax is similar.

Also, post some code so that the experts (not me) can see what's happening.

I hope this helps.

Ron Repp

If gray hair is a sign of wisdom, then I'm a genius.

My newest novel: Wooden Warriors

http://www.repproductions.net

 

[SBerthold]

CR needs to also have the log-on info, as it needs to also open a sepearate connection to the db.

So, as RonRepp said, need more info and to know with what CR object you are using to open the report.

 

[Golom]

You should also note that, when an error occurs involving a DAO workspace, the system can generate multiple errors. For example a single error in an ODBC server call could generate an error from the server; another one from ODBC and yet another from DAO. All three refer to the same error but they can have distinctly different messages because they are being generated by different sub-systems.

The actual cause of the problem is the first error generated but what you see reported is the last error placed in the DAO.Errors collection.

You might want to iterate the DAO.Errors collection to see if you have multiple errors and are seeing only the last one being reported.

 

[bluerain25]

hi

its ok guys got it fixed alreaady.. thanks