Skip to content
+1-888-319-3663

COMMUNITY FORUM

Connecting to Oracle databases through the ODBC data source

Alberto Pinal asked 6 years ago
Hi,
 
I want to create a connection to an Oracle DB through the ODBC data source within SmartConnect, but I don’t know how to make it! 
Is there any manual, tutorial, or reference document that shows how to perform this requirement?
 
Thanks a lot.
Alberto.
Answers
Patrick Roth Staff answered 6 years ago
Alberto,
How to set up an ODBC datasource is discuss in the SC documentation.  There isn’t anything specific for Oracle since the setup is per odbc driver. But the generic setup is noted in the sc documentation:
http://www.eonesolutions.com/Manuals/SmartConnect/SmartConnect%202014/?page=smartconnect_odbc_data_source
When I look at mine, I have “Oracle – New” and “Oracle – Old”. 
The connection strings in the lookup are found:
SmartConnect..ConnectionStringTemplate
So if you needed a custom odbc connectionstring, you could insert a record into this table using the format as the other records look like and SC should then generate the connection as you specify.
patrick
Alberto replied 6 years ago

Patrick I have added 2 connection strings into this table, both records that were inserted are:

Driver={Oracle in OraClient11g_home1};Dbq=myTNSServiceName;Uid=myUsername;Pwd=myPassword;

and

Driver={Oracle in OraClient11g_home1};Dbq=myTNSServiceName;Uid=myUsername;Pwd=myPassword;

So, I am receiving the error: This driver has not been installed. But if I create the ODBC from the Administrative Tools>>ODBC Data Sources (64 bits), it is succesfully created.

Any idea about why the SmartConnect is not detecting the driver that I have installed?

Thanks,
Alberto.

Alberto Pinal answered 6 years ago
What is the diference between using Oracle New and Oracle Old?
 
Thanks.
Alberto answered 6 years ago
 Patrick I have added 2 connection strings into this table, both records that were inserted are:


Driver={Oracle in OraClient11g_home1};Dbq=myTNSServiceName;Uid=myUsername;Pwd=myPassword;

and

Driver={Oracle in OraClient11g_home1};Dbq=myTNSServiceName;Uid=myUsername;Pwd=myPassword;


So, I am receiving the error: This driver has not been installed. But if I create the ODBC from the Administrative Tools>>ODBC Data Sources (64 bits), it is succesfully created.

Any idea about why the SmartConnect is not detecting the driver that I have installed?


Thanks,
Alberto.

If you would like to submit an answer or comment, please sign in to the eOne portal.