Help !! Oracle connection problems, online and so on!

Help !! Oracle connection problems, online and so on! Delphi/Windows SDK/API
Http://www.delphi2007.net/DelphiDB/html/delphi_20061215193831284.html
Connect to the Oracle database, computer name yd811, Services Name: yd811, Global Database Name yd811.world

No problem. The connection name is yd811.

There is a problem with connecting to a computer that has installed the Oracle obdc driver. There is a problem with connecting to ADO, odac 5.7.0.28, And DOA 4.0.7.1 respectively (the connection method is the same as that with the Oracle client installed)
The problem is that there is no listener.
Corresponding service name not found
ORA-12514: TNS: Listener does not currently know of Service requested in connect Descriptor

I have seen many people on the Forum saying that odac can be directly connected without installing client wine. I don't know how you connected it. I have read the demo and there is nothing special about it.

This problem is solved by myself.
Select "Net-> Option", and fill in the irrelevant information.

However, this net mode seems to be a lot of Asian, and even case when sentence can be written. It seems that it mainly does not support text characters. Which of the following statements has been used?

Can I directly connect to odac without installing a client? If so, I have to find another one.

Where can I download odac?

If you do not install the client, do you need to install an installation package?

You can directly connect to odac using the net method. You do not need to use the client.ProgramUse the odac control in

Thank you for your masterpiece and finally know how to connect!
The connection string is:

Username/password @ IP Address: Port: dbid

Note:
With orasession1 do
Begin
Autocommit: = false;
Options. Net: = true;
Connectstring: = format ('% S/% s @ % s: % d: % s', ['test', 'test', '123. 168.1.1 ', 1521, 'ora9 ']);
Loginprompt: = false;
Open ();
End;

Thank you ~

The landlord is also a good guy, learning

however, this net mode seems to be a lot of Asian, even when the case when sentence is written, it seems that it mainly does not support text characters, is there any major user who has used it? Oracle's PLSQL syntax is not used in this way. For SQL Server, Oracle uses
decode function. Decode ('field name', 'condition 1', 'value 1',...)