Multiple Databases in Crystal 8.5 and VB6 Viewer
Posted on 2006-06-23
I have to 2 applications: MAS200 and Sage CRM. They use a Providex DB and a SQL DB respectively. I have a crystal report that pulls information from both of these databases using ODBC and it works well.
I am trying to add the crystal report viewer functionality to a VB6 toolbar for users to run their own reports. Everything works fine when I only run a report that uses the SQL DB. But as soon as I try to run a report that uses both DB's, i get a "Server has not yet been opened".
I tried using the .Database.LogonServer and it only works for the SQL ODBC Connection
Set report = crapp.OpenReport(myreport)
report.Database.LogOnServer "p2sodbc.dll", "Sage CRM", , "sa", "password"
report.Database.LogOnServer "p2sodbc.dll", "SOTMAS90", "SAM", "adm", "password"
Is this even Doable? If so, can anyone help me please!!! I need to put both DB's information on one report!
MANY MANY THANKS TO ANY HELP!!