Hi Guys,

I am getting this error message "Run-time error 3706. Provider can not be found. It may not be properly installed."

I have installed MDAC 2.8 SP1 and Jet 4.0 SP 8 and I still get this error message. I also used the Package and Deployment Wizard hoping that this will solve my problem. It still gave me the same error message. If I run the compile executable program in my workstation it runs fine but if I go to a different work station, I get the error message. I have two database connection going in my program. One is to ACCESS 2002 and the other one is to an Oracle Database 8.i. Is there something else I need to do to get the executable working on any workstation?

Thanks,
Judy

hi there..

do you know what provider are you missing??

maybe the workstation you are trying your prog. in lacks the oracle client driver?


HTH

Gonzalo

It must be the Oracle OLEDB since I have updated the MDAC and Jet4.0.

Below is an excerpt from my connection string:
"Provider=OraOLEDB.Oracle.1

Do you know how or where I can get the Oracle Client Driver so I can install it in the workstation the program will run? This is the first time I have connected to Oracle, I normally just use ACCESS and it goes smoothly.

Thanks for your help.

mmm. the client driver comes with the oracle.. i dont know how to distribute it.. i think you have to install it from the database cd..

but i don't know much about oracle..

HTH

Gonzalo

Now that you mentioned about installing it from the CD, it just reminded me that all workstations have Oracle installed because our application uses Oracle as the database.

The only difference between my workstation and the others is I have VB 6.0 installed in mine. Like I said, it works on mine without a glitch. I had this problem before with one other program but when I ran the Deployment wizard, it fixed the problem.

The error message clearly states a Provider problem. I am at a lost.

mmm.. do you know how to make a udl file??
if so.. try to connect from it to see if you really have connection..

also try your connection string inside it.

if dont, write again so i can xplain it to you...

HTH

Gonzalo

I don't know how to write a udl file or what it is. Can you please help me write one so I can test it. I know I can establish connection with my connection string because when I run the executable from my workstation, it connects to Oracle and updates the ACCESS database with records from Oracle.

just writte a blank text file.. then renamed it to xx.udl and open it (with dclick).. you will see the property pages to make a connection..
you can edit the file to see the text in it (it will have the conn string)..

try to open that file an establish a connection from them.. if you dont see there the driver you are using, then you will have to install it.

HTH

Gonzalo

This is my connection string below and I copied this exactly to the connection string.

"Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=IDName;Data Source=server_name;Password=password"


I got an error message when I tested the connection because I am sure I placed the connection string wrong.

If I will just go through the motion of using the Datasource Name Oracle OLEDB Driver that is provided, the connection will work but if I put my connection string in, it gives me the error message below and yet I am able to get connection when it is in my VB program.

Error message:
"Test Connection failed because of an error in initiazing provider. Datasource Name not found and no default driver specified"

from this, can you do the work backwards?? that is.. try to make the string from the property page??

HTH

Gonzalo