Notifications
Clear all
Trading Post
9
Posts
6
Users
0
Reactions
83
Views
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
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
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
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
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
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
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
Here is what your database settings should look like in VFE......
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......
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......
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
[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
