Main Board > ODBC

pxpsql .ini config on linux

(1/2) > >>

michaelgreer:
I am using pxpsql 6.0 on a linux box, querying data on the same box.  I can easily access normalized tables defined in providex.ddf and .dde, but non-normalized tables as defined in a .ini file are not accessible.  I don't know how to tell the command line what .ini file to use.  Any input appreciated.

Devon Austen:
Use:

-i path
--ini-file path

The path nees to include the name of the INI file i.e. -i /pxplus/data/appdata.ini

The pxpsql command includes a help option -h or --help that lists all of the options including -i

Also the documentation covers this option as well and can be found here https://manual.pvxplus.com/?odbc/pxplus_sql_cmd_line_client.htm

michaelgreer:
Devon,

Perhaps I didn't explain that correctly.  I have configured ODBC into unixODBC.  In that context I don't know how to get an .ini file into use.  Michael

Devon Austen:
If you are trying to setup The PxPlus SQL ODBC driver on Linux you need to let the system know about where the ODBC driver is installed using /etc/odbcinst.ini and then define a DSN in /etc/odbc.ini.

You specify the inifile location as part of the DSN with the connections string keyword IniFile=

Details about setting up a UNIX/Linux PxPlus SQL ODBC driver can be found in the docs here: https://manual.pvxplus.com/?odbc/configuration_procedures/odbc_driver_configuration_unix_linux.htm details on the connection string keywords supproted by the Linux DSN definition can be found here: https://manual.pvxplus.com/?odbc/configuration_procedures/connection_string_keywords.htm

michaelgreer:
Devon,

The Docs don't reference the IniFile option, so that made it hard to ferret out.  Anyway, here is my DSN:
[FACTS]
Driver=PxPlus
Description=FACTS Data
Directory=/infor/facts78
IniFile=/infor/facts78/dict/FACTSDD.INI
Debug=1
LogFile=/tmp/odbc.log

I still get "File is not accessible".  Any other insight? I have worked around this, but would like to get it resolved if possible against future need. - thanks!

Navigation

[0] Message Index

[#] Next page