Easysoft ODBC-InterBase Driver Knowledge Base Articles

• Applications - Microsoft Access
• Applications - Apache
• Applications - Oracle
• Interfaces - ODBC
• Languages - PHP
• Languages - Perl
• Languages - C
• Languages - Visual Basic
• General - Licensing
• General - Connection
• General - Troubleshooting
• General - Solaris
• General - Applications/Interfaces/Drivers
• Miscellaneous

• Applications - Microsoft Access
  • I am getting #deleted with my MS Access linked table when connecting to a UNICODE_FSS Interbase table with a primary key defined on a VARCHAR field. What can I do?
  
  
• Applications - Apache
  • Why do not my PHP scripts appear to run on the web server?
  
  
• Applications - Oracle
  • Why do I get error "Initialization function SQLAllocConnect not found" when using Oracle Heterogenous Services (hsODBC) on AIX?
  • Why do I get error "Generic Connectivity Using ODBC][C077] Could not find symbol 'SQLAllocConnect' in dynamic library"?
  • My queries take minutes to complete when using Oracle’s HSODBC gateway. What can I do?
  • I get "error diagnosed by Net8 when connecting to an agent" when using DG4ODBC/HSODBC. What can I do?
  
  
• Interfaces - ODBC
  • Why does SQLRowCount/odbc_num_rows and $sth->rows return -1?
  
  
• Languages - PHP
  • Why does SQLRowCount/odbc_num_rows and $sth->rows return -1?
  • Why do not my PHP scripts appear to run on the web server?
  
  
• Languages - Perl
  • Why does SQLRowCount/odbc_num_rows and $sth->rows return -1?
  
  
• Languages - C
  • Why does SQLRowCount/odbc_num_rows and $sth->rows return -1?
  
  
• Languages - Visual Basic
  • Using Microsoft ActiveX Data Objects (ADO) from Microsoft Visual Basic or Visual Basic for Applications (VBA), how do I connect to my InterBase database without setting up an ODBC data source?
  • Why do I get the error "Multiple-step OLE DB operation generated errors" when using Microsoft ActiveX Data Objects (ADO) to write to BLOBs?
  
  
• General - Licensing
  • What happens to my licenses when I uninstall the product?
  • What is a license key?
  • What are the different methods for obtaining a license?
  • What is online and off line licensing?
  • Where do I send license requests?
  • How do I restart the licensing procedure after I have quit the install?
  • Where are my licenses stored?
  • Can I save/restore copies of my licenses?
  • Can I save/restore copies of the licenses file on Unix and Linux?
  • Can I have the licenses file on an NFS share referenced by multiple machines?
  • Why can't I connect to the License Daemon?
  • Why have I not yet had a reply to the email I sent to autolicense@easysoft.com?
  • Why am I refused a trial license with a message saying a license has already been provided for this machine?
  • Is it possible to obtain a second trial license?
  • Why do I get a license error stating the application was unable to create a semaphore when attempting to connect an ODBC compliant application to my Easysoft application?
  • I have input my registered InterBase ODBC Driver license but it still expires after 7 days. Why?
  • How do I transfer a license?
  • How do I transfer an Easysoft license from one UNIX/Linux machine to another?
  • How do I transfer an Easysoft license from one Windows machine to another?
  • How do I upgrade my Easysoft license on Unix or Linux?
  • How do I upgrade my Easysoft license on Windows?
  
  
• General - Connection
  • I get "database is unavailable" when using the Easysoft driver with web servers. Why?
  • How do I connect to an remote InterBase Server via TCP?
  • When trying to make a test connection why do I get an 'Unable to complete network request to host <database>. Failed to locate host machine. Undefined service gds_db/tcp error?
  • When I try to connect I get: [Easysoft][Interbase]Dynamic SQL Error, SQL error code=-804
  • Why do I get error "cannot restore segment prot after reloc: Permission denied"?
  
  
• General - Troubleshooting
  • Why do I get "unsupported on-disk structure" when trying to use the driver?
  • I am receiving the following error message "GDS32.DLL not found". What is the problem?
  • I am receiving the following error message "GDS32 out of date". What is the problem?
  • I get "database is unavailable" when using the Easysoft driver with web servers. Why?
  • What action should I take when receiving the following error [Easysoft][InterBase]OS Version mismatch
  • When exiting isql after executing a query I get a segmentation fault error
  • I have installed the ODBC driver yet when I add a data source I get "The setup routines for the EasysoftIB7ODBC could not be loaded due to system error code 1114". What can I do?
  • Why do I get the error "Unable to load IBCLIENT64.dll"?
  
  
• General - Solaris
  • Why do I get error "libodbc.so.1: open failed: No such file or directory"?
  
  
• General - Applications/Interfaces/Drivers
  • Is there a way I can call SQLRowCount if I am using the ODBC driver via ADO?
  
  
• Miscellaneous
  • Does the InterBase driver support multiple transactions on a single connection?
  • Does the InterBase driver support setting SQL Dialect at runtime?
  • Does the InterBase driver provide support for rollback retaining?
  • Does the InterBase driver support IB roles (feature available in IB 5.x)?
  • How much does your driver conform with the latest ODBC standard?
  • How does the Easysoft driver compare to the ODBC driver which shipped with InterBase 5.x on Windows?
  • What are the differences between the Easysoft driver and the Merant ODBC driver?
  • Can I use the InterBase driver with earlier versions of InterBase?
  • What level of ODBC compliance is supported?
  • What is a Unicode ODBC Driver and is the Easysoft driver one?
  • When do I need a Unicode Driver?
  • I need an ANSI ODBC driver for Interbase can I use the Easysoft ODBC driver?
  • Do you support InterBase 7?
  • How do I turn unixODBC tracing on or off?
  • How do I generate a Windows ODBC trace?