ODBC-ODBC Bridge knowledge base
- Product information
- Applications
- Licensing
- Installation
- Troubleshooting: Connection and authorisation
- Troubleshooting: Installation
- Troubleshooting: Web Administrator
- Troubleshooting: Microsoft SQL Server
- Troubleshooting: ODBC
- Troubleshooting: Oracle Heterogeneous Services
- Troubleshooting: Perl
- Troubleshooting: PHP
- Troubleshooting: Miscellaneous
-
Product information
- Can I use the ODBC-ODBC Bridge to access my remote database?
- Do I have to install the ODBC-ODBC Bridge server on the same machine as my database?
- Can I use the ODBC-ODBC Bridge with Oracle's Heterogeneous Services (DG4ODBC or HSODBC)?
- 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?
- How do I access FoxPro databases from UNIX, Linux, and macOS?
- How do I access ODBC databases such as Microsoft SQL Server, Microsoft Access, and Microsoft Excel from FileMaker Pro?
- How can I access Navision data from my application?
- How do I access ODBC databases such as Oracle, Microsoft SQL Server, and Microsoft Access from Actuate Reporting Applications?
- Where can I get help with developing C applications using ODBC and the ODBC-ODBC Bridge?
- How can I check what version of Microsoft Data Access Components (MDAC) I have?
- What version of Microsoft Data Access Components (MDAC) do I need?
- Do I need an ODBC Driver Manager to use the ODBC-ODBC Bridge?
- How does the ODBC-ODBC Bridge locate ODBC data sources?
- Does the ODBC-ODBC Bridge client support file DSNs?
- What Linux kernels can I use the ODBC-ODBC Bridge with?
- Can I use the ODBC-ODBC Bridge for FreeBSD on OpenBSD?
- How much memory do I need for the ODBC-ODBC Bridge server on Windows NT?
- Are any user names or passwords transmitted as plain text over the network connection?
- How can I encrypt the network connection between the ODBC-ODBC Bridge client and server?
- Can I use a multi-threaded application with the ODBC-ODBC Bridge client?
- Can I use a multi-threaded application with the ODBC-ODBC Bridge on Linux?
- Does the ODBC-ODBC Bridge rely on DNS?
- Can multiple machines running the ODBC-ODBC Bridge client simultaneously use the same ODBC-ODBC Bridge server?
- How does the ODBC-ODBC Bridge client handle refused connections?
- How does the ODBC-ODBC Bridge client support connection timeouts?
- What does the ODBC-ODBC Bridge do if an application terminates abnormally?
- Can I
strip(1)the ODBC-ODBC Bridge's shared objects and executables? - Can I run the ODBC-ODBC Bridge server on UNIX without the
inetdSuper-Server? - Does the ODBC-ODBC Bridge installation support
xinetdon UNIX? - Is
inetdor standalone a better startup method for the ODBC-ODBC Bridge server? - How do I run an ODBC-ODBC Bridge server on Linux and UNIX at reduced priority?
- How do I restart the ODBC-ODBC Bridge server?
- Can I fork child processes after
SQLDriverConnectand use the connection handle in each one? - Can I make the ODBC-ODBC Bridge statistics web page refresh more or less frequently?
- Why does the ODBC-ODBC Bridge HTTP server statistics page show active threads when there are no connections?
- Why can't I log in to the HTTP Administrator when running the ODBC-ODBC Bridge server as a named user?
- What is
esoobserver.exe? - How can I tell what version of ODBC-ODBC Bridge I'm running?
- Which version of ODBC-ODBC Bridge should I use?
- How do I upgrade to a newer version of ODBC-ODBC Bridge?
- What VMS float types are
SQL_C_REAL,SQL_C_DOUBLE, andSQL_C_FLOAT?
-
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? - I've installed my Easysoft ODBC-ODBC Bridge license. Why do I still get "no license slots available?"?
-
Installation
-
Troubleshooting: Connection and authorisation
- Why does it take so long to connect to the ODBC-ODBC Bridge server?
- Why do I get connection refused errors from the ODBC-ODBC Bridge client?
- Why do I get connection closed by foreign host messages when I try to telnet to the port the ODBC ODBC Bridge server is listening on?
- Why do my ODBC-ODBC Bridge connections drop?
- Why can't I connect to the ODBC-ODBC Bridge's target data source?
- Why does my second ODBC-ODBC Bridge connection to Microsoft Access hang?
- Why do I get an "undefined symbol for h_errno" error when using the ODBC-ODBC Bridge?
- Why can't I connect to an ODBC-ODBC Bridge server running on a clustered Windows server by using virtual IP addressing?
- Why do I get the error "Not enough attributes for connection" since upgrading the ODBC-ODBC Bridge?
- Why do I get connection refused or reset when using the Windows ODBC-ODBC Bridge server?
- What is
oobping? - How do I use
oobpingto diagnose connection problems to the ODBC-ODBC Bridge server? - How do I use
oobpingto diagnose ODBC-ODBC Bridge authentication problems? - How do I use
oobpingto test the connection to a remote ODBC data source? - How do I use
oobpingto test connection times? - What user name and password do I need to specify for
LogonUserandLogonAuthon Windows? - Why do I get authorisation failures from the ODBC-ODBC Bridge client?
- Why do I get "Invalid authorization specification" or "authentication error number nnnn" when
LogonUserandLogonAuthspecify a valid user name and password? - Why do I get ODBC driver authentication denied when using unixODBC's isql and DataManager?
-
Troubleshooting: Installation
-
Troubleshooting: Web Administrator
-
Troubleshooting: Microsoft SQL Server
- Why are my ODBC-ODBC Bridge connections to Microsoft SQL Server so slow?
- Why are my output bound parameters from a Microsoft SQL Server procedure not retrieved?
- Why are my SQL Server numeric and currency values returned too long with an additional random character?
- Why can't I insert timestamps with sub-millisecond fractions into a Microsoft SQL Server datetime field?
- Why can't I display my SQL Server tables in Excel > Query for macOS?
- Why do I get "[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen (CreateFile())"
- 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 do I get an access violation in the Microsoft SQL Server ODBC driver when using the ODBC-ODBC Bridge?
- Why do I get corrupted
TEXTcolumns back from Microsoft SQL Server? - Why does Microsoft SQL Server return more tables than normal?
- Why have connection times to Microsoft SQL Server slowed down since upgrading to SQL Server 2000?
- Why is my ODBC-ODBC Bridge server using a lot of CPU when my ODBC connections go to Microsoft SQL Server
-
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: Oracle Heterogeneous Services
- How do I improve performance when inserting data from Oracle into SQL Server?
- How do I work with SQL Server
VARCHAR(MAX),GUID, andTEXTcolumns when using Oracle Heterogeneous Services? - I get "ORA-02055: distributed update operation failed; rollback required" when using the 64-bit version of DG4ODBC. What can I do?
- I get an ORA-02070 error when using DG4ODBC to insert data into SQL Server. What can I do?
- I get error "ORA-28511: lost RPC connection to heterogeneous remote agent using SID" when using the SQL Server ODBC driver. What can I do?
- I get the error "Failed to load ODBC library symbol" when using Oracle Heterogeneous Services. 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?
- Why do I get error "ORA-28500: INVALID_LOGIN: Invalid username, password, security token; or user locked out" when using Oracle Heterogeneous Services?
- Why do I get error "table or view does not exist" when connecting Oracle HSODBC to SQL Server?
- Why does DG4ODBC report the wrong length for my SQL Server character columns?
- I get "error diagnosed by Net8 when connecting to an agent" when using DG4ODBC or HSODBC. What can I do?
- I get the error "Failed to load ODBC library symbol" when using Oracle Heterogeneous Services. What can I do?
- My queries take minutes to complete when using Oracle HSODBC. What can I do?
- Why do I get error "Generic Connectivity Using ODBC][C077] Could not find symbol 'SQLAllocConnect' in dynamic library"?
- Why do I get error "Initialization function SQLAllocConnect not found" when using Oracle Heterogenous Services (HSODBC) on AIX?
-
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? - When linking Perl DBD::ODBC with the ODBC-ODBC Bridge on FreeBSD I get
wchar.herrors. What should I do? - Why do I get undefined symbols when running the Perl DBD::ODBC test with the ODBC-ODBC Bridge?
- Why do tests 1, 2 and 6 of 20Sqlserver test in DBD::ODBC fail when using the ODBC-ODBC Bridge?
- Why does make test in DBD::ODBC return 09multi errors containing "Data mismatch, result set 1" when using the ODBC-ODBC Bridge?
- Why does Perl DBD::ODBC appear to open the DEFAULT data source with the ODBC-ODBC Bridge?
- Why does test 13 of the simple test in Perl DBD::ODBC fail with the ODBC-ODBC Bridge?
- 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? - How do I use Apache and PHP with the ODBC-ODBC Bridge?
- How do I use PHP under Apache 2.0.x with the ODBC-ODBC Bridge on Irix?
- Why do I get "undefined reference" errors when building Apache and PHP with the ODBC-ODBC Bridge?
- Why do I get compile warnings in
php_odbc.cwith ODBC-ODBC Bridge 1.0.0.15 - Why do I get linker errors building Apache and PHP with ODBC-ODBC Bridge
- Why do I get parse errors when compiling PHP with the ODBC-ODBC Bridge?
- Why does the RC1 build of PHP4 fail with the ODBC-ODBC Bridge?
-
Troubleshooting: Miscellaneous
- Is there any ODBC-ODBC Bridge tracing I can use for debugging my application?
- How can I speed up data retrieval when using the ODBC-ODBC Bridge server?
- Why am I having intermittent problems with a particular ODBC driver?
- Why can't I use bound parameters with Microsoft Access?
- Why don't I get a list of all the tables and columns in a database when using the ODBC-ODBC Bridge?
- How do I specify connection attributes for my ODBC data source that are not configurable in
odbc.ini? - I get an access violation error when using the ODBC-ODBC Bridge. What can I do?
- My parameterised inserts hang and my ODBC-ODBC Bridge server is using over 90% of CPU. What can I do?
- Why does
SQLDataSourceslist a data source that returns the "Data source name not found" message when I connect to it? - Why is
inetdterminating the ODBC-ODBC Bridge server service? - Why can't I run CGI programs when using the ODBC-ODBC Bridge under Netscape Enterprise Server?
- What can't I connect to my ODBC-ODBC Bridge server since installing Windows XP Service Pack 2?
- I get error "[unixODBC][][Easysoft][InterBase]unavailable database" when connecting through the ODBC-ODBC Bridge to InterBase. What can I do?
- What does "Communication link failure" mean when using the ODBC-ODBC Bridge?
- Why do I get "[unixODBC][Easysoft ODBC (Server)]Memory allocation error"?
- Why do I get "Could not find file '(unknown)'" errors using the Access ODBC driver with the ODBC-ODBC Bridge?
- Why do I get "Data source not found and no default driver" message when I am sure I have defined the ODBC-ODBC Bridge DSN in my
odbc.inifile? - Why do I get "IM004, Driver's
SQLAllocHandleonSQL_HANDLE_HENVfailed" connecting to DB2? - Why do I get "Initialization of the dynamic link library xxx failed" messages when running the ODBC-ODBC Bridge in MultiProcess mode?
- Why do I get "undefined symbol" errors when I try to build my application against the ODBC-ODBC Bridge?
- Why do I get error "Failed to receive packet header" when using the ODBC-ODBC Bridge?
- Why do I get error "ld: cannot open -lesoobclient: No such file or directory" when attempting to link an application with the ODBC-ODBC Bridge?
- Why do I get the error "libqt.so.3: symbol _res, version GLIBC_2.0 not defined" when using the ODBC-ODBC Bridge?
- Why do I get the error "No ODBC driver is installed" when I try to retrieve data in Microsoft Excel for macOS?
