Easysoft ODBC-ODBC Bridge Knowledge Base Articles

• Applications - Microsoft Excel
• Applications - Apache
• Applications - Microsoft Office
• Applications - Oracle
• Applications - Informatica
• Applications - FileMaker Pro
• Applications - UniVerse
• Applications - UniData
• Applications - Actuate
• Interfaces - ODBC
• Languages - Perl
• Languages - PHP
• Languages - C
• Databases - Microsoft SQL Server
• Databases - InterBase
• Databases - DB2
• Databases - Microsoft Access
• Databases - FoxPro
• Databases - Microsoft Navision
• General - Licensing
• General - Connection
• General - OOB Specific
• General - Troubleshooting
• General - Linux
• General - Windows
• General - Solaris
• General - OpenBSD
• General - FreeBSD
• General - OpenVMS
• General - Applications/Interfaces/Drivers
• General - Programming
• Miscellaneous

• Applications - Microsoft Excel
  • Why cannot I see my tables in Excel/Query for MAC OS X?
  • 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 I get undefined reference to xyz when making Apache/PHP
  • Why do I get linker errors building Apache/PHP with OOB
  • How do I pass LD_LIBRARY_PATH down to CGI programs from Apache?
  • How do I use PHP under Apache 2.0.x with OOB on Irix?
  • How do I use Apache/PHP with OOB?
  • Why cannot Apache/PHP find my odbc.ini file? Why do I get error "Datasource not found and no default driver"?
  • Why do not my PHP scripts appear to run on the web server?
  
  
• Applications - Microsoft Office
  • Why cannot I see my tables in Excel/Query for MAC OS X?
  
  
• Applications - Oracle
  • Why do I get error "Initialization function SQLAllocConnect not found" when using Oracle Heterogenous Services (hsODBC) on AIX?
  • Can I use the OOB with Oracle's heterogeneous services (DG4ODBC/hsODBC)?
  • Why do I get error "table or view does not exist" when connecting Oracle hsODBC to SQL Server?
  • How do I connect Oracle to Microsoft Access?
  
  
• Applications - Informatica
  • Why do I get error "libodbc.a(odbc.so) could not be loaded"?
  
  
• Applications - FileMaker Pro
  • How do I access ODBC Databases such as Microsoft SQL Server, Microsoft Access, and Microsoft Excel from FileMaker Pro?
  
  
• 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"?
  
  
• Applications - Actuate
  • How do I access ODBC Databases such as Oracle, Microsoft SQL Server and Microsoft Access from Actuate Reporting Applications?
  
  
• Interfaces - ODBC
  • Why do I get ODBC driver authentication denied when using unixODBC's isql and DataManager?
  • 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 - Perl
  • Why does SQLDataSources list a data source which returns the Data source name not found message when I connect to it?
  • I don't like my odbc.ini in the same directory as my PHP/Perl script, as people browsing my web site may see it and it contains passwords. What do I do?
  • Why do I get undefined symbols when running the Perl DBD::ODBC test?
  • How can I put attributes other than the DSN in my Perl DBI->connect call?
  • Why do I keep getting data truncated errors in my Perl?
  • Why does Perl DBD::ODBC appear to open the DEFAULT data source with OOB?
  • Why do my Perl scripts complete but end in a segmentation violation?
  • Why does test 13 of the simple test in Perl DBD::ODBC fail?
  • Why does make test for Perl DBD::ODBC fail with "invalid object name" errors?
  • When linking Perl DBD::ODBC with the OOB on FreeBSD I get errors regarding wchar.h what should I do?
  • Why do I get "SQLSetConnectOption err=-2" errors in my Perl scripts
  • Why does make test in DBD::ODBC return 09multi errors containing "Data mismatch, result set 1"
  • Why does SQLRowCount/odbc_num_rows and $sth->rows return -1?
  • Why do I get error "Can't change param 1 maxlen (51->50) after first bind" when running make test in DBD::ODBC?
  • Why does make test in DBD::ODBC to SQL Server 2005 and SQL Server Express fail?
  • How do I connect ActiveState ActivePerl on UNIX and Linux to SQL Server?
  • Why do I get "String data, right truncation" retrieving result-sets from MS SQL Server?
  • Why do tests 1, 2 and 6 of 20Sqlserver test in DBD::ODBC fail to MS SQL Server?
  • Why do I get a transaction already started error calling a procedure?
  
  
