I'm in need of help,
I'm using ubuntu 9.10 64bits and when I run the command Zconnect1.connect in the application return the error:
Project raised exception class 'Unknown'
but, when i'm in IDE lazarus and click on component ZConnection1 and on Object Inspector change the property Connected to true, return the error:
SQL Error: ORA-12154: TNS:could not resolve the connect identifier specified.
When run sqlplus in the terminal OK
$sqlplus diego@banco
SQL*Plus Release 10.2.0.4.0 - Production on Tue Mar 30 21:01:38 2010
Copyright (c) 1982, 2007, Oracle. All Right Reserved.
Enter password:*****
Connect to:
Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
SQL>
Anybody know the solution to the problem?
Thanks
Oracle 10g
Moderators: gto, EgonHugeist
- mdaems
- Zeos Project Manager
- Posts: 2766
- Joined: 20.09.2005, 15:28
- Location: Brussels, Belgium
- Contact:
This means the connect string is probably no passed on or interpreted correctly. This may be a zeoslib problem or a configuration issue.SQL Error: ORA-12154: TNS:could not resolve the connect identifier specified.
Did you already debug TZOracleConnection.Open to see what exactly is passed on to the server?
You're in dangerous water. Zeoslib hasn't been tested at all on 64-bit processors yet, as far as I know.ubuntu 9.10 64bits
Even worse, I think. Nobody did even check the buffer definitions used by zeoslib for communication with the OCI. I suppose pointers and integers are most at risk.
BTW. support for 64-bit is one of the alpha features of zeoslib which have only been tested for mysql.
Mark