Download DataDirect OpenAccess for ODBC for Salesforce Data Source

Table of Contents
INSTALLING THE DATADIRECT OPENACCESS FOR ODBC FOR SALESFORCE DATA
SOURCE ............................................................................................................... 1-1
WHAT'S INCLUDED ................................................................................................. 1-1
INSTALLATION OVERVIEW ......................................................................................... 1-2
INSTALLING THE WORKSTATION VERSION....................................................................... 1-2
INSTALLING THE SERVER VERSION ............................................................................... 1-4
REGISTERING THE PRODUCT ...................................................................................... 1-8
Workstation Version ........................................................................................ 1-8
Server Version................................................................................................ 1-9
USING THE SALESFORCE DRIVER ........................................................................ 2-1
OVERVIEW .......................................................................................................... 2-1
ODBC DSN CONFIGURATION .................................................................................... 2-1
Site URL ........................................................................................................ 2-2
Access........................................................................................................... 2-2
MapToLongVarChar ......................................................................................... 2-2
Enable Four Part Naming ................................................................................. 2-2
Trace Options ................................................................................................. 2-2
CREATING A NEW DSN ............................................................................................ 2-3
Creating a new DSN - Workstation .................................................................... 2-3
Creating a new DSN - Server ............................................................................ 2-3
INSERTING RECORDS .............................................................................................. 2-4
JOINING TABLES.................................................................................................... 2-5
WHY ISQL REPORTS ONLY 100 ROWS .......................................................................... 2-5
USING MICROSOFT ACCESS....................................................................................... 2-5
USING LINKED SERVER FROM SQLSERVER ..................................................................... 2-6
Configuring Linked Server to use the Salesforce driver (for SQL Server 2000) ......... 2-6
Configuring Linked Server to use the Salesforce driver (for SQL Server 2005) ......... 2-7
Using four-part query ...................................................................................... 2-9
Using OpenQuery............................................................................................ 2-9
Using OpenRowset .........................................................................................2-10
CONFIGURING THE SALESFORCE DRIVER ........................................................... 3-1
CONFIGURING THE OASQL.INI.................................................................................. 3-1
i