Difference between revisions of "ODBC: Data Source Configuration"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) (→Linux) |
Yvonnemilne (Talk | contribs) (→Linux) |
||
Line 40: | Line 40: | ||
<pre> | <pre> | ||
[Recital] | [Recital] | ||
− | Description | + | Description = Recital ODBC Driver |
− | Driver | + | Driver = /opt/recital/drivers/libodbc_recital.so |
− | Setup | + | Setup = /opt/recital/drivers/libodbc_recital.so |
− | FileUsage | + | FileUsage = 1 |
− | UsageCount | + | UsageCount = 1 |
</pre> | </pre> | ||
Revision as of 14:15, 22 June 2010
Note: CLIENTLOGGING=TRUE;CLIENTLOGFILE=trace.txt;
Windows
Linux
To determine the location of the configuration files:
# odbcinst -j
Will return output similar to the following:
unixODBC 2.2.11 DRIVERS............: /etc/odbcinst.ini SYSTEM DATA SOURCES: /etc/odbc.ini USER DATA SOURCES..: /root/.odbc.ini
The Recital Driver information can be seen in the 'odbcinst.ini' file:
[Recital] Description = Recital ODBC Driver Driver = /opt/recital/drivers/libodbc_recital.so Setup = /opt/recital/drivers/libodbc_recital.so FileUsage = 1 UsageCount = 1
The Recital installer also adds the following DSN to the system 'odbc.ini' file:
[Recital ODBC test] Driver = Recital DATABASE= ODBC:RECITAL:SERVERNAME=?;USERNAME=?;PASSWORD=?;DATABASE=odbc_test;
Note: The '?' can be used for the servername, username and password where the data is on the local server and DB_LOCAL_LOGIN is enabled.
[southwind] Driver = Recital DATABASE = ODBC:RECITAL:SERVERNAME=192.168.1.3;USERNAME=user;PASSWORD=password;DATABASE=southwind; [dir_test] Driver = Recital DATABASE = ODBC:RECITAL:SERVERNAME=192.168.1.3;USERNAME=user;PASSWORD=password;DIRECTORY=/opt/recital/data/odbc_test; [odbc_test] Driver = Recital DATABASE = ODBC:RECITAL:SERVERNAME=192.168.1.3;USERNAME=user;PASSWORD=password;DATABASE=odbc_test;