ODBC password

[keenanbr]

When I call a Crystal Report (Ver 11) from VB it prompts me for the ODBC password. How can I stop this.

Regards,

Brian

 

[kskid]

It's the username and password for the database you are accessing.

-lw

 

[paulmarr]

Try hard coding the username/password in the System DSN ODBC connection you are using.

Cheers
paulmarr

 

[keenanbr]

tHIS IS WHAT i'M DOING
crxApplication.LogOnServer "crdb_odbc.dll", "dns", "", "USER", "PASSWORD

 

[abaldwin]

Quick check on Business objects web site.

http://support.businessobjects.com/forums/message.asp?fid=251&sk=5&ps=25&pn=1&mid=143011

"Crystal XI LogOnServer does not pass password

8/14/2005 4:34:48 AM


EJThunder

The .LogOnServer method was depricated from the RDC in v9. I think it was retired in v10. In any event, tt hasn't worked for a long time.

You'll need to move to the .ConnectionProperties method to pass your logon information. There's a document on Crystal's site about using .ConnectionProperties - it's called cr_rdc9_connectionproperties.pdf. Even though it's for CR9, the code will be essentially the same for CR10/XI. You can search for it at

http://support.businessobjects.com/search."

Andy

Andy Baldwin

"Testing is the most overlooked programming language on the books!