Salesforce ODBC driver knowledge base
- Applications: Miscellaneous
- Applications
- Licensing
- Installation
- Troubleshooting: Connection
- Troubleshooting: ODBC
- Troubleshooting: Oracle Heterogeneous Services
- Troubleshooting: Perl
- Troubleshooting: PHP
- Troubleshooting: Miscellaneous
-
Applications
- How do I connect Microsoft SQL Server to Salesforce?
- How do I list my Salesforce users in SQL Server?
- How do I query Salesforce Knowledge Base Articles from SQL Server?
- How do I connect Crystal Reports to Salesforce?
- How do I connect DB2 to Salesforce?
- How do I connect Jaspersoft to Salesforce?
- How do I connect Microsoft Excel to Salesforce?
- How do I connect MicroStrategy to Salesforce?
- How do I connect Oracle Business Intelligence Enterprise Edition (OBIEE) to Salesforce?
- How do I connect Oracle to Salesforce?
- How do I connect PHP to Salesforce on Linux or UNIX?
- How do I connect QlikView to Salesforce?
- How do I connect SAP BusinessObjects to Salesforce?
- How do I connect Tableau to Salesforce?
- How do I connect TIBCO Spotfire to Salesforce?
- 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
- How do I use the Salesforce ODBC driver to connect to my Salesforce sandbox?
- I'm getting "connect failed: OS Error: 'No error'". How do I configure my firewall for use with the Salesforce ODBC driver?
- Why do I get error "API_DISABLED_FOR_ORG:API is not enabled for this Organization or Partner"?
- Why do I get error "ORA-28500: INVALID_LOGIN: Invalid username, password, security token; or user locked out" when using Oracle Heterogeneous Services?
-
Troubleshooting: ODBC
- How do I find out why an ODBC call is failing?
- Why does
SQLRowCount
,odbc_num_rows
and$sth->rows
return-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.ini
orodbc.ini
file 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
- 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_USER
andDBI_PASS
environment 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->connect
call? - 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_PATH
down to CGI programs from Apache? - I don't like
odbc.ini
in the same directory as my PHP or Perl script, as the file contains passwords. What do I do?
- 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.ini
file? 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_persistent
setting 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_PATH
down to CGI programs from Apache? - I don't like
odbc.ini
in the same directory as my PHP or Perl script, as the file contains passwords. What do I do?
-
Troubleshooting: Miscellaneous
- How do I access a Salesforce Related Record by using the Salesforce ODBC driver?
- Fields are missing from my data when using the Salesforce ODBC driver. What can I do?
- I get "Multiple-step OLE DB operation generated errors" when inserting into a master-detail Salesforce field from SQL Server. What can I do?
- Why do I get error "REQUEST_LIMIT_EXCEEDED"?
- Why do I get error "The program can't start because essupp.dll is missing from your computer" when adding a Salesforce ODBC driver data source on Windows Azure?
- Why do I get error "The OLE DB provider "MSDASQL" for linked server supplied inconsistent metadata for a column" when accessing Salesforce data from SQL Server?