CR 8.5 odbc connection in VB6

[pickie]

I am working on an international system with databases across the world. We started a conversion from legacy systems 3 years ago and started installing the new system a year ago.

Here is the problem. A programmer in another country set up a CR 8.5 report accessing sql 2000 with a hardcoded object.LogOnServer to their in country Server. We need to make these reports work for what ever is the local server.

I went into CR and Database, convert database driver, odbc. I then commented out object.LogOnServer line in the VB code. When I run it I get a Debug; "Error detected by database DLL". It stops on object.PrintOut.

I can not find any documentatiion on this subject, can anyone help me out here?

 

[pickie]

I have continued to search the internet on this subject. I was finally able to find some docs on the subject from Crystal reports. It said that I should "Verify Database". I did and lost my error. I am getting a blank report now however. I am assuming that is because I am not pointing at the right database so it is coming up empty.

 

[ucsjimj]

Hello, Be careful about assuming there is no data, simply because you have a blank screen. Often there is some problem with the selection routines on the data, or the matching and sorting is wrong, believe me, a lot of things can go wrong when a re-setting is being done.