Connect to Oracle database without tnsnames.ora

[ivan.klainic@igea.hr]

Hello!

I saw some samples to set up SqlDatabase variable with connection string.

Code: Select all

! For SqlBase
Set SqlDatabase = "ConnectionString:comdll=sqlws32;alias=SqlBase;servername=server1;host=localhost;port=2155;dbname=island"
! For Oracle
Set SqlDatabase = "ConnectionString:comdll=sqlora32;alias=Ora10G;dbname=ora10g"

I tried to connect to Oracle and it works if I have "dbname" entry in tnsnames.ora.
But there is still dependency on tnsnames.ora.
Is it possible to create connection string for Oracle database wich would be in "SqlBase" manner?
So that we could define host, port and database service name/sid for Oracle (avoiding the use tnsnames.ora)?
Something like...

Code: Select all

Set SqlDatabase = "ConnectionString:comdll=sqlora32;alias=TestOracle;host=db_server_address;port=1521;dbname=db_service_name"

Is it possible?
Thanks

[Charlie]

Hello,

TNSNAMES.ORA is something the Oracle client software needs, not something Team Developer (or SQLTalk, etc.) accesses in any way.

To get away from using TNSNAMES.ORA, I think you'd need to be looking in Oracle forums/documentation/etc.

Best regards.