Recently looking for a problem, the passenger flow tool in Ado+oracle remote access to the database when some of the machines reported errors, as shown in the title, the same passenger flow center Vascenter also have the same problem-----test connection failed
But using other tools pl/sql, and so normal can connect, configuration is no problem,
After you have tried various methods, finally write down the steps to find out the same questions:
1. Install Oracle Driver
The changes are in the Oracle client with the option of what oci,ole DB,ODBC, etc.
2, configure the remote connection string,
Know the remote instance name, IP address, protocol, port, and configure it in sequence.
3, if it is not successful------and then do the operation
Still unsuccessful: Oracle client and network components were not found. These components are part of Oracle's 8i or higher client software installation provided by Oracle Company. You will not be able to use this provider until these components are installed
Processing: Assign the installation directory Oracle permissions to the Users group, etc., or give everyone a direct grant without regard to security, for the setting to take effect, it is best to restart the machine
After the above steps, basically no problem, if there are problems, we discuss together, hehe.
Finally, some questions are explained:
First, the use of Plsqldeveloper can be connected, why our program is not connected
Our program is to use the encapsulated ADO library, this need to have the corresponding driver support, and Plsqldeveloper does not need
Ii. differences between using Microsoft OLE DB Provider for Oracle (1) and Oracle Provider for OLE DB (2)
The first is provided by Microsoft, there is no second comprehensive function, such as some data type support, BLOB, CLOB, NCLOB, etc.