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
- Languages - Python
- Languages - Go
- 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
- General - Installation
- Miscellaneous
- Applications - Microsoft Excel
-
Applications - Apache
- Why do I get undefined reference to xyz when making Apache/PHP
- How do I tell Apache to pass PHP scripts to the PHP interpreter?
- 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
-
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?
- 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?
- Why do I get error "ORA-00942: table or view does not exist" when using DG4ODBC to connect to SQL Server?
- How do I improve performance when inserting data from Oracle into SQL Server?
- Applications - Informatica
- Applications - FileMaker Pro
- Applications - UniVerse
- Applications - UniData
- Applications - Actuate
- Interfaces - ODBC
-
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?
- Do I have to set DBI_DSN, DBI_USER and DBI_PASS environment variables before running my Perl script?
- 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 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 Microsoft SQL Server?
- Why do tests 1, 2 and 6 of 20Sqlserver test in DBD::ODBC fail?
- 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
- How do I tell Apache to pass PHP scripts to the PHP interpreter?
- How can I find out why my PHP script is not working?
- 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
- Why don't my changes to PHP odbc settings in php.ini file get picked up?
- Why doesn't PHP's max_persistent setting limit the total number of ODBC connections to my database?
- 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 the ODBC-ODBC Bridge?
- Why do I get corrupted text columns back from Microsoft SQL Server?
- Why is my OOB Server using a lot of CPU when my ODBC connections go to Microsoft SQL Server
- How do I retrieve output parameter values from SQL Server stored procedures by using PHP ODBC?
- How do I use a PHP ODBC extension that's more recent than my version of PHP?
- Languages - C
- Languages - Python
- Languages - Go
-
Databases - Microsoft SQL Server
- Why can I see more tables in Microsoft SQL Server than normal?
- Why do I get authorization failures from the client?
- Why are my connections to Microsoft SQL Server so slow?
- 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 Microsoft SQL Server ODBC Driver?
- Why cannot I see my tables in Excel/Query for Mac OS X?
- Why do I get corrupted text columns back from Microsoft SQL Server?
- Why is my OOB Server using a lot of CPU when my ODBC connections go to Microsoft SQL Server
- Why can't I insert timestamps with sub-millisecond fractions into a Microsoft SQL Server datetime field?
- Why are my output bound parameters from a Microsoft SQL Server procedure not retrieved?
- Why do I get "Incorrect Syntax near the Keyword 'by'" error message when calling SQLDescribeParam in the Microsoft SQL Server ODBC driver?
- Why do I get "String data, right truncation" retrieving result-sets from Microsoft SQL Server?
- Why are my numeric and currency values returned too long with an additional random character from Microsoft SQL Server?
- Why do tests 1, 2 and 6 of 20Sqlserver test in DBD::ODBC fail?
- Why do I get "[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen (CreateFile())"
- Databases - InterBase
- Databases - DB2
-
Databases - Microsoft Access
- Why can't I use bound parameters with Microsoft Access?
- Why does my second connection to Microsoft Access hang?
- Why do I get "Could not find file '(unknown)'" errors using Microsoft Access ODBC driver?
- How do I connect Oracle to Microsoft Access?
- How do I open an MDB file without using Microsoft Access?
- Databases - FoxPro
- Databases - Microsoft Navision
-
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?
- 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" when running isql?
- 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?
- How do I automate a license request on Unix or Linux?
-
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())"
- Can I can connect a 64-bit application to a 32-bit ODBC driver?
- Can I can connect a 32-bit application to a 64-bit ODBC driver?
- Why do I get error "The specified DSN contains an architecture mismatch between the Driver and Application"?
- Why do I get error "Data source name not found and no default driver specified"?
-
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 Microsoft 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 Microsoft MDAC I have?
- What version of Microsoft 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
- General - OpenBSD
- General - FreeBSD
- General - OpenVMS
-
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 the 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?
- General - Installation
-
Miscellaneous
- Do I need a Driver Manager?
- isql fails to run with error while loading shared libraries: libncurses.so.4: cannot open shared object file: No such file or directory.
- How do I turn unixODBC tracing on or off?
- 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?
- I need to set some ODBC statement attributes but my application does not let me do this. What can I do?
- How can I create an ODBC data source on Windows without using ODBC Administrator?
