PxPlus User Forum

Main Board => Discussions => ODBC => Topic started by: Jeffrey Ferreira on January 21, 2022, 01:32:21 PM

Title: Getting a View to Show ODBC
Post by: Jeffrey Ferreira 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

Title: Re: Getting a View to Show ODBC
Post by: Devon Austen 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.

Title: Re: Getting a View to Show ODBC
Post by: Jeffrey Ferreira 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.