Feedback
Did this article resolve your question/issue?

   

Article

Unable to connect to Salesforce from Oracle Database Gateway for ODBC

Information

 
TitleUnable to connect to Salesforce from Oracle Database Gateway for ODBC
URL Name9273
Article Number000123094
EnvironmentProduct: Connect(64) XE for ODBC Salesforce driver
Version: 7.1
OS: All supported platforms
Database: Salesforce.com
Application: Oracle Gateway for ODBC
Question/Problem Description
Connection fails from Database Gateway for ODBC (dg4odbc) using sqlplus to Salesforce.
A successful connection can be established using the example program or the ODBC Administrator.
Steps to Reproduce
Clarifying Information
Steps to Reproduce:

Create database link, and retrieve list of tables in SQLPlus using steps below:

$ sqlplus test01/test01
SQL*Plus: Release 11.2.0.0.1 on Wed Apr 27 16:32:01 2011
Copyright (c) 1982, 2008, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.0.1
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create database link dg4odbc connect to "xxxxxx@xyz.com" identified by "xxxxxx" using 'dg4odbc';

SQL> desc all_tables@dg4odbc;
ERROR:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[DataDirect][ODBC Salesforce driver][Salesforce]INVALID_LOGIN: Invalid
username, password, security token; or user locked out.[10300]
ORA-02063: preceding 2 lines from DG4ODBC

Error MessageERROR:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[DataDirect][ODBC Salesforce driver][Salesforce]INVALID_LOGIN: Invalid
username, password, security token; or user locked out.[10300]
ORA-02063: preceding 2 lines from DG4ODBC
Defect Number
Enhancement Number
Cause
dg4odbc is truncating the domain from the user since Salesforce users are e-mail addresses and contain an '@' sign. 
For example, foo@xyz.com is being sent as foo; and Salesforce is unable to authenticate the user properly.
Resolution
Set the Domain connection option in the ODBC data source:

Windows:
ODBC data source Security tab:
Logon Domain: xyz.com

Unix/Linux:
ODBC data source:
Domain=xyz.com

Then, use only the user portion of the Salesforce ID to create the database link:
create database link DG4ODBC_LINK connect to "foo" identified by "password" using 'DG4ODBC';
 
Workaround
Notes
References to other documentation:
Connect for ODBC User's Guide: The Connect XE Drivers : The Salesforce Driver : Connection Option Descriptions : Logon Domain
https://media.datadirect.com/download/docs/odbc/allodbc/help.html#page/odbc%2Flogon-domain.html

Connect for ODBC User's Guide: The Connect XE Drivers : The Salesforce Driver : Configuring and Connecting to Data Sources
https://media.datadirect.com/download/docs/odbc/allodbc/help.html#page/odbc%2FConfiguring_and_Connecting_to_Data_Sources_17.html
Last Modified Date12/9/2019 9:05 PM
Files
Disclaimer The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.