Help get this topic noticed by sharing it on Twitter, Facebook, or email.

DBAmp errors

Hi,

I’m trying to use DBAmp for connection to Salesforce via linked server.
Linked server was created and test connection to the linked server succeeded.
We are trying to connect to Salesforce data from 2 servers but getting errors (please see below) when try to open the tables.
Do you have any ideas why?

Thanks
Evelyn

Sever 1 – Windows 7
Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (Intel X86) Jun 17 2011 00:57:23 Copyright (c) Microsoft Corporation Standard Edition on Windows NT 6.1 (Build 7601: Service Pack 1)

Error:
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Cannot initialize the data source object of OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE". (Microsoft SQL Server, Error: 7303)

--------------------------------------------------------------------------
Server 2 – Windows 2007
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (X64) Apr 22 2011 19:23:43 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.0 (Build 6002: Service Pack 2) (Hypervisor)

Error:
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Cannot initialize the data source object of OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE". (Microsoft SQL Server, Error: 7303)
1 person has
this problem
+1
Reply