• Languages - PHP
  • Why do my connections to the OOB server seem to be dropped after a while?
  • I don't like my odbc.ini in the same directory as my PHP/Perl script, as people browsing my web site may see it and it contains passwords. What do I do?
  • Why do I get undefined reference to xyz when making Apache/PHP
  • Can I use PHP with OOB and driver X?
  • Why does a build of PHP4 RC1 and OOB fail?
  • In PHP, why can I only use/get column names up to 30 characters when my database supports much longer column names?
  • Why do I get compile warnings in php_odbc.c with OOB 1.0.0.15
  • Why do I get linker errors building Apache/PHP with OOB
  • What is this problem I'm seeing when using PHP persistent connections?
  • Why does SQLRowCount/odbc_num_rows and $sth->rows return -1?
  • How do I use PHP under Apache 2.0.x with OOB on Irix?
  • How do I use Apache/PHP with OOB?
  • Why cannot Apache/PHP find my odbc.ini file? Why do I get error "Datasource not found and no default driver"?
  • Why do not my PHP scripts appear to run on the web server?
  • Why do I get parse errors when compiling PHP with OOB?
  • Why do I get corrupted text columns back from MS SQL Server?
  • Why is my NT OOB Server using a lot of CPU when my ODBC connections go to MS SQL Server
  
  
• Languages - C
  • I am trying to compile/link my C code and it fails with undefined symbol errors.
  • Where can I get help with developing C applications using ODBC and the Easysoft ODBC-ODBC Bridge?
  • Why does SQLRowCount/odbc_num_rows and $sth->rows return -1?
  
  
• Databases - Microsoft SQL Server
  • Why can I see more tables in MS SQL Server than normal?
  • Why do I get authorization failures from the client?
  • Why are my connections to MS SQL Server so slow?
  • Why does make test for Perl DBD::ODBC fail with "invalid object name" errors?
  • Do you have to install the OOB Server on the same machine as your Database?
  • Why do parameterised inserts appear to hang and my OOB Server is using over 90% of cpu?
  • Why do I get an Access Violation in the MS SQL Server ODBC Driver?
  • Why cannot I see my tables in Excel/Query for MAC OS X?
  • Why do I get error "Can't change param 1 maxlen (51->50) after first bind" when running make test in DBD::ODBC?
  • Why does make test in DBD::ODBC to SQL Server 2005 and SQL Server Express fail?
  • Why do I get corrupted text columns back from MS SQL Server?
  • Why is my NT OOB Server using a lot of CPU when my ODBC connections go to MS SQL Server
  • How do I connect ActiveState ActivePerl on UNIX and Linux to SQL Server?
  • Why can't I insert timestamps with sub-millisecond fractions in to MS SQL Server datetime field?
  • Why are my output bound parameters from a MS SQL Server procedure not retrieved?
  • Why do I get "Incorrect Syntax near the Keyword 'by'" error message when calling SQLDescribeParam in the MS SQL Server ODBC driver?
  • Why do I get "String data, right truncation" retrieving result-sets from MS SQL Server?
  • Why are my numeric and currency values returned too long with an additional random character from MS SQL Server?
  • Why do tests 1, 2 and 6 of 20Sqlserver test in DBD::ODBC fail to MS SQL Server?
  • Why do I get "[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen (CreateFile())"
  
  
• Databases - InterBase
  • Why do I get error "[unixODBC][][Easysoft][InterBase]unavailable database" when connecting through the ODBC-ODBC Bridge from Unix to an InterBase DSN on my windows machine (which also hosts my database)
  
  
• Databases - DB2
  • Why do I get "IM004, Driver's SQLAllocHandle on SQL_HANDLE_HENV failed" connecting to DB2?
  
  
• Databases - Microsoft Access
  • Why can't I use bound parameters with MS Access?
  • Why does my second connection to MS Access hang?
  • Why do I get "Could not find file '(unknown)'" errors using MS Access ODBC driver?
  • How do I connect Oracle to Microsoft Access?
  
  
• Databases - FoxPro
  • How do I access FoxPro databases from Unix, Linux and Mac OS X?
  
  
• Databases - Microsoft Navision
  • How do I access Microsoft Navision data?
  
  
