Visual basic 6 sqlquery method to crystal reports 4.6 being ignored???
Posted on 2007-07-25
I have installed my program at a sister company. Everything works as expected except for some crystal reports.
A dynamic query is created in visual basic 6 and passed on to crystal reports.
e.g. crydo.sqlquery = "SELECT * from prints where filenr = 12345"
This works fine at my office, but here it doesn't want to work.
When I set a break point to cut n paste the query into query analyzer, it works fine.
In my office where use Windows Authentication and here I have to use SQL Authentication.
Both offices use ODBC connection for crystal reports data.
The server is running Windows 2003 SP2 with MS SQL 2000 SP4. Nothing else is running on this server.
All workstations are running XP SP2, fully up to date.