Easysoft ODBC-SQL Server Driver Knowledge Base Articles

• Applications - Oracle
• Applications - Informatica
• Applications - UniVerse
• Applications - UniData
• Interfaces - ODBC
• Languages - PHP
• Languages - Perl
• Languages - C
• Databases - Microsoft SQL Server
• General - Licensing
• General - Connection
• Miscellaneous

• 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?
  
  
• 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
  • Why does SQLRowCount/odbc_num_rows and $sth->rows return -1?
  
  
• Languages - Perl
  • 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?
  
  
• Languages - C
  • Why does SQLRowCount/odbc_num_rows and $sth->rows return -1?
  • How do I enable snapshot isolation level in my ODBC application?
  
  
• Databases - Microsoft SQL Server
  • 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 Oracle to Microsoft SQL Server?
  
  
• 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'."?
  • Why do I get error "libssl.so.5: cannot open shared object file"?
  • 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"?
  
  
• Miscellaneous
  • Do I need a Driver Manager?
  • How do I turn unixODBC tracing on or off?
  • How do I connect to SQL Server from Linux?
  • How do I connect Linux with SQL Server 2005?
  • How do I upgrade the Easysoft ODBC-SQL Server Driver from version 1.0 to 1.1?