Page 1 of 1

ODAC 6.25 and WS2008

Posted: Mon 12 Mar 2012 07:51
by emod
Hi,

I have a problem with a Delphi App 32 bits, it crash.

If I connect to Oracle

Code: Select all

OraSession.Options.Net:= True;
g_CadenaConexion:=user+'/'+pass+'@'+ip+':'+port+':'+sid;
it works, but with

Code: Select all

OraSession.Options.Net:= False;
g_CadenaConexion:=user+'/'+pass+'@'+tnsnames;
crash.

OraSession is a TOraSession component.

In WS2003 and Oracle 10 works fine in both connect systems.
Windows 7 Professional 64 bits and oracle 11g works fine too.

Borland® Delphi® for Microsoft® Windows™ Version 10.0.2288.42451 Update 2 Copyright © 2005 Borland® Software Corporation.
Windows Server 2008 R2 Enterprise SP 1 64 bits
ODAC 6.25
Oracle 11g

Sorry about my poor english, thanks.[/img]

Posted: Mon 12 Mar 2012 14:15
by AlexP
Hello,

Please specify the exact version of the Oracle client you use on WS2008. We have checked the OCI mode connection on Oracle Client 11.2.0.1 and found any problems. However, when using Oracle Client 10, if an application is in the directory incuding brackets, the application cannot connect to Oracle, as it cannot find the tnsnames.ora file. Please try moving your application to the root of any disk and running it - if the problem doesn't recur, you should update your Oracle Client

Posted: Tue 13 Mar 2012 07:44
by emod
Oracle Client 11.2.0.1 and the application's directory not including brackets symbols.

Posted: Tue 13 Mar 2012 13:02
by AlexP
Hello,

Please try to connect to Oracle using standard SQLPlus application and tell us the result.