When creating my Crystal Report I obviously set up a database and server connection that I use for development.
What I want to do now in my VB application is to dynamically set the database and server name to use with the reports. I have these values as the strings varServer and varDatabase.
Anyone know how to go about doing this?
Thanks in advance.
P.S I have tried several online solutions but am having trouble with VB6.
Best Answer
This link has all information you want to know.
UPDATE: Here is a minimum working sample for integrated authentication with SQL Server. You should use the ConnectionProperties of the table object to set connection parameters.