How to connect to ComputerEase database via ODBC

Those supporting an accounting department that uses ComputerEase software may have found that there isn’t much documentation on how to interface with the software. There may be some sort of training available, but it probably isn’t inexpensive.

I do not believe any modification of the UI is possible as the software doesn’t seem to provide any sort of plug-in architecture, however after a fair amount of guess and check research, we discovered a couple ways to connect to the ComputerEase database.

These are the connection strings that worked for us. The 0 in both cases refers to the specific company database to which you wish to connect. I’ve added line breaks to this post for readability.

DSN-less

“DRIVER={ComputerEase};
DBQ=C:compeaseDirNameHereData;
uid=userHere;pwd=passwordHere;"

With DSN

"Dsn=Company 0;uid=userHere;pwd=passwordHere;"

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s