Connecting CRS to a Database on a MS SQL Server using VB6

[mrericb]

Hello,

I am running a crystal decisions report throught VB6. I connect to the database to populate listboxes in VB, but when I attempt to run the report I recieve a message box from Crystal Smart Viewer saying "Server Has Not Yet Been Opened".

I would like to pass the connection string w/user name and password to CRS through the CRS Active X controller, but I am stumped when it comes to making it (or something similar) happen.

Thanks In Advance,

Eric

 

[kenhamady]

You need to log the report into the database using a command like:

.connect
.setlogoninfo
.logonserver

Which you use and syntax depends on how you are integrating the report into the app. Which integration method are you using? If not sure see the FAQ in the general forum on "Questions should include.." Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/