New to Oracle and ODAC

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
GHill
Posts: 12
Joined: Thu 02 Jun 2005 14:19

New to Oracle and ODAC

Post by GHill » Fri 17 Mar 2006 14:50

I have been using MyDAC for some time now and it is a great product. It is time for me to break into the Oracle world.
I downloaded your DEMO version of ODAC and tried to use it like MyDAC. IOW, I click on the component and fill in the blanks in the object inspector and click connect to test the connection.

I can't get this to work in ODAC. :(

I can connect to the Oracle database with AquaData using Oracle9i/10G, so I have the necessary login and information.

Can you offer any information for me?
Top
Alex
Posts: 655
Joined: Mon 08 Nov 2004 08:39

Post by Alex » Mon 20 Mar 2006 13:27

Please try our demo projects, they use standard Scott schema. So if this user account is unlocked you can use the following default Login\Password: Scott\Tiger.
If you encounter any future problems - please specify your error message to help us determine the problem source.
Top
Guest

Post by Guest » Tue 21 Mar 2006 23:38

OK..lets try this.
I have a new computer XP Pro with delphi7 loaded (no oracle stuff). Other than ODAC loaded, and an oracle 10g account what else will I need?

I see things like having an oracle ODBC driver and TNSNAMES.ORA and a couple more .ORA files.

As you can guess... I know nothing about oracle. I don't know that much about MySQL either, but your MyDAC lets me access MySQL with little trouble. I am just looking to access the data in the Oracle database.
Top
Challenger
Devart Team
Posts: 925
Joined: Thu 17 Nov 2005 10:53

Post by Challenger » Wed 22 Mar 2006 10:57

To connect to Oracle server you should have Oracle client insatalled. Specify Username, Password and Server in TOraSession component. If you don't have Oracle client insatalled you can use Net option. In this case you shoud set Net option to True and specify server name in the following form Host:Port:SID. For more information please refer to ODAC help.
Top
GHill
Posts: 12
Joined: Thu 02 Jun 2005 14:19

Post by GHill » Wed 22 Mar 2006 14:18

Thank you
Top
AntonyGumi
Posts: 3
Joined: Tue 07 Mar 2006 09:12

Newbie

Post by AntonyGumi » Thu 13 Apr 2006 02:35

Hi. I have 3 tier architecture running in my company: Client PC---WebServer---DatabaseServer(Oracle).
ASP web based application is stored in Web Server.
I dont want to install Oracle Client anywhere on my architecture.
Will it be possible to have Client PC connected to the Database Server via Web Server without having Oracle Client installed?
Please, help me
Regards,
Antony
Top
Challenger
Devart Team
Posts: 925
Joined: Thu 17 Nov 2005 10:53

Post by Challenger » Fri 14 Apr 2006 14:28

If you want to connect to Oracle server without Oracle Client you should use Net option.
Top
Post Reply

Return to “Oracle Data Access Components”