• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 925
  • Last Modified:

Changing database connection at runtime on crystal reports

I would like an example of changing the odbc connection at runtime for crystal reports
i am using vb6, crystal reports 10, sqlserver 2000

i have a connection string that i used to connect to the sql server database
connectionstring = "PROVIDER=MSDASQL;DSN=epics;UID=sa;PWD=moonlite;"

thanks,
bhoward
0
BHoward
Asked:
BHoward
1 Solution
 
jay_s5Commented:
You should be able to change the database connection at runtime using the ConnectionProperties collection. I don't use CR anymore, but there used to be a documents folder in your Crystal Reports installation directory with a document called TechRef.pdf that included a description of the ConnectionProperties collection in there.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now