Page 1 of 1

ODAC, TOraSession without oraclient

Posted: Thu 15 Sep 2005 10:00
by che_guevara
Hi!

I downloaded ODAC trial version.
I have Delphi 6 Enterprise and oracle client -> win xp prof hungary
connected Oracle 8i server (not on the web)-> w2k server english.

I don't want to use the oracle client. I like only one exe file the client
sides.

I have a big problem.
I did not connect the db server, if "net" was checked.
Error text: "NET: Invalid SID"

Params:

username: somebody
password: something
server: 192.168.1.135
NET: checked
ConnectPrompt: checked

The port is default 1521.

I read crlab website:
"Also with Net option ODAC allows to connect without Oracle client software installed on workstation. In such case ODAC requires only TCP/IP protocol and allows to build really thin database application. "

Is it not work!

Why?

What's wrong?

Posted: Thu 15 Sep 2005 15:47
by Alex
You need to assign Server property with a string that contains database name, Oracle service name, and port in the following format: Host:Port:SID.

Code: Select all

Session.Server := '205.227.44.44:1521:orcl';
For more information please see "Working with ODAC Net" topic in ODAC help.