Notifications
Clear all
Topic starter
I've been asked by our IT department to get directions on how to create an ODBC connection from Crystal reports to the copy of the Centricity EMR reporting database. I don't even know what ODBC means. Can anyone help me, hopefully in layman terms? Thanks.
Posted : July 17, 2012 1:24 am
On a Windows XP PC:
Click Start
Scroll up to Settings and click on Control Panel
Double-click on Administrative Tools
Double-click on Data Sources (ODBC)
Click on System DSN
Click Add
Enter Data Source Name ... Centricity Report Database
Enter Description ... Centricity Report Database
Enter TNS Service Name ... the name given to your report database in TNSNAMES.ORA
Enter User ID ... the user account set up for accessing the database
Click Test Connection
Enter Password ... corresponding to the User ID from above for accessing the database
Click OK
If a window pops up stating Connection Successful, then you have a proper connection to use within Crystal.
Click OK ... saves the settings
Click OK ... closes the ODBC Data Source Administrator window
Posted : July 17, 2012 2:01 am
The key bit in the above being that you need to edit TNSNAMES.ORA, found in something like c:\Program Files\Centricity EMR 9.5\Oracle\network\ADMIN, to include an entry for the new server. Copy and paste, and give it a new header, like "EMR_report.world", and change the IP to point at the new server. Everything else will probably stay the same.
Posted : July 17, 2012 2:06 am
Topic starter
You couldn't have described it any better! You're my hero! Thanks a million.
Posted : July 17, 2012 2:07 am
