Oracle error ORA-12532: TNS:Invalid argument at run-time

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
paul76
Posts: 4
Joined: Wed 28 Mar 2007 05:12

Oracle error ORA-12532: TNS:Invalid argument at run-time

Post by paul76 » Mon 14 May 2007 19:53

ODAC VCL : 6.00.0.4 for Delphi 2007
Delphi 2007
Windows XP SP2

When trying to open the connection in TOraSession at run-time, I get the error 'ORA-12532: TNS:Invalid argument'.

However, at design-time, I can connect without a problem (ie. changing connected to true in the object inspector).

Anyone seen this before ?

Thanks for any help.

paul76
Posts: 4
Joined: Wed 28 Mar 2007 05:12

RE: Solved

Post by paul76 » Mon 14 May 2007 20:15

Seemed to have solved the problem, will describe what I did just incase someone else has the problem.

I am using Oracle 10.1.0.

In the TNSNAMES.ORA, my local database definition was using HOST = where is the network name of my PC.

I changed it to use LOCALHOST and that solved the problem, not sure wh this would happen though, strange that it works fine at design-time, the problem only occurs at run-time.....

Post Reply