• 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?
  • I've installed my license. Why do I still get "no license slots available"?
  • 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?
  • How do I know if I am exceeding a connection based license?
  • 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?
  • Whilst trying to run isql I get the following error:error HY000:0:0[unixODBC][Easysoft ODBC]General error: Failed to initialise licensing - No valid licenses for this product found, return code 3
  • How do I transfer a license?
  
  
• General - Connection
  • Why does it take so long to connect to the server?
  • How do I specify connection attributes for my DSN that are not configurable in the odbc.ini?
  • Why do I get connection refused errors from the client?
  • Why do I get connection closed by foreign host messages when I try to telnet to the port the server is listening on?
  • Why do my connections to the OOB server seem to be dropped after a while?
  • Why do I get "Data source not found and no default driver" message when I am sure I have defined the DSN in my odbc.ini file?
  • Why do I get authorization failures from the client?
  • Why can't I connect to the data source?
  • Why do I get "Invalid authorization specification" and/or "authentication error number nnnn" when the LogonUser and LogonAuth are set to a valid username and password?
  • Why do I get connection refused/reset under heavy loads (Windows OOB server)?
  • Can I fork child processes after SQLDriverConnect and use the connection handle in each one?
  • Do you have to have DNS working for correct operation of the OOB?
  • Can multiple machines running the OOB client simultaneously use the same OOB Server?
  • How does the OOB client handle refused connections?
  • How does the OOB client support connection timeouts?
  • Why is inetd terminating the OOB Server service?
  • Why do I get the error "Not enough attributes for connection" since upgrading OOB from a pre 1.0.0.27 release?
  • Why do I get the error "ORACLE_HOME environment variable not set"?
  • Why cannot I connect to an OOB Server running on a clustered windows server using virtual IP addressing?
  • How can I avoid setting shell environment variables required by a driver?
  • What can't I connect to my OOB Server since installing Windows XP Service Pack 2?
  • What is oobping?
  • How do I use oobping to diagnose connection problems to the OOB Server?
  • How do I use oobping to diagnose authentication problems?
  • How do I use oobping to test the connection to a remote ODBC DSN?
  • How do I use oobping to test connection times?
  • What does "Communication link failure" mean?
  • Why do I get error "cannot restore segment prot after reloc: Permission denied"?
  • Why do I get error "Failed to receive packet header"?
  • Why do I get "[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen (CreateFile())"
  
  
• General - OOB Specific
  • How does the OOB locate DSNs?
  • How much memory do I need for the OOB Server on NT?
  • Why does it take so long to connect to the server?
  • Why can I see more tables in MS SQL Server than normal?
  • Are any usernames/passwords transmitted as plain text over the network connection?
  • Can I strip(1) the shared objects and executables?
  • Can I run the OOB Server on UNIX without the inetd SuperServer?
  • Can I make the OOB statistics web page refresh more/less frequently?
  • Why does the OOB HTTP Server statistics page show active threads when there are no connections?
  • Why can't I login to the HTTP Administrator when running the OOB server as a named user instead of in the system account?
  • Is there any tracing in OOB I can use for debugging my application?
  • How do I specify connection attributes for my DSN that are not configurable in the odbc.ini?
  • Why does SQLDataSources list a data source which returns the Data source name not found message when I connect to it?
  • How can I encrypt the network connection between the client and server?
  • Does the ODBC-ODBC Bridge install for UNIX support xinetd?
  • Do you have to have DNS working for correct operation of the OOB?
  • Can multiple machines running the OOB client simultaneously use the same OOB Server?
  • How does the OOB client handle refused connections?
  • How does the OOB client support connection timeouts?
  • What does the OOB do if an application terminates abnormally?
  • I have no root access. How do I tell OOB/unixODBC to use odbc.ini and odbcinst.ini files not in /etc?
  • Why do I get the error "Not enough attributes for connection" since upgrading OOB from a pre 1.0.0.27 release?
  • How can I tell what version of OOB I am running?
  • Why does my XML output for column data contain trailing garbage?
  • Do you have to install the OOB Server on the same machine as your Database?
  • Why do I get "[unixODBC][Easysoft ODBC (Server)]Memory allocation error"?
  • What is oobping?
  • How do I use oobping to diagnose connection problems to the OOB Server?
  • How do I use oobping to diagnose authentication problems?
  • How do I use oobping to test the connection to a remote ODBC DSN?
  • How do I use oobping to test connection times?
  • How do I run an OOB Server on UNIX at reduced priority?
  • How do I restart the OOB Server?
  • What does "Communication link failure" mean?
  • What is the OOB demo server and how do I use it?
  • How do I upgrade to a newer version of OOB?
  • I only want to retrieve data from the server, are there any tricks to speed it up in read-only mode?
  • What is esoobserver.exe?
  
  
