Oracle 10g

In this forum we will discuss things relating the ZEOSLib 6.6.x stable versions

Moderators: gto, EgonHugeist

Post Reply
diegogrv
Fresh Boarder
Fresh Boarder
Posts: 3
Joined: 31.03.2010, 00:44

Oracle 10g

Post 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
User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Post 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
Image
Post Reply