Page 1 of 1

Oracle 10g

Posted: 31.03.2010, 01:10
by diegogrv
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

Posted: 03.04.2010, 20:08
by mdaems
SQL Error: ORA-12154: TNS:could not resolve the connect identifier specified.
This means the connect string is probably no passed on or interpreted correctly. This may be a zeoslib problem or a configuration issue.
Did you already debug TZOracleConnection.Open to see what exactly is passed on to the server?

ubuntu 9.10 64bits
You're in dangerous water. Zeoslib hasn't been tested at all on 64-bit processors yet, as far as I know.
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