PxPlus User Forum

Twitter Twitter Twitter

Author Topic: ODBC on Redhat  (Read 1420 times)

michaelgreer

  • Diamond Member
  • *****
  • Posts: 129
    • View Profile
ODBC on Redhat
« on: June 09, 2023, 01:19:07 PM »
This is configured for 64 bit on RH 7.9. unixODBC is installed.  If I do this:
[root@rhlinux etc]# /usr/pxpsqlodbc/pxpsql -d /facts93 LIST |grep AR_CUST
AR_CUST_BY_ALPHA
AR_CUST_BY_CLASS
AR_CUST_BY_CNTCT
AR_CUST_BY_DOC
AR_CUST_BY_PHONE
AR_CUST_BY_SLSP
AR_CUST_BY_ZIP
AR_CUST_CLASSES
AR_CUST_CLASSES_AKT
AR_CUST_CROSS_REF
AR_CUST_LDGCARDS
AR_CUST_MAST
AR_CUST_PRC_CLS
AR_CUSTOMER_HISTORY
AR_CUSTOMER_NOTES_A
AR_CUSTOMER_NOTES_B
AR_CUSTOMER_NOTES_C

You can see AR_CUST_MAST as a table. Good.  Now this:
[root@rhlinux etc]# /usr/pxpsqlodbc/pxpsql -d /facts/facts93 LIST table AR_CUST_MAST

ERROR: Invalid Table Name or No Columns Returned By LIST Columns Command.

Since (think) I know the table name is good, what would cause the column list to fail.  Providex.ddf shows the file, and the file has an embedded IO list (as well as an IO program, see attached.

Any insight appreciated. - Michael

Devon Austen

  • Administrator
  • Diamond Member
  • *****
  • Posts: 382
  • Don’t Panic
    • View Profile
    • PVX Plus Technologies
Re: ODBC on Redhat
« Reply #1 on: June 09, 2023, 02:44:17 PM »
In your first command you pointed to the data dictionary at /facts93. In the second command you pointed to the data dictionary /facts/facts93.

My guess is if you modify your second command to use -d /facts93 you would get what you want.
Principal Software Engineer for PVX Plus Technologies LTD.

michaelgreer

  • Diamond Member
  • *****
  • Posts: 129
    • View Profile
Re: ODBC on Redhat
« Reply #2 on: June 09, 2023, 03:04:43 PM »
Devon,  That was just me being sloppy.  /facts93 is a symbolic link to /facts/facts93. In order to eliminate that as the issue I changed everything to be /facts/facts93 in odbc.ini. If I issue the command with -d /facts/facts93 you see the success on the first and a fail on the second.

Devon Austen

  • Administrator
  • Diamond Member
  • *****
  • Posts: 382
  • Don’t Panic
    • View Profile
    • PVX Plus Technologies
Re: ODBC on Redhat
« Reply #3 on: June 09, 2023, 03:11:32 PM »
I think the command you want is

/usr/pxpsqlodbc/pxpsql -d /facts/facts93 LIST AR_CUST_MAST

After LIST you just specify the table name not the word table and then the table name.
Principal Software Engineer for PVX Plus Technologies LTD.

michaelgreer

  • Diamond Member
  • *****
  • Posts: 129
    • View Profile
Re: ODBC on Redhat
« Reply #4 on: June 09, 2023, 03:17:59 PM »
You are correct sir.  Long week I guess. Thanks.