Easysoft ODBC-Firebird Driver Knowledge Base Articles

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

• Applications - Microsoft Access
  • I am getting #deleted with my MS Access linked table when connecting to a UNICODE_FSS Firebird table with a primary key defined on a VARCHAR field. What can I do?
  
  
• Applications - Microsoft Excel
  • Why do I receive the error "No ODBC driver is installed" when I try to retrieve data in Microsoft Excel for MAC?
  
  
• Applications - Apache
  • Why do not my PHP scripts appear to run on the web server?
  
  
• Applications - Oracle
  • 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
  • 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?
  • How do I transfer a license?
  
  
• General - Connection
  • I get "database is unavailable" when using the Easysoft driver with web servers. Why?
  • How do I connect to an remote Firebird Server via TCP?
  • Why do I get error "cannot restore segment prot after reloc: Permission denied"?
  
  
• General - Troubleshooting
  • I get "database is unavailable" when using the Easysoft driver with web servers. Why?
  • I have installed the ODBC driver yet when I add a data source I get "The setup routines for the EasysoftFBODBC could not be loaded due to system error code 1114". What can I do?
  • What action should I take when receiving the following error [Easysoft][Firebird]OS Version mismatch
  • When exiting isql after executing a query I get a segmentation fault error
  • When using Firebird I get unable to load GDS32.DLL even though it's in my System32 directory.
  • Why do I get "unsupported on-disk structure" when trying to use the driver?
  
  
• General - Solaris
  • Why do I get error "libodbc.so.1: open failed: No such file or directory"?
  
  
• Miscellaneous
  • What is a Unicode ODBC Driver and is the Easysoft driver one?
  • When do I need a Unicode Driver?
  • Can I use the Firebird driver with earlier versions of InterBase?
  • Does the Firebird driver provide support for rollback retaining?
  • Does the Firebird driver support Firebird roles?
  • Does the Firebird driver support InterBase 6.0 DATE, TIME, TIMESTAMP and INT64 data types?
  • Does the Firebird driver support multiple transactions on a single connection?
  • Does the Firebird driver support setting SQL Dialect at runtime?
  • I need an ANSI ODBC driver for Firebird can I use the Easysoft ODBC driver?
  • How do I turn unixODBC tracing on or off?
  • How do I generate a Windows ODBC trace?