From Crystal Manager for Sage CRM
Jump to: navigation, search

This is an example of how you would use ODBC to connect to an access database.

Open 32 bit ODBC (The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder.) and create a new data source

Newds.png

Select the appropriate driver and set up the details

Newdsdetails.png

When creating the report connect via the ODBC (RDO) connection

Odbcrdo.png

Within CRM and Crystal Manager add the report and view the connection details

Crystalconnected.png

Copy the servername and click on the config tab in crystal manager. Set the value in one of the settings to match the expected crystal connection.

Dbconfig2.png