Yes, PFXodbc allows applications that comply with the ODBC standard to retrieve and update the information stored in PFXplus and compatible file formats.
PFXodbc only locks files at update. Read does not lock files.
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.
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.
Yes, PFXodbc data source can be accessed from Microsoft Excel, Microsoft Word and Microsoft Access.
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.
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).
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.
Yes. PFXodbc enables you to access PFXplus data files created under any version of PFXplus.
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.
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).
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.
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.
PFXodbc 5.0 SP3 driver enables reading long text/binary fields. Previous versions of PFXodbc may have reported an error.
Yes, PFXodbc works on Windows 64 bit.
As it is a 32 bit driver, the System DSNs it uses can only be accessed through the 32 bit ODBC Administrator. User DSNs are accessible through either 32 0r 64 bit ODBC Administrator.
In Windows 7 this is the file odbcad32.exe which is located in %systemdrive%\Windows\SysWoW64.
In Windows 8, You should run "ODBC Administrator (32 bit)" which can be found in Control Panel --> Administrative Tools
For further information see this Microsoft support link.
Yes, PFXodbc runs without any problems on Windows 7? For PFXodbc installation instructions on Windows 7 click here.