Easysoft ODBC-Oracle Driver Knowledge Base Articles

• Applications - Apache
• Applications - Crystal Reports
• Applications - Oracle
• Applications - Informatica
• Applications - UniVerse
• Applications - UniData
• Interfaces - ODBC
• Languages - C
• Languages - PHP
• Languages - Perl
• General - Licensing
• General - Connection
• General - Solaris
• General - Applications/Interfaces/Drivers
• General - Programming
• General - Installation
• Miscellaneous

• Applications - Apache
  • Why do not my PHP scripts appear to run on the web server?
  
  
• Applications - Crystal Reports
  • Why do I get error "[HY000] [Easysoft][Oracle]ORA-00911: invalid character at offset xxxx" when running Crystal Reports?
  
  
• 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?
  
  
• Applications - Informatica
  • Why do I get error "libodbc.a(odbc.so) could not be loaded"?
  
  
• Applications - UniVerse
  • Why do I get error "libodbc.a(odbc.so) could not be loaded"?
  
  
• Applications - UniData
  • Why do I get error "libodbc.a(odbc.so) could not be loaded"?
  
  
• Interfaces - ODBC
  • Why does SQLRowCount/odbc_num_rows and $sth->rows return -1?
  • Why do I get error "libodbc.a(odbc.so) could not be loaded"?
  
  
• Languages - C
  • Where can I find information on how to develop C applications using the Easysoft ODBC-Oracle Driver?
  • 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?
  
  
• 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
  • When do I get error "[EasySoft]ORACLE_HOME not defined Error 69"?
  • Why do I get error "[Easysoft][Oracle]Error loading OCI.dll"?
  • Why do I get "[unixODBC][Easysoft][Oracle]Could not open libclntsh.so.8.0 or libclntsh.so.9.0. Can`t dlopen() a library containing Thread Local Storage: /usr/lib/libcl.2" when connecting to an Oracle data source?
  • Why do I get error "[unixODBC][Easysoft][Oracle]Could not open libclntsh.so.8.0 or libclntsh.so.9.0 error: ELFCLASS64"?
  • Why do I get error "[unixODBC][Easysoft][Oracle]Could not open libclntsh.a No such file or directory [ISQL]ERROR: Could not SQLConnect" on AIX?
  • How can I avoid setting shell environment variables required by a driver?
  • Does the Easysoft ODBC-Oracle Driver support connection pooling?
  • Why do I get error "Could not load oracle libraries" or "ORACLE_HOME environment variable not set"?
  • Why do I get error "ORA-12154: TNS:could not resolve the connect identifier specified"?
  • Why do I get error "'[unixODBC][Driver Manager]Can't open cursor lib 'libodbccr'" on AIX?
  • Why do I get error "cannot restore segment prot after reloc: Permission denied"?
  • Why do I get error "Client unable to establish connection: OS Error: 'Connection refused'"?
  • Why do I get error "Client unable to establish connection: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor"?
  • Why do I get error "ORA-01017: invalid username/password; logon denied"?
  • Why do I get error "Client unable to establish connection: 'Failed to find host address 'myhost'"?
  
  
• General - Solaris
  • Why do I get error "libodbc.so.1: open failed: No such file or directory"?
  
  
• General - Applications/Interfaces/Drivers
  • Does the Easysoft ODBC-Oracle Driver support SQLDescribeParam?
  
  
• General - Programming
  • Why do I get a memory leak when I create and free environment handles?
  
  
• General - Installation
  • How do I install an Easysoft ODBC driver on a machine where I have no root access?
  
  
• Miscellaneous
  • How can I obtain Oracle client software?
  • How do I stop my application segmentation faulting on exit when using the Easysoft ODBC-Oracle Driver with unixODBC?
  • How should I use the OCI_ATTR_PREFETCH_ROWS and OCI_ATTR_PREFETCH_MEMORY parameters?
  • Why do I get a memory leak using the Easysoft ODBC-Oracle Driver and a 9.2.0.1.0 Oracle client install?
  • Do you have a ODBC driver for Oracle on QNX?
  • Why do I get error "Unable to map datatype"?
  • How do I turn unixODBC tracing on or off?
  • How do I generate a Windows ODBC trace?
  • How do I handle signals when using the Oracle client libraries?