Query to Medisoft Database

Tomas Gonzalez
Tomas Gonzalez used Ask the Experts™
on
I'm trying to establish a connection to Medisoft database using ODBC but I can not get a connection established. This is the command string I'm putting in my application:

ODBC;Server=HDCServer;DSN=MSPatient;User ID=user;Password=password;

The ODBC source is pointing to MWDDF.ADD

The error is that "the table is a database table, it can not be opened as a free table"

The ODBC driver is installed. Any ideas ?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
SQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018
Commented:
Medisoft uses Sybase advantage database and hence your connection string should indicate whether the SERVERTYPE is LOCAL or REMOTE and change the connection string accordingly. Hope that's the reason you are getting above error.
Data Source=\\myserver\myvolume\mypat\mydd.add;User ID=myUsername;
Password=myPassword;ServerType=REMOTE;
More connection string options available for Sybase Advantage below.
https://www.connectionstrings.com/sybase-advantage/
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018

Commented:
Hi Tomas, A feedback would be appreciated and Kindly let me know whether you got the issue resolved out or not.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial