Urgent urgent!!! Under the VC ADO to access Oracle database, an error: the provider is not found, may be program was not correctly installed, installed the client, and PL/SQL connection success! For a great god!!!!! For a great god!!!!! Urgent please!!!!!!

CodePudding user response:

Use this method to get the connection string a try,

CodePudding user response:

There is no correct installation server,

The client can act as a server?

CodePudding user response:

I mean my program installed on each computer, each computer is to install the client a client of my program to access the database, or to the errors, a client is 500 m, and my program to the user, they need to install ORACLE client, this is unreasonable, the customer will not to install the other things, please teach a great god, has nothing to do with the server, is now a program used in the user, the user after installation problems can't use the program cannot access the ORACLE database

CodePudding user response:

What is the ORACLE client?

CodePudding user response:

Yes, can install oracle client, or you in SQL Server doesn't have to,

CodePudding user response:

ADO to access Oracle can use MS OLEDB can also use Oracle OLEDB

CodePudding user response:

I also met the same problem, there is no solution!

CodePudding user response:

If your program is a 32 bit, and oracle is 64, it would be to install a 32 bit oracle client,

CodePudding user response:

This post is too long, I hope it can help people see, vc is 32-bit, if install oracle is 32-bit, otherwise don't call, if you can compile 64 - bit, install 64 - bit oracle can also

CodePudding user response:

In a 64 - bit Windows:
64 exe and DLL in the directory c: \ Windows \ sys tem32 directory.
32 bit exe and DLL in the directory c: \ Windows \ sys wow64 directory.
So pay attention to:
In win64 system registered under 32-bit ocx DLL to 32 ocx or copy the DLL to the c: \ Windows \ syswow64 \ directory,
And registered to c: \ Windows \ syswow64 \ regsvr32 XXXXXXX ocx or DLL
Under win64 a system set up 32-bit programs use a database alias to c: \ Windows \ \ syswow64 \ cliconfg exe
Under win64 a system set up a 32-bit application system DSN to c: \ Windows \ \ syswow64 \ odbcad32 exe

CodePudding user response:

http://bbs.csdn.net/topics/392143402

CodePudding user response:

Can you tell me the final solution?

CodePudding user response:

Using ado to connect mysql will install mysql client, because the system don't know these foreign database, unless the Microsoft's own,
Oracle must also want to install the client,