SQL Server ODBC driver knowledge base
- Product information
- Applications
- Licensing
- Installation
- Troubleshooting: Connection and authorisation
- Troubleshooting: ODBC
- Troubleshooting: Oracle Heterogeneous Services
- Troubleshooting: Perl
- Troubleshooting: PHP
- Troubleshooting: SSL
- Troubleshooting: Miscellaneous
-
Product information
- Can I do SQL Server BULK INSERTs from Linux or UNIX?
- Can I install SQL Server on Linux and UNIX platforms?
- Can I use my Windows user account to access SQL Server from Linux and UNIX?
- How do I connect Linux with SQL Server 7–2022?
- How do I connect to SQL Server from Linux?
- How do I upgrade the SQL Server ODBC driver?
- How do I use SQL Server query notifications from Linux and UNIX?
- How do I enable snapshot isolation level in my ODBC application?
-
Applications
- How do I access Microsoft SQL Server from SAS on Linux?
- How do I connect ActiveState ActivePerl on UNIX and Linux to SQL Server?
- How do I connect Drupal on UNIX and Linux to SQL Server?
- How do I connect MediaWiki on UNIX and Linux to SQL Server?
- How do I connect Node.js on UNIX and Linux to SQL Server?
- How do I connect Oracle to Microsoft SQL Server?
- How do I connect Python SQLAlchemy on UNIX and Linux to SQL Server?
- 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
- Why do I get error "Client unable to establish connection: OS Error: 'Failed to find host address 'myhost\myinstance'" when using the SQL Server ODBC driver?
- Why do I get error "Client unable to establish connection: OS Error: 'Connection refused'" when using the SQL Server ODBC driver?
- Why do I get error "Client unable to establish connection: Server not configured for TCP connection"?
- Why do I get error "Client unable to establish connection: 'Failed to get datagram from socket'" when using the SQL Server ODBC driver?
- Why do I get error "Login failed for user ''. The user is not associated with a trusted SQL Server connection" when using the SQL Server ODBC driver?
- Why do I get error "Login failed for user 'myuser'." when using the SQL Server 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: 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? - How do I insert Unicode supplementary characters into SQL Server from Perl?
- Why does make test for Perl DBD::ODBC fail with "make: *** [test_dynamic] Error 2" when using the SQL Server ODBC driver?
- 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 retrieve output parameter values from SQL Server stored procedures by using PHP ODBC?
-
Troubleshooting: SSL
- Why do I get error "Client unable to establish connection: SSL requested but not supported" when using the SQL Server ODBC driver?
- Why do I get error "errno=2, there may be no source of entropy on this system" when using the SQL Server ODBC driver?
- Why do I get error "libssl.so.5: cannot open shared object file" when using the SQL Server ODBC driver?
- Why do I need Secure Sockets Layer (SSL) when connecting to SQL Server?
-
Troubleshooting: Miscellaneous
- Does the Easysoft SQL Server ODBC driver distribution include any diagnostic tools?
- How do I create a threaded ODBC application that runs a SQL Server workload in parallel?
- I need to set some ODBC statement attributes but my application does not let me do this. What can I do?
- Why do I get error "Can't open shared library" or "cannot open shared object file" when running tdshelper?
