PFXodbc FAQ
Does the PFXodbc Driver offer Read/Write access to PFXplus data files from ODBC-compliant 3rd party applications?
Yes, PFXodbc allows applications that comply with the ODBC standard to retrieve and update the information stored in PFXplus and compatible file formats.
Does the PFXodbc Driver lock the data file it accesses?
PFXodbc only locks files at update. Read does not lock files.
Does the PFXodbc Driver work on Windows XP Professional?
Yes, PFXodbc works on Windows XP Professional, however on some systems it may require a patch to the ODBCAD32.EXE file. The utility for this is provided free of charge to all PFXodbc 5.0 owners who are members of the VAR programme.
Does the PFXodbc Driver work on Windows 2000 Professional?
Yes, PFXodbc works on Windows 2000, however may require a patch to ODBCAD32.EXE. The utility for this is provided free of charge to all PFXodbc 5.0 owners who are members of the VAR programme.
Does the PFXodbc Driver support MS Excel and MS Word?
Yes, PFXodbc data source can be accessed from Microsoft Excel, Microsoft Word and Microsoft Access.
What if MSQRY32 error message appears?
If a "MSQRY32 caused a stack fault in module PFXODBC.DLL" error message appears when trying to access an ODBC data source (for example from Microsoft Excel), usually a patch has to be applied to MSQRY32.EXE that increases its stack size.
How do I speed up my SQL joins when I use the PFXodbc Driver?
SQL joins are generally quite slow. The speed of SQL joins mostly depends on the query optimizer. Generally, if the joined fields are indexed, the join is faster.
You can also experiment with reordering the SQL statement, until you find an order that is faster. (This again depends on the query optimizer).
Does the PFXodbc Driver update PFXplus index files?
Yes. Whenever a new record is added or a record is modified in a PFXplus data file via PFXodbc , the driver updates the index (es) accordingly.
Can I use the PFXodbc Driver to access my data file regardless of PFXplus version?
Yes. PFXodbc enables you to access PFXplus data files created under any version of PFXplus.
Does the PFXodbc 5.0 Driver work on Windows Server 2000/2003?
PFxodbc is a client software that can be installed on any Windows 32 bit PC, including server PCs. A multi-user PFXodbc 5.0 driver installed on a server will allow a licensed number of users to access the ODBC data source created from PFXplus or compatible data files. Windows server 2000/2003 installations of PFXodbc may require a stack size increase to the odbcad32.exe file. The utility for this is provided free of charge to all PFXodbc 5.0 owners who are members of the VAR programme.
Does the PFXodbc 5.0 Driver work on Win NT Terminal Server?
Yes, a multi-user PFXodbc 5.0 driver can be installed on a terminal server, and a licensed number of users will be able to access the ODBC data source created from PFXplus or compatible data files. The file dhstodbc.ini needs to be in the directory where windows can find it (for example in c:\WINTSV).
Does the PFXodbc 5.0 Driver work on Win 2000 Terminal Server?
Yes, a multi-user PFXodbc 5.0 driver works well on a Win 2000 terminal server. However, a patch to the odbcad32.exe file is sometime required. If you experience difficulties creating DSN on a Win 2000 terminal server, contact our technical support. Please always quote the registration details of your odbc driver.
What if I get an error "-20051 Too many indexes in this table?
This error is sometimes reported by the PFXodbc 5.0 driver on tables where the number of index segments is over the internal limit of the driver. Service Pack 3 for PFXodbc no longer reports this as an error and does not process index segments above its internal limit. A work-around is to decrease the total number of index segments on the table and create a data source from the modified table.
Does the driver support long text/binary fields?
PFXodbc 5.0 SP3 driver enables reading long text/binary fields. Previous versions of PFXodbc may have reported an error.