<div>
Hi Tomas, A feedback would be appreciated and Kindly let me know whether you got the issue resolved out or not.
</div>


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

<div>
<div class="content wysiwyg-content">
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:<br />
<br />
ODBC;Server=HDCServer;DSN=<wbr />MSPatient;<wbr />User ID=user;Password=password;<wbr /><br />
<br />
The ODBC source is pointing to MWDDF.ADD<br />
<br />
The error is that &quot;the table is a database table, it can not be opened as a free table&quot;<br />
<br />
The ODBC driver is installed. Any ideas ?
</div>
</div>


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 ?

Query to Medisoft Database

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.

Sybase Database

A miscellany is defined as a "collection of various pieces of writing by different authors", but it has come to mean something "Of items gathered or considered together of various types or from different sources" or "a collection or group composed of members or elements of different kinds". The word "miscellaneous" comes from the Latin word "miscere", meaning "to mix." You might have heard the expression "a mixed bag," which applies when you don't quite know what you're going to get. More commonly, a miscellaneous group is made up of an odd group of things that don't fit anywhere else.

Miscellaneous

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.