![]() ![]() To display the directory where unixODBC stores SYSTEM and USER data sources, type odbcinst -j.īy default, you must be logged in as root to edit a SYSTEM data source defined in /etc/odbc.ini. 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. If sysconfdir was not specified when unixODBC was configured and built, it defaults to /usr/local/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 you are using the unixODBC included in the Easysoft ODBC-SQL Server Driver distribution, the SYSTEM odbc.ini file is in /etc. There are two ways to set up a data source to your SQL Server data:Ĭreate a SYSTEM data source, which is available to anyone who logs on to this Unix machine.Ĭreate a USER data source, which is only available to the user who is currently logged on to this Unix machine.īy default, the Easysoft ODBC-SQL Server Driver installation creates a SYSTEM data source named. The section assumes you are, or are able to consult with, a database administrator. 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. Configuring the Easysoft ODBC-SQL Server Driver.This chapter describes how to create data sources, use DSN-less connections and configure the Easysoft ODBC-SQL Server Driver.īefore setting up a data source, you must have successfully installed the Easysoft ODBC-SQL Server Driver.įor Easysoft ODBC-SQL Server Driver installation instructions, see Installation. 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. ODBC applications access ODBC drivers through the ODBC Driver Manager and a data source. The Easysoft ODBC-SQL Server Driver is installed on the computer where your applications are running. ![]() Easysoft ODBC-SQL Server Driver User's Guide - ConfigurationĬonfiguring the Easysoft ODBC-SQL Server Driver ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |