PxPlus User Forum
Main Board => Discussions => ODBC => Topic started by: Ben Alexander on October 11, 2018, 04:18:33 PM
-
We have just updated our pvx odbc and sql svr from 6.00 to 6.10 and now we are requierds to have a catalog defined for sql svr. Trouble is we have never defined a catalog before. If my providex.ddf is in directory /z/abcd how do we define a catalog that will use that and let the pxpsqlsvr run again?
-
Hi Ben,
Check out the pxpsqlsvr.conf.sample file that came with the installation for an example and a description.
You can also read the documentation about the new catalog setup for the server here https://manual.pvxplus.com/?odbc/configuration_procedures/server_settings_unix_linux.htm
Also for clarity here is an example from one of my pxpsqlsvr.conf files
catalogs:
default=*[/myapp/data][][]
In this example I defined a catalog named default which pointed to the data dictionary located at /myapp/data and it does not have an INI file or prefixes
In you ODBC client DSN under the server tab you would then specify default as the catalog name to connect to data from the /myapp/data dictionary.
This is so a server could define multiple catalogs and so that clients do not have to know anything about the server or where the data is on the server.
-
Thanks Devon, that put us in business.