PxPlus User Forum

Twitter Twitter Twitter

Author Topic: Getting a View to Show ODBC  (Read 972 times)

Jeffrey Ferreira

  • Diamond Member
  • *****
  • Posts: 175
  • I must have taken a wrong turn at Albuquerque.
    • View Profile
Getting a View to Show ODBC
« on: January 21, 2022, 01:32:21 PM »
Hi List,

I'm trying to start using Views to make complex file linking easier for our customers. I'm having trouble getting the Views to display in my ODBC DSN.  I see the views dll...i dont have that filled in...can someone give me some pointers.

jeff

Devon Austen

  • Administrator
  • Diamond Member
  • *****
  • Posts: 382
  • Don’t Panic
    • View Profile
    • PVX Plus Technologies
Re: Getting a View to Show ODBC
« Reply #1 on: January 21, 2022, 02:22:22 PM »
From the docs: https://manual.pvxplus.com/PXPLUS/odbc/configuration_procedures/odbc_driver_configuration_windows.htm

Path to Views DLL
   
Path to pvxwin32.dll (Windows) or libpvx.so (UNIX/Linux). This is required by the PxPlus SQL ODBC Driver in order to use the Views system (PxPlus Version 5.10 or later).

The pvxwin32.dll is found in the PxPlus Install directory so an example value of the this field would be

C:\PVX Plus Technologies\PxPlus 2021 Upd 2\

we want the directory where it is found and not the [path to the DLL. So don't put the dll name in just the dir.
Principal Software Engineer for PVX Plus Technologies LTD.

Jeffrey Ferreira

  • Diamond Member
  • *****
  • Posts: 175
  • I must have taken a wrong turn at Albuquerque.
    • View Profile
Re: Getting a View to Show ODBC
« Reply #2 on: January 21, 2022, 03:02:05 PM »
Hi Devon,

Thank you that worked but my excel is locking up trying to query the View.
I tried it with another view that someone else created and I had same issue.
Small Views seem to work fine.
I think I might have to just make an interim file.

thanks for you help though.