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

VFE and CPS 10

Trading Post

Last Post by chrishuff1 12 years ago

9 Posts

6 Users

0 Reactions

66 Views

RSS

[email protected]

(@talontlcdoctors-com)

Posts: 86

Estimable Member

Topic starter

Looking for help connecting VFE (ver 4.01) to CPS 10.0. I read through all the documentation on connecting VFE to a database, I contacted VFE support, and I'm stumped. Funny thing is, I had VFE running smooth and playing nice with CPS just a few days ago before doing a clean install of Windows 7 Pro (and all other apps).

When launching VFE I get a "Connection Failed: SQLState: '28000' SQL Server Error: 18456 [Microsoft][SQL Server Native Client 10.0][SQL Server][Login Failed for user 'my username is here']." I know I'm using the correct username/password combo (the same i use to log into CPS). I even tried the master database credentials, which, strangely enough, gets me into VFE but will not load obs terms or libraries.

Any help is greatly appreciated. Thanks chuggers.

Separate issue: Has anyone successfully installed both CPS 10 and an evaluation version (for testing) on the same Windows 7 PC? When I try this, I lose the ability to use CPS 10. I get an error on the login screen "An unknown error occurred in the Service Layer request. ErrorCode: NO_ERROR". Super weird.

Posted : August 6, 2012 10:23 am

mj2718

(@mj2718)

Posts: 54

Trusted Member

Here is what I have for my VFE settings. The CPS datasource is an ODBC connection to the database that I created.

Posted : August 9, 2012 3:18 am

[email protected]

(@talontlcdoctors-com)

Posts: 86

Estimable Member

Topic starter

Thanks!

You said "a database that I created". Are you using an empty db or are you connecting to your practice's live db? I see that your db selection is the single user training - Oracle db. Is that the 9.5 eval db? Sorry, I don't know why I'm so confused over this...

Posted : August 9, 2012 3:26 am

jkratzer

(@jkratzer)

Posts: 138

Estimable Member

You need to point it to an active database that has it's information in your ODBC settings. When you install the CPS 10 client it automaticly creates it.

Should look something like this: CPOSservernameCentricityPS

You may also need to select "Use Trusted Connection"

Your alternate prefix is correct except it should be in lower case.

Posted : August 9, 2012 6:11 am

[email protected]

(@talontlcdoctors-com)

Posts: 86

Estimable Member

Topic starter

I pointed VFE to my active db: "CPOSmyservernameCentricityPS" using the alternate prefix: "dbo" still no dice.. also tried checking use trusted connection.

Alas and FYI to others, after speaking with our GE reseller I was told that it is theoretically possible to connect VFE to CPS version 10 but it is very tricky and not recommended. Instead, I installed the single user 9.5 training EMR on another workstation (that did not have our production CPS installed, because that doesn't work, it's a JBOSS issue) and connected 9.5 to VFE with no issue. This work-around isn't perfect as I now have to maintain the kits I am developing in both databases, but in a way it is a safer sandbox since I am not building/testing around real patient data.

Hope this helps someone else out there. Thanks to everyone who pitched in their ideas. You guys rock!

Posted : August 9, 2012 8:38 am

jkratzer

(@jkratzer)

Posts: 138

Estimable Member

Did you replace servername with the name of your CPS SQL server?

Check your ODBC settings to see what the link that was created when you installed the CPS client.

Posted : August 9, 2012 11:10 pm

rcarpenter

(@rcarpenter)

Posts: 43

Trusted Member

You can absolutely use it with CPS10. I didn't have any problem. Can you post a screenshot of your settings and also your ODBC connection? Maybe we can help that way.

The other option would be to contact VFE for help.

-Rachael

Posted : August 10, 2012 1:16 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

Here is what your database settings should look like in VFE......

vfe db settings

But you also need to make sure that you are setting up your ODBC connection via the correct (32-bit) version ODBC Data Sources.

Because you installed Windows 7 I'm assuming you installed the 64-bit version of Windows.

In my example above the CPS database I'm connecting to is CPS-AHECW. But if I go to Start > Control Panel > Administratinve Tools > Data Sources (ODBC) and click on the System DSN tab, I don't see the ODBC connection I need......

ODBC 64-bit

This is because I'm running Windows 7 64-bit and by default Windows only shows me 64-bit ODBC data sources which only work with 64-bit applications.

So since VFE is a 32-bit application we need to open the 32-bit version of the Data Sources (ODBC). To do this click Start > Run > C:\Windows\SysWOW64\odbcad32.exe

When I do this I see the following......

ODBC 32-bit

This is where any new ODBC connections need to be added in order for VFE (or any other 32-bit application) to work properly.

Good Luck!

Posted : October 29, 2012 5:13 am

chrishuff1

(@chrishuff1)

Posts: 201

Reputable Member

[email protected] said:

Any help is greatly appreciated. Thanks chuggers.

Separate issue: Has anyone successfully installed both CPS 10 and an evaluation version (for testing) on the same Windows 7 PC? When I try this, I lose the ability to use CPS 10. I get an error on the login screen "An unknown error occurred in the Service Layer request. ErrorCode: NO_ERROR". Super weird.

I would love to see a fix for this! if you have emr 9.5 and cps10 installed, cps will NEVER work while 9.5 is installed. i've spent HOURS with support trying to fix the same error you got only to find out the only fix is to uninstall 9.5. doing so immediately let me get into cps10. according to GE there is no fix. it's a huge pain to build my forms and test them in emr9.5 then have to remote into a secondary computer to make the new forms live.

Posted : October 31, 2012 5:16 am

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