OLEDB CONNECT Issue

Mon, 26 Jan 2026 21:26:37 GMT

I have a tab within the load script and the whole report fails as this part fails to connect to the Database. It will connect to the PROMOTION_REDEMPTION__C table in the same Database but wont connect to the CAMPAIGN one. The Database is a Salesforce SQL Database:

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=vrSalesforceVR1;Data Source=B2CSQL-01;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=BIC007033;Use Encryption for Data=False;Tag with column collation when possible=False];

BATS:
LOAD distinct promotionRedemptionID,
ID       as Redemption_ID,
    "REDEEMABLE_CAMPAIGN__C",
    'SF Tagged'       as BATS_Flag,
    "VOUCHER_CODE__C"    as barcode_number,
    "VOUCHER_CODE__C"    as Redemption_barcode_number
    ;
SQL SELECT promotionRedemptionID,
ID,
    "REDEEMABLE_CAMPAIGN__C",
    "VOUCHER_CODE__C"
FROM vrSalesforceVR1.dbo."PROMOTION_REDEMPTION__C";

Left Join (BATS)
LOAD ID        as REDEEMABLE_CAMPAIGN__C,
    NAME       as campaign_NAME,
    TYPE;
SQL SELECT Distinct ID,
NAME,
    TYPE
FROM vrSalesforceVR1.dbo.CAMPAIGN;

topic OLEDB CONNECT Issue in QlikView

OLEDB CONNECT Issue