PxPlus User Forum

Main Board => Discussions => ODBC => Topic started by: Ben Alexander on October 11, 2018, 04:18:33 PM

Title: CatalogName
Post 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?

Title: Re: CatalogName
Post by: Devon Austen on October 12, 2018, 08:03:27 AM

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

Code: [Select]

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.

Title: Re: CatalogName
Post by: Ben Alexander on October 16, 2018, 10:53:36 AM

Thanks Devon, that put us in business.