function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
openaccessopenaccess 

Preview version of OpenAccess ODBC driver for Salesforce is now available for download

You are welcome to download a preview version of the OpenAccess ODBC Driver for Salesforce.com. It is available at:

http://www.OpenAccessSoftware.com/support/SalesF-Files-Index.asp

The preview version allows READ access (SELECT) from Salesforce. It will expose all the objects you have acess to, including any custom objects/fields you have added. Please try it out and give us your feedback.

Using the OpenAccess ODBC Driver for Salesforce allows any application or development tool that is able to access data from databases like SQL Server and Oracle to access your data at Salesforce.com.

OpenAccess Team
http://www.OpenAccessSoftware.com

DannyBDannyB

Hi there,

does this require the enterprise edition?

thanks,

dan
Ron HessRon Hess
Yes, just looking thru their materials, they provide ODBC access to the Salesforce SOAP API, so you would need Salesforce Enterprise Edition.
djordandjordan

This looks great. I'm trying to integrate sforce to an MS Access front end app. However, when I try to link tables into this ODBC source, Access crashes

 
openaccessopenaccess

Have you been able to use the OpenAccess ODBC driver with any other ODBC compliant application? We have tested it here by trying to link to the Account table without any issues. We have done our testing from Office 2003.  Some people have had issues because they do not register the required .NET component in the .NET cache. This prevents any application from use the OpenAccess ODBC driver. This is explained in steps (3) on this page: http://www.openaccesssoftware.com/support/SalesF-Files-Index.asp.

Currently the OpenAccess ODBC driver does not support updates and because of this we do not expose a unique key for any of the Salesforce objects. This causes MS Access to pop up a dialog box asking you to select a key column. For now you should click CANCEL on this dialog box.

If this does not resolve your issue then please contact us at support@OpenAccessSoftware.com and we will work with you to resolve it.

OpenAccess Support

 
openaccessopenaccess

You are welcome to download a preview version of the OpenAccess ODBC Driver for Salesforce.com. It is available at:

http://www.OpenAccessSoftware.com/support/SalesF-Files-Index.asp

The preview version allows read/write access to Salesforce using the SQL commands SELECT, UPDATE, DELETE, and INSERT. It will expose all the objects you have acess to, including any custom objects/fields you have added. Please try it out and give us your feedback.

Using the OpenAccess ODBC Driver for Salesforce allows any application or development tool that is able to access data from databases like SQL Server and Oracle to access your data at Salesforce.com.

OpenAccess Team
http://www.OpenAccessSoftware.com
Paul WeedenPaul Weeden
Has anyone managed to get this working (assuming the answer is yes) as I can't!!

I've tried 4 different computers now and each time I get the below error when trying to open the driver through a DSN in ASP VB.

"Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed"

Appreciate that this isn't a support forum but getting this working is on the critical path for the project.  Have spoken with OpenAccess Support but they haven't been able to suggest a fix!

Any help would be greatly appreciated!

Thanks



Message Edited by Paul Weeden on 12-13-2007 10:18 AM