TOPIC: database access

database access 19 Apr 2011 20:42 #783

  • aambler
  • aambler's Avatar
  • Offline
My client uses Logicity Pro to read Crystal XI reports of Dynamics GP10 data. One user recently received a new workstation. She received and entered a new registration key from Logicity. When she opens a report in Pro, the report opens fine but when she refreshes the report, the server name is the ODBC, database is blank, and using the same login and password as before, the database access is denied. The ODBC "VTC" has been installed on her new workstation and matches the old computer and the test connection succeeded. The new workstation is Windows 7 64-bit, the old computer was Windows XP, SP3. Also, the toolbar is blacked out, but you can click on the icon location and the correct function is triggered.

Please advise.
Thanks,
Claude
The administrator has disabled public write access.

Re:database access 19 Apr 2011 21:58 #784

  • aellis
  • aellis's Avatar
Claude,

I think the problem is that on Windows 64-bit there are actually 2 control panels: one for 32-bit applications and another for 64-bit applications. The one for 64-bit is presented by default but Logicity is statically built for 32-bit (due to requirements of the Crystal Reports Runtime). Here is how to get to that 32-bit version of the ODBC control panel:

- Click the Start button.
- In the 'Run' box type 'ODBC'
- In the results presented on the start menu, click '32-bit Data Source (ODBC)'.

And add your ODBC data source there. That should get you going.

Take care,
Adam
The administrator has disabled public write access.