Board index » delphi » Delphi with Oracle

Delphi with Oracle

SXMgdGhlcmUgYSB3YXkgdG8gY29ubmVjdCBhIERlbHBoaSAyIGFwcCB0byBhbiBPcmFjbGUgc2Vy
dmVyIHdpdGhvdXQgdXNpbmcgT0RCQyA/DQoNCkkgdGhpbmsgdGhpcyBtYXkgYmUgYSAic3R1cGlk
IiBxdWVzdGlvbiBhbmQgeW91IG11c3QgYmUgcmVzcG9uZGluZyB0aGlzIGtpbmQgb2YgcXVlc3Rp
b25zIHZlcnkgb2Z0ZW4gYnV0IEknbSBhIG5ld2JpZSBpbiB0aGlzIGtpbmQgb2YgYXBwcyBhbmQg
SSBtdXN0IGRldmVsb3Agb25lIGFwcGxpY2F0aW9uIHRoYXQgd2lsbCBjb25uZWN0IHRvIGFuIE9y
YWNsZSBTZXJ2ZXIuDQoNClRoYW5rcyBpbiBhZHZhbmNlDQoNCkZpbGlwZSBQZWl4aW5obw0KcGVp
eGluaG9AY2V0LnB0DQpBdmVpcm8tUE9SVFVHQUw=

 

Re:Delphi with Oracle


Filipe Peixinho <peixi...@cet.pt> wrote in article
<01bbfbde$938b1de0$a2588...@moliceiro.cet.pt>...

Quote
> Is there a way to connect a Delphi 2 app to an Oracle server without
using ODBC ?

> I think this may be a "stupid" question and you must be responding this

kind of questions very often but I'm a newbie in this kind of apps and I
must develop one application that will connect to an Oracle Server.
Quote

Sure.. But you need SqlNet 2.x installed on your machine to make it work.
SqlNet is an Oracle product. I think also that you need at least ver 7.1 on
the server side. If the server is newer than 7.1 you already have SqlNet 2

regards
 Kri Poulsen

Re:Delphi with Oracle


You can use SQL Links to connect to Oracle via the BDE, bypassing ODBC.
Performance is excellent. There are other ways, too, like OLE automation
via Oracle Objects, but then you'll have to code most everything by hand
instead of using the VCL.

-Bryan

Quote
Filipe Peixinho wrote:

> Is there a way to connect a Delphi 2 app to an Oracle server without
using ODBC ?

> I think this may be a "stupid" question and you must be responding

this kind of questions very often but I'm a newbie in this kind of apps
and I must develop one application that will connect to an Oracle
Server.
Quote

> Thanks in advance

> Filipe Peixinho
> peixi...@cet.pt
> Aveiro-PORTUGAL

Re:Delphi with Oracle


Yes - you can!  

To connect to Oracle from Delphi - you need the following.
1.  SQLNet (contact your DBA to find out which version you may have)  There
are different versions for Win3.1, NT, etc.  Once this is configured you
then need...
2.  SQLLINKS from Borland.  This package ships with Delphi C/S - but you
can purchase it seperately (or at least you used to be able to!).  

     SQLNet is Oracle's low level way of connecting to its databases from
the desktop.  We run it over IP and it is fast.  SQLLinks is Borlands way
of interfacing with SQLNet.  It is also fairly fast - faster than ODBC.

If you need more info ....Send me a Email

GBMAC...@BCSC02.GOV.BC.CA

Filipe Peixinho <peixi...@cet.pt> wrote in article
<01bbfbde$938b1de0$a2588...@moliceiro.cet.pt>...

Quote
> Is there a way to connect a Delphi 2 app to an Oracle server without
using ODBC ?

> I think this may be a "stupid" question and you must be responding this

kind of questions very often but I'm a newbie in this kind of apps and I
must develop one application that will connect to an Oracle Server.
Quote

> Thanks in advance

> Filipe Peixinho
> peixi...@cet.pt
> Aveiro-PORTUGAL

Other Threads