• General - Troubleshooting
  • Why do I get connection refused errors from the client?
  • Why do I get connection closed by foreign host messages when I try to telnet to the port the server is listening on?
  • Why do my connections to the OOB server seem to be dropped after a while?
  • Why do I get "Data source not found and no default driver" message when I am sure I have defined the DSN in my odbc.ini file?
  • Why do I get authorization failures from the client?
  • How do I find out why an ODBC call is failing?
  • Why can't I connect to the data source?
  • What is oobping?
  • How do I use oobping to diagnose connection problems to the OOB Server?
  • How do I use oobping to diagnose authentication problems?
  • How do I use oobping to test the connection to a remote ODBC DSN?
  • How do I use oobping to test connection times?
  
  
• General - Linux
  • Which version of OOB should I be using?
  • What Linux kernels can I run?
  • Why do I get linker errors building Apache/PHP with OOB
  • Which is best, inetd or standalone startup for the OOB Server?
  • Can I use a multi-threaded application with ODBC-ODBC Bridge on Linux and if so how?
  • Why is inetd terminating the OOB Server service?
  • Why do I get the error "libqt.so.3: symbol _res, version GLIBC_2.0 not defined"?
  
  
• General - Windows
  • How much memory do I need for the OOB Server on NT?
  • What username/password do I need to specify for LogonUser and LogonAuth?
  • What do I do if I get an Access Violation or Fault popup window?
  • Does the OOB client support file DSNs?
  • Why does the install hang?
  • Why do I get "Invalid authorization specification" and/or "authentication error number nnnn" when the LogonUser and LogonAuth are set to a valid username and password?
  • Why do I get connection refused/reset under heavy loads (Windows OOB server)?
  • How can I check which version of MS MDAC I have?
  • What version of MS MDAC do I need?
  • Why does OOB install fail with "Setup is unable to locate the layout file"?
  • Why do I get "Initialization of the dynamic link library xxx failed" dialogues on my server desktop when running in MultiProcess mode?
  • Why cannot I connect to an OOB Server running on a clustered windows server using virtual IP addressing?
  • How do I restart the OOB Server?
  
  
• General - Solaris
  • Why do I get undefined symbol for h_errno?
  
  
• General - OpenBSD
  • Can I use the ODBC-ODBC Bridge for FreeBSD on OpenBSD?
  
  
• General - FreeBSD
  • When linking Perl DBD::ODBC with the OOB on FreeBSD I get errors regarding wchar.h what should I do?
  
  
• General - OpenVMS
  • What VMS float types are SQL_C_REAL, SQL_C_DOUBLE and SQL_C_FLOAT?
  
  
• General - Applications/Interfaces/Drivers
  • Why do I get error "ld: cannot open -lesoobclient: No such file or directory" when attempting to link an application with the OOB
  • Why am I having intermittent problems with a particular ODBC driver?
  • Why doesn't a query return recently inserted data?
  • Why can't I run CGI programs using OOB under Netscape Enterprise Server?
  • Why do I not get a list of all the tables and columns in a database?
  • Why do I get ODBC driver authentication denied when using unixODBC's isql and DataManager?
  • How do I pass LD_LIBRARY_PATH down to CGI programs from Apache?
  • What does "[Easysoft ODBC][unixODBC][Driver Manager]Can't initiate unicode conversion" mean?
  • Can I use Easysoft ODBC-ODBC Bridge to access my remote database?
  
  
• General - Programming
  • Can I fork child processes after SQLDriverConnect and use the connection handle in each one?
  • Can I use a multi-threaded application with the OOB client?
  • I am trying to compile/link my C code and it fails with undefined symbol errors.
  • Where can I get help with developing C applications using ODBC and the Easysoft ODBC-ODBC Bridge?
  
  
• Miscellaneous
  • How do I turn unixODBC tracing on or off?
  • How do I generate a Windows ODBC trace?