da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: Oracle direct access without using OCI

Forum List » AnyDAC » v 1.x General English

gicla
User

Junior Boarder

Posts: 11

Karma: 0

Oracle direct access without using OCI

Posted: 2007/10/02 07:54

Is it possible with ANYDAC to access an Oracle DB without using the oracle client?
If not, will it be possible in the future?

Thanks
Claudio

Diman

Admin

Posts: 1478

Karma: 18

Re:Oracle direct access without using OCI

Posted: 2007/10/02 09:31

Hello

No. But you can consider to use Oracle Instant Client.

Regards,
Dmitry

gicla
User

Junior Boarder

Posts: 11

Karma: 0

Re:Oracle direct access without using OCI

Posted: 2007/10/08 11:03

Thanks, I did and I can now access my ORACLE DB with INSTANT CLIENT but only using TNSNAMES.ORA located into TNS_ADMIN path.

Is there a way with AnyDAC to use INSTANT CLIENT without the TNSNAMES.ORA but specifying connection properties directly into the TADConnection object or somewhere else at runtime?
If Yes, can you please make a connection example.

Thanks
Claudio

Diman

Admin

Posts: 1478

Karma: 18

Re:Oracle direct access without using OCI

Posted: 2007/10/08 11:15

Hi Claudio

You can set as Database parameter value the full TNS connection string, as it is in tnsnames.ora. For example:


 (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = DA)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))

There you will need to substitute HOST, PORT, SERVICE_NAME appropriate for your environment.

Regards,
Dmitry

gicla
User

Junior Boarder

Posts: 11

Karma: 0

Re:Oracle direct access without using OCI

Posted: 2007/10/09 03:55

Thanks a lot. It solved!

Forum List » AnyDAC » v 1.x General English