PxPlus User Forum

Twitter Twitter Twitter

Author Topic: CatalogName  (Read 1967 times)

Ben Alexander

  • Member
  • **
  • Posts: 5
    • View Profile
CatalogName
« 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?

Devon Austen

  • Administrator
  • Diamond Member
  • *****
  • Posts: 382
  • Don’t Panic
    • View Profile
    • PVX Plus Technologies
Re: CatalogName
« Reply #1 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.
Principal Software Engineer for PVX Plus Technologies LTD.

Ben Alexander

  • Member
  • **
  • Posts: 5
    • View Profile
Re: CatalogName
« Reply #2 on: October 16, 2018, 10:53:36 AM »
Thanks Devon, that put us in business.