ODAC, TOraSession without oraclient

[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?

[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.