ODAC 6.25 and WS2008

emod · Post by **emod** » Mon 12 Mar 2012 07:51

Hi,

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

If I connect to Oracle

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]

AlexP · Post by **AlexP** » Mon 12 Mar 2012 14:15

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

emod · Post by **emod** » Tue 13 Mar 2012 07:44

Oracle Client 11.2.0.1 and the application's directory not including brackets symbols.

AlexP · Post by **AlexP** » Tue 13 Mar 2012 13:02

Hello,

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