Easysoft ODBC-Sage Tetra CS/3 DriverHow do I set up another DSN to point to a different Easysoft Data Access Sage Tetra CS/3 installation? |
|
To set up an additional DSN you need to first set up the data source template and then run odbcinst to add the new data source into unixODBC.
A sample Template is included in
/usr/local/easysoft/sqi/tetra/dsn_template.sample
i. Open this file and replace [TETRA] with the new data source name.
ii. Change the tetra_path to point to your Easysoft Data Access Sage Tetra CS/3 installation.
iii. Modify the schema_path to point to the directory to contain the schema
files (for more information about these schema files refer to the
documentation).
iv. Save the changes under a new name.
v. Change to the directory /usr/local/easysoft/unixODBC/bin and execute the
following :
odbc_system_dsn=1
odbcinst -i -s -f <filename>
Replace <filename> with the name of the file that you have just created in
step iv above.
Now create a DSN on the PC to point to the new data source name.
The above creates a system wide data source which can now access a different Easysoft Data Access Sage Tetra CS/3 installation.