SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Oracle Connectivity

 
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite View previous topic
View next topic
Oracle Connectivity
Author Message
John Natale



Joined: 13 Sep 2000
Posts: 107

Post Oracle Connectivity Reply with quote

I am currently using some JAL scripts that connect to
Oracle databases. I was trying to use LDAP for database
resolution instead of the TNSNAMES file but it appears to
me that since the connection is "Oracle 8.0.4 - 8i and later"
it can not work because LDAP resolution is 8i and above the
connection has to be compatible with version 8.0.4.

The easy workaround is of course to just use the TNSNAMES.ORA

There are currently Oracle 7.3, Oracle 8.0.0-8.0.4, and the
Oracle 8.0.4 - 8i and later options to select from for the
databsae connection. Is there a plan to update that to
something newer like having an Oracle 8.0.4 - 8i and
and Oracle 9i and later or something along those lines?

Thanks,

John


Mon Feb 13, 2006 2:48 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7955

Post Re: Oracle Connectivity Reply with quote

Newest versions will support native drivers for Oracle 9 and 10 as well as ADODB and JDBC connections.

Please note that with the current version you can still connect to Oracle 9/10 if you have Oracle required support files installed with the client. You can also always use an ODBC connection to connect to any version of the Oracle database. All these connections require either preconfigured connection string saved in TNSNAMES.ORA or a fully specified connection string in the db connection properties. This is and was always possible with Oracle, you just need to enter the entire connect string as a single line into the Server property.

: I am currently using some JAL scripts that connect to
: Oracle databases. I was trying to use LDAP for database
: resolution instead of the TNSNAMES file but it appears to
: me that since the connection is "Oracle 8.0.4 - 8i and later"
: it can not work because LDAP resolution is 8i and above the
: connection has to be compatible with version 8.0.4.

: The easy workaround is of course to just use the TNSNAMES.ORA

: There are currently Oracle 7.3, Oracle 8.0.0-8.0.4, and the
: Oracle 8.0.4 - 8i and later options to select from for the
: databsae connection. Is there a plan to update that to
: something newer like having an Oracle 8.0.4 - 8i and
: and Oracle 9i and later or something along those lines?

: Thanks,

: John

Mon Feb 13, 2006 3:53 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.