In the development of PC, installed the oracle9i lite client, and configure the tnsnames. Ora file, up sqlplus can normal connected to oralce data,
If using Delphi7.0 oracle development program, through the ADOConnection components connected the oralce, how to configure?

CodePudding user response:

Suggested by SQL socket connection, connection character by

 the ConnectionString:=PromptDataSource (Handle, "); 

To obtain,

CodePudding user response:

Rendering, step by step to get connected characters, and then to the ADO connection control,

CodePudding user response:

The to lyhoo163
Thank you for your reply, I also am such operation,

In addition:
I found the problem, the same operation, can be on a 32-bit machine, there is a problem, but in 64 the machine BDE 64 the machine does not support? Have what method to solve?

CodePudding user response:

Using ADO socket connection, do not use the BDE,

CodePudding user response:

Should be on a 64 - bit, take a look at the connection parameters are correct,

CodePudding user response:

There seems to be a oracle controls

CodePudding user response:

With the connection string.

CodePudding user response:

Undac direct and convenient

CodePudding user response:

If you can't speculation, honestly client install oracle client, ensure the connection is no problem,

CodePudding user response:

Suggest using UniDAC