Kb Sql Odbc Driver Is Installed

When the Easysoft ODBC-SQL Server Driver is installed into unixODBC, entries for the standard driver ( Easysoft ODBC-SQL Server ) and the driver with SSL support ( Easysoft ODBC-SQL Server SSL ) are placed in odbcinst.ini.

The Easysoft ODBC-SQL Server Driver is installed on the computer where your applications are running.

Kb Sql Odbc Drivers Through The

ODBC applications access ODBC drivers through the ODBC Driver Manager and a data source.

The data source tells the Driver Manager which ODBC driver to load, which SQL Server instance to connect to and how to connect to it.

This chapter describes how to create data sources, use DSN-less connections and configure the Easysoft ODBC-SQL Server Driver.

Before setting up a data source, you must have successfully installed the Easysoft ODBC-SQL Server Driver.

For Easysoft ODBC-SQL Server Driver installation instructions, see Installation.

This section describes how to configure the Easysoft ODBC-SQL Server Driver to connect to a SQL Server database by using a data source or a DSN-less connection string.

There are two ways to set up a data source to your SQL Server data.

Create a SYSTEM data source, which is available to anyone who logs on to this Unix machine.

Create a USER data source, which is only available to the user who is currently logged on to this Unix machine.

By default, the Easysoft ODBC-SQL Server Driver installation creates a SYSTEM data source named SQLSERVERSAMPLE.

If you are using the unixODBC included in the Easysoft ODBC-SQL Server Driver distribution, the SYSTEM odbc.ini file is in etc.

If you built unixODBC yourself, or installed it from some other source, SYSTEM data sources are stored in the path specified with the configure option --sysconfdir directory.

If sysconfdir was not specified when unixODBC was configured and built, it defaults to usrlocaletc.

If you accepted the default choices when installing the Easysoft ODBC-SQL Server Driver, USER data sources must be created and edited in HOME.odbc.ini.

To display the directory where unixODBC stores SYSTEM and USER data sources, type odbcinst -j.

By default, you must be logged in as root to edit a SYSTEM data source defined in etcodbc.ini.

You can either edit the sample data source or create new data sources.

Each section of the odbc.ini file starts with a data source name in square brackets followed by a number of attributevalue pairs.

The Driver attribute identifies the ODBC driver in the odbcinst.ini file to use for a data source.

The Easysoft ODBC-SQL Server Driver distribution includes two drivers.

One with SSL support that should be used if you need to access SQL Server 2000 or later over an encrypted connection.

One without SSL support that should be used for SQL Server 2000 and later when encryption is not required and for SQL Server 7.0.

Kb Sql Odbc Drivers For Mac