Easysoft ODBC-SQL Server Driver Knowledge Base Articles

• Applications - Apache
• Applications - Oracle
• Applications - Informatica
• Applications - UniVerse
• Applications - UniData
• Interfaces - ODBC
• Languages - PHP
• Languages - Perl
• Languages - C
• Languages - Python
• Databases - Microsoft SQL Server
• General - Licensing
• General - Connection
• General - Troubleshooting
• General - Solaris
• General - SSL
• General - Installation
• Miscellaneous

• Applications - Apache
  • Why do not my PHP scripts appear to run on the web server?
  
  
• Applications - Oracle
  • Why do I get error "Initialization function SQLAllocConnect not found" when using Oracle Heterogenous Services (hsODBC) on AIX?
  • 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 SQL Server?
  • 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?
  
  
• Applications - Informatica
  • Why do I get error "libodbc.a(odbc.so) could not be loaded"?
  
  
• 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"?
  
  
• Interfaces - ODBC
  • 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 - PHP
  • 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 does SQLRowCount/odbc_num_rows and $sth->rows return -1?
  • Why do not my PHP scripts appear to run on the web server?
  
  
• Languages - Perl
  • 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?
  • 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 make test for Perl DBD::ODBC fail with "invalid object name" errors?
  • 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 does make test for Perl DBD::ODBC fail with "make: *** [test_dynamic] Error 2"?
  • Why do I get a transaction already started error calling a procedure?
  
  
• Languages - C
  • Why does SQLRowCount/odbc_num_rows and $sth->rows return -1?
  • How do I enable snapshot isolation level in my ODBC application?
  
  
• Languages - Python
  • How do I connect Python/SQLAlchemy on UNIX and Linux to SQL Server?
  
  
• Databases - Microsoft 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?
  
  
• 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?
  • 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?
  • 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?
  • How do I transfer a license?
  
  
• General - Connection
  • Why do I get error "Client unable to establish connection: OS Error: 'Failed to find host address 'myhost\myinstance'"?
  • Why do I get error "Client unable to establish connection: OS Error: 'Connection refused'"?
  • 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'"?
  • Why do I get error "Login failed for user ''. The user is not associated with a trusted SQL Server connection"?
  • Why do I get error "Login failed for user 'myuser'."?
  • How do I connect to SQL Server from Linux?
  • How do I connect Linux with SQL Server 2005 and 2008?
  • Why do I get error "Can't open shared library" or "cannot open shared object file" when running tdshelper?
  • Why do I get error "cannot restore segment prot after reloc: Permission denied"?
  • Can I use my Windows user account to access SQL Server from Linux and UNIX?
  
  
• General - Troubleshooting
  • Does the Easysoft ODBC-SQL Server Driver distribution include any diagnostic tools?
  
  
• General - Solaris
  • Why do I get error "libodbc.so.1: open failed: No such file or directory"?
  
  
• General - SSL
  • Why do I get error "libssl.so.5: cannot open shared object file"?
  • Why do I get error "Client unable to establish connection: SSL requested but not supported"?
  • Why do I need Secure Sockets Layer (SSL)?
  • Why do I get error "errno=2, there may be no source of entropy on this system"?
  
  
• General - Installation
  • How do I install an Easysoft ODBC driver on a machine where I have no root access?
  
  
• Miscellaneous
  • How do I turn unixODBC tracing on or off?
  • How do I upgrade the Easysoft ODBC-SQL Server Driver from version 1.0 to 1.2?