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

Error: Unable to retrieve session properties. Cannot initialize the data source object of OLE DB provider "DBAmp.DBAmp" for linked server

I have been getting the following error when i try to upload data to Salesforce using DBAmp. Any help to fix this issue is appreciated.
----------------------------------------------------------------------------------
17:06:10: Run the DBAmpNet2.exe program.
C:\"Program Files"\DBAmp\DBAmpNet2.exe BulkOpsBulk "upsert:bulkapi," "LLC_BI__Loan__c_Subloan_Sublimit_Load" "DEVSALESFORCEDB" "SFDC" "SALESFORCEUAT" "Source_System_ID__c" ""
17:06:11: DBAmpNet2 3.7.3.0 (c) Copyright 2015-2017 forceAmp.com LLC
17:06:11: Parameters: upsert LLC_BI__Loan__c_Subloan_Sublimit_Load DEVSALESFORCEDB SFDC SALESFORCEUAT
17:06:11: Using the Salesforce bulkapi2 API.
17:06:11: Retrying
17:06:11: Retrying
17:06:11: Retrying
17:06:11: Error: Unable to retrieve session properties.
17:06:11: System.Data.SqlClient.SqlException (0x80131904): Cannot initialize the data source object of OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCEUAT".
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParamet
erEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolea
n inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at DBAmpNet2.SysSFSession.Retrieve(SqlConnection currentConnection)
ClientConnectionId:023e2da5-3426-4a40-9de7-d6810c653b21
Error Number:7303,State:1,Class:16
17:06:11: No files exist in the following directory: E:\DBAmp Work Directory\
17:06:11: DBAmpNet2 Operation FAILED.
17:06:38: Allowed Failure Percent = 100.
17:06:39: Percent Failed = 0.000.
--- Ending SF_TableLoader. Operation successful.
1 person has
this problem
+1
Reply