Connect Oracle DB from Linux

Forum related to Oracle Server

Moderators: gto, EgonHugeist, mdaems

JohnML1
Fresh Boarder
Fresh Boarder
Posts: 2
Joined: 12.03.2015, 08:34

Connect Oracle DB from Linux

Postby JohnML1 » 08.06.2017, 18:51

do i have to go this way???

Development with Lazarus svn and Zeoslib svn.

Oracle Database runs on Windows Server and i want to connect from a linux Debian Client:

The only functional effort was:

Download and install Oracle Client.

Setup ZConnection.LibraryPath

Startup my Application from within a shell-script:

Code: Select all


export LD_LIBRARY_PATH=/usr/lib/oracle.../libcint.so
./my_application





That was ok, i could execute some SQL-statement

But i'm shure that could be achieved much easier?!!

In Lazarus we have a SqlConnection that connects without any oracle Client installed.

On Windows XP i just have to define ZConnection.Database := server:port/ServiceName

Just curious what i'm missing on my Linux -> Windows Orcale connection.

Tipps are welcome :-)

btw.:
Lazarus SQLConnection doesn't handle German Umlauts as ä ü ö so i can't use it :-(

Thank you for ZeosLib !!!

marsupilami
Gold Boarder
Gold Boarder
Posts: 534
Joined: 17.01.2011, 14:17

Re: Connect Oracle DB from Linux

Postby marsupilami » 09.06.2017, 11:27

Hello JohnML1,

I will have to set up some computer where I can test this. Just for the record: When you say Zeos from SVN you mean Zeos 7.2 from SVN?

With best regards,

Jan

JohnML1
Fresh Boarder
Fresh Boarder
Posts: 2
Joined: 12.03.2015, 08:34

Re: Connect Oracle DB from Linux

Postby JohnML1 » 09.06.2017, 15:38

thank you for your quick answer:

I'm no expert at all but TortoiseSVN tells me:

Merged revision(s) 3951-3974 from branches/testing-7.2:
Fixes a bug in the PostgreSQL driver that keeps it from changing transaction isolation...
fix for https://sourceforge.net/p/zeoslib/tickets/183/
fix for https://sourceforge.net/p/zeoslib/tickets/183/
D7 compiles again and Range checks are disable for RowAccessor
in order to think about nextgen(no raw string) -> switch ZFormatSettings to String
apply patch of https://sourceforge.net/p/zeoslib/tickets/187/ harmless
implemet stivies patch for multiple mysql stmts see: viewtopic.php?f=36&t=3098
close memleak of TZConnectionGroup see: https://sourceforge.net/p/zeoslib/tickets/191/
bind int val if fBindOrdinalBoolValues is set see: https://sourceforge.net/p/zeoslib/tickets/157/
omit 7.3 define from 7.2 inc and add some defines for NextGen
shrink two defines
apply patch of https://sourceforge.net/p/zeoslib/tickets/171/
handle the Refresh issue if Field order has been changed
see https://sourceforge.net/p/zeoslib/tickets/74/
Fix broken DateFormats after changing the TZFormatSettings
drop some GENERIC_INDEX defines
add a small Refresh for latest fix
update Cols after solving the Refresh issue was broken
omit the DataEvent override again -> see viewtopic.php?f=40&p=84699&sid=c71906ddb4a2c115ab4b8cc8194ace0f#p84699

hope you find the needed information


Return to “Oracle”

Who is online

Users browsing this forum: No registered users and 1 guest