Oracle ODBC driver knowledge base
- Product information
- Applications
- Licensing
- Installation
- Troubleshooting: Connection and authorisation
- Troubleshooting: ODBC
- Troubleshooting: Perl
- Troubleshooting: PHP
- Troubleshooting: Miscellaneous
-
Product information
- Do you have an Oracle ODBC driver for QNX?
-
Does the client-based Oracle ODBC driver support
SQLDescribeParam? - Does the Oracle ODBC driver support connection pooling?
- How can I obtain Oracle client software?
-
How do I use the Oracle ODBC driver's
OCI_ATTR_PREFETCH_ROWSandOCI_ATTR_PREFETCH_MEMORYattributes? - Where can I find information on how to develop C applications using the Oracle ODBC driver?
-
Applications
- How do I connect Arcplan to an database that supports ODBC?
- How do I connect Go on Linux to a database that supports ODBC?
- How do I connect Logi INFO to an database that supports ODBC?
- How do I connect Microsoft Access to an database that supports ODBC?
- How do I connect TARGIT to an database that supports ODBC?
-
Licensing
- Can I have the Easysoft licenses file on an NFS share referenced by multiple machines?
- Can I save or restore copies of my Easysoft licenses on Windows?
- Can I save or restore copies of the Easysoft licenses file on UNIX and Linux?
- How do I automate an Easysoft license request on UNIX or Linux?
- How do I know if I'm exceeding the connection limit imposed by my Easysoft license?
- How do I license an Easysoft product after the installation finishes?
- How do I transfer an Easysoft license from one UNIX or Linux machine to another?
- How do I transfer an Easysoft license from one Windows machine to another?
- How do I transfer an Easysoft license?
- How do I upgrade my Easysoft license on UNIX or Linux?
- How do I upgrade my Easysoft license on Windows?
- Is it possible to obtain a second Easysoft trial license?
- What are the different methods for obtaining an Easysoft license?
- What happens to my Easysoft licenses when I uninstall a product?
- What is an Easysoft license key?
- What is online and offline Easysoft licensing?
- Where are my Easysoft licenses stored?
- Where do I send Easysoft license requests?
- Why am I refused an Easysoft trial license with the message "a license has already been provided for this machine "?
- Why can't I connect to the Easysoft License Daemon?
- Why do I get "error HY000:0:0[unixODBC][Easysoft ODBC]General error: Failed to initialise licensing - No valid licenses for this product found, return code 3"?
- Why do I get an Easysoft licensing error stating the application was unable to create a semaphore?
- Why haven't I had a reply to the email I sent to
autolicense@easysoft.com?
-
Installation
-
Troubleshooting: Connection and authorisation
- I get the error "ORACLE_HOME environment variable not set" when using an Easysoft product. What can I do?
- 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 "[Easysoft][Oracle]Error loading OCI.dll"?
- Why do I get error "[EasySoft]ORACLE_HOME not defined Error 69"?
- 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?
- Why do I get error "Client unable to establish connection: 'Failed to find host address 'myhost'" when using the Oracle ODBC driver?
- Why do I get error "Client unable to establish connection: OS Error: 'Connection refused'" when using the Oracle ODBC driver?
- Why do I get error "Client unable to establish connection: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor" when using the Oracle ODBC driver?
- Why do I get error "Could not load Oracle libraries" or "ORACLE_HOME environment variable not set" when using the Oracle ODBC driver?
- Why do I get error "ORA-01017: invalid username/password; logon denied" when using the Oracle ODBC driver?
- Why do I get error "ORA-12154: TNS:could not resolve the connect identifier specified" when using the Oracle ODBC driver?
-
Troubleshooting: ODBC
- How do I find out why an ODBC call is failing?
- Why does
SQLRowCount,odbc_num_rowsand$sth->rowsreturn-1? - How can I avoid setting shell environment variables required by an ODBC driver?
- How do I turn unixODBC tracing on or off?
- How do I use an
odbcinst.iniorodbc.inifile that's not located in/etc? - isql fails to run with "error while loading shared libraries: libncurses.so.4: cannot open shared object file: No such file or directory." What can I do?
- What does "[Easysoft ODBC][unixODBC][Driver Manager]Can't initiate unicode conversion" mean?
- Why do I get error "'[unixODBC][Driver Manager]Can't open cursor lib 'libodbccr'" on AIX?
- Why do I get error "Data source name not found and no default driver specified"?
- Why do I get error "libodbc.a(odbc.so) could not be loaded"?
- How can I create an ODBC data source on Windows without using ODBC Data Source Administrator?
- How do I generate a Windows ODBC trace?
- Why do I get an empty ODBC Driver Manager trace file when using a SQL Server Linked Server?
- Why do I get error "The specified DSN contains an architecture mismatch between the Driver and Application"?
- Why do I get a "transaction already started" error when calling a procedure?
- Why doesn't a query return recently inserted data?
- Why do I get "database is unavailable" when using an Easysoft ODBC driver with a web server?
- Why do I get error "cannot restore segment prot after reloc: Permission denied" when using an Easysoft ODBC driver?
- Why do I get error "libodbc.so.1: open failed: No such file or directory"?
-
Troubleshooting: Perl
- Do I have to set the
DBI_DSN,DBI_USERandDBI_PASSenvironment variables before running my Perl script? - How can I debug my Perl DBI and DBD::ODBC?
- How do I supply connection string attributes in my Perl
DBI->connectcall? - Why can't I insert timestamps with DBD::ODBC 0.32?
- Why do I get "Makefile:311: *** missing separator. Stop." when building Perl DBD::ODBC?
- Why do I get "SQLSetConnectOption err=-2" errors in my Perl scripts
- Why do I get "undefined symbol: SQLParamData" when testing DBD::ODBC?
- Why do I get compile errors building Perl DBD::ODBC on AIX?
- Why do I keep getting data truncated errors in my Perl?
- Why do my Perl scripts complete but end in a segmentation violation?
- Why does make test for Perl DBD::ODBC fail with "invalid object name" errors?
- Why does make test in DBD::ODBC to SQL Server fail?
- How do I pass
LD_LIBRARY_PATHdown to CGI programs from Apache? - I don't like
odbc.iniin the same directory as my PHP or Perl script, as the file contains passwords. What do I do?
- Do I have to set the
-
Troubleshooting: PHP
- Can I use PHP with multiple ODBC drivers?
- How can I find out why my PHP script isn't working?
- How do I tell Apache to pass PHP scripts to the PHP interpreter?
- How do I use a PHP ODBC extension that's more recent than my version of PHP?
- How do I work with Unicode data when using PHP's ODBC extensions?
- I'm having problems with persistent connections in PHP. What could be the cause?
- In PHP, why can I only use or get column names of up to 30 characters when my database supports much longer column names?
- Why are my PHP ODBC settings changes ignored?
- Why can't Apache and PHP find my
odbc.inifile? Why do I get the error "Datasource not found and no default driver"? - Why does
phpinfo()display "Active Persistent Links of 0/1" when I know there are more open connections to my database? - Why doesn't PHP's
max_persistentsetting limit the total number of ODBC connections to my database? - Why don't my PHP scripts run under my web server?
- Why is my column data truncated at 4096 bytes when using PHP?
- How do I pass
LD_LIBRARY_PATHdown to CGI programs from Apache? - I don't like
odbc.iniin the same directory as my PHP or Perl script, as the file contains passwords. What do I do?
-
Troubleshooting: Miscellaneous
- How do I handle signals when using the Oracle client libraries?
- How do I stop my application segmentation faulting on exit when using the Oracle ODBC driver with unixODBC?
- I get a memory leak when I create and free environment handles in the Oracle ODBC driver. What can I do?
- Why do I get a memory leak when using the Oracle ODBC driver with build 9.2.0.1.0 of the Oracle client?
- Why do I get error "[HY000] [Easysoft][Oracle]ORA-00911: invalid character at offset xxxx" when running Crystal Reports?
- Why do I get error "Unable to map datatype" when using the Oracle ODBC driver?