(I am using ORACLE ADOConnection connection, the client has been installed and directory's authorization, the system PATH has been added)
The breakpoint debug mode:
ADOConnection1. Connected:=False;
ADOConnection1. The ConnectionString:='Provider=MSDAORA. 1; Password=sa123; User ID=sa; Data Source=wouldn; Persist Security Info=True ';
ADOConnection1. Connected:=True;//hint here did not install ORACLE client or network components;

But,,,
Compilation out after running mode, incredibly can be the connection is successful, this situation lead to I can not breakpoint debugging program, could you tell me who come across this kind of situation, how to solve?

CodePudding user response:

No one know?

CodePudding user response:

I didn't understand what you want to do? Breakpoint debugging and running the program have any conflict? Directly to set breakpoints select debug mode,
In addition, the Data Source=former, are you sure your former is the IP address of the server? Can you ping? Indicates a error is likely to be on your server address connection problems, may be a firewall or antivirus software block,

CodePudding user response:

Can use unidac or firedac this from the client direct control, worry more

CodePudding user response:

With unidac save trouble

CodePudding user response:

Oh, with unidac save trouble, ado to the dead

CodePudding user response:

With FireDAC, proposal, UniDAC ODAC (this is the only do not need to install the Oracle client, also do not need any real direct Oracle client files), such as using ADO very troublesome, to install the Oracle client, configuration,

CodePudding user response:

This program is the old bad I change control, main is another development computer the same environment, can be a breakpoint debugging (in debug mode to connect ORACLE is also normal, not an error), so where should be set has a problem, mainly compiled programs run on my computer to connect ORACLE is also no problem, that is strange!
More strange is my this computer is normal can debug connection before, I don't know set up where they became so

CodePudding user response:

Don't use ODAC, STH over and over again,

CodePudding user response:

1, install the odac
2, the adoConnection. The ConnectionString:=the Provider=OraOLEDB. Oracle. 1; The Data Source=% s. User ID=% s. Password=% s. Persist Security Info=True

CodePudding user response:

Preferably in odac udca fdac, ado to connect oracle is a problem in the morning and evening, we also do that