ODBC Driver for salesforce.com – OpenAccess Software, Inc.

Solution: You will have to manually request the site key after you purchase the license online. Run the License Key Administrator from the OpenAccess program group on your system and click on ‘request site key’, fill in all the information requested and submit the form.

Q2: Why is my request for Trial Period Extension rejected?

Solution: You can download and use the OpenAccess ODBC driver for Salesforce for 30 days during the evaluation period and we allow two subsequent request to extend the evaluation period for 15 days each. After this we expect the user to purchase the annual license.

Q3: I have uninstalled and installed the driver again and now I am getting the license error.

Solution: We don’t allow the users to uninstall and install the driver again, if you are having trouble using the driver please contact the support. If you have already reinstalled the driver, you will have to request a new site key

Q4: What kind of data encryption is used when transferring data from salesforce.com?

Solution: The web service access is made through HTTPS. This means we get the same level of SSL encryption you get when accessing SF.com from a browser.

Q5: Why does the License Key Administrator display "Trial License" after I enter my final site key?

Solution: After the final site key is entered, the License Status will change to "Trial License - 365 days left". Licenses are valid for one year from the date of purchase.

Q6: How does the OpenAccess ODBC Driver for SalesForce determine what data a given user can access?

Solution: The roles that dictate what data is available to a given user are handled by your SalesForce account.

Q7: What is required to activate my OpenAccess ODBC Driver for SalesForce on a machine without administrative privileges?

Solution: A non-admin user can request and enter a site key if write permissions are granted to the installation folder.

Q8: Does the OpenAccess ODBC Driver for SalesForce support Microsoft Office 2007, or other applications built on the .NET 2.0 Framework?

Solution: The client/server version of the DataDirect OpenAccess ODBC Driver for Salesforce works with .NET 2.0 compliant applications like Microsoft Access 2007 and SQL Server 2005. The local version cannot be used in this environment.

Q9: What SalesForce subscription version and level do I need to use your ODBC driver?

Solution: We currently support version 7 and above of the salesforce API, and require an enterprise level subscription. If you have a professional level subscription, you must contact SalesForce to get access to their API.

Q10: Why do I see "Site File Moved", or "GetAuthorization2 Error: PROGRAM MOVE" errors when I open the License Key Administrator.

Solution: The error is caused by a change to your system that affects the licensing mechanism for the driver. You will need to request a new site key if you encounter this error.

Q11: I get the following error when trying to connect to Salesforce using OpenAccess Driver "[OpenAccess Software][Salesforce]RDA error: Resource not available - The underlying connection was closed: Unable to connect to the remote server (#0)".

Solution: The error "The underlying connection was closed: Unable to connect to the remote server (#0)" is likely the result of running behind a firewall that is not allowing a direct connection.

If you are using the Proxy Server to connect to the Salesforce.com database using OpenAccess ODBC Driver for Salesforce, you need to add the following information in the openrda.ini file under C:\oaOdbcForSalesforce\bin\iwinnt.

UseProxy=0 --> change this to 1
ProxyHost=localhost --> Your Proxy Host name
ProxyPort=8080 --> The port you are running your proxy server on ProxyUsername= --> Username to connect to the proxy server
ProxyPassword= --> password to connect to the Proxy Server
ProxyDomain= --> Proxy Server Domain Name

Q12. How do I access the Salesforce sandbox account using OpenAccess ODBC Driver for Salesforce?

Solution: You need to specify the complete URL for your sandbox account under the SalesForce section of OpenRDA configuration file (openrda.ini),

For example:

[SalesForce]
SiteUrl=http://tapp0.salesforce.com/services/Soap/u/7.0

Click here for a free evaluation copy.