Page 1 of 1
New to Oracle and ODAC
Posted: Fri 17 Mar 2006 14:50
by GHill
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?
Posted: Mon 20 Mar 2006 13:27
by Alex
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.
Posted: Tue 21 Mar 2006 23:38
by Guest
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.
Posted: Wed 22 Mar 2006 10:57
by Challenger
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.
Posted: Wed 22 Mar 2006 14:18
by GHill
Thank you
Newbie
Posted: Thu 13 Apr 2006 02:35
by AntonyGumi
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
Posted: Fri 14 Apr 2006 14:28
by Challenger
If you want to connect to Oracle server without Oracle Client you should use Net option.