Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

ODBC connection from Crystal Reports copied database to Centricity EMR

Trading Post

Last Post by Anonymous 1 second ago

4 Posts

3 Users

0 Reactions

87 Views

RSS

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

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

jjordet

(@jjordet)

Posts: 545

Honorable Member

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

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

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

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

Topic starter

You couldn't have described it any better! You're my hero! Thanks a million.

Posted : July 17, 2012 2:07 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0