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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ConnectionProperties change, Crystal RDC bug?

Status
Not open for further replies.

Bontebok

Programmer
Nov 18, 2002
63
US
Hi All,

I am writing an application that uses the Crystal Reports 9 RDC. I have found something strange and I am wondering if it is normal, if there are any workarounds, or if anyone else thinks this is a bug.

If a report with database tables to an access file is opened using OpenReport(), the connection properties of the tables are very strange.

If I enumerate through the ConnectionProperties, I get the following:

PreQEServerType: PDBDAO.DLL
PreQEServerName: C:\Program Files\Common Files\System\MAPI\1033\xtreme.mdb
UserID: Admin
Data File: C:\Program Files\Common Files\System\MAPI\1033\xtreme.mdb

None of the above ConnectionProperties are documented and when trying to call a documented property, such as "Database Name", it will fail with an error.

Now HERE is the really strange part.

If you open that same report twice, that is using the Application object, make a second call to OpenReport() with the same exact report, you now get these connection properties.

Database Name: C:\Program Files\Common Files\System\MAPI\1033\xtreme.mdb
Database Type: Access
Database Password: (write only)
Session UserID: Admin
Session Password: (write only)
Session Database Path: (blank string)

Which are the correct and documented ConnectionProperties.

What is going on? Any ideas? Go ahead and try it. I get the same results on any number of computers I try it on. I have also installed the latest Monthly hotfix and it doesn't fix it.

Jeremy
 
Jeremy,

Looks serious enough to submit as an e-mail issue to Crystal Support.

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top