My Oracle Support Banner

Archidev - External Business Components - No ODBC Datasource configuration steps when access to Oracle (Doc ID 525666.1)

Last updated on DECEMBER 26, 2019

Applies to:

Siebel Tools - Version 7.7.2.2 SIA [18356] and later
IBM AIX on POWER Systems (64-bit)
Database: Oracle 9.2.0.6
Application Server OS: IBM AIX 5L 5.2
Database Server OS: IBM AIX 5L 5.2



Symptoms

When go to a view based on External Business Component (EBC) for showing data from another DB, the SBL-DAT-00222 error occurs.

Configuration steps to reproduce the error:
1- Imported view definition and created the "table" in tools with data source object defined
2- Created simple EBC with 2 fields, Mapped column to system field ID, specified the Data Source
3- Specified the Server Config parameters as instructed, including the 'undocumented' DLL parameter
4- Created an applet and associated to a view

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
 While SQL Server and DB2 require ODBC datasource names (DSNs) to access the external database, for Oracle, the Siebel DLLs use native Oracle Connect Strings which reference an entry in the machine's tnsnames.ora file.
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.