Changing Connection - Visual Basic 6 - Using Connection String
Posted on 2004-11-29
I'm currently using Crystal Report 9 Enterprise.
I've seen the previous topics about changing connection programatically using DSN / ODBC. What I want to ask if it is possible to use standard connection string from Visual basic 6 ?
For example, I have created a report using my local SQL 2000 server named SERVER-A. Now I'd like to deploy my report to other computer, which use another SQL 2000 server named SERVER-B with similar database. And I use datalink to set visual basic connection string. Is it possible for Visual Basic to transfer its connection string to Crystal Report ?
I have also tried to make a report using a datalink file, it works perfectly fine, but I encountered some 'annoying' problem. I found that Crystal report is unable to use Datalink file in relative path. How to change the datalink path of the report from Visual Basic ?
Thank you for your kind and helpful answers.