|
Subject:
|
Run-time error 3706
|
|
Posted By:
|
jmss66
|
Post Date:
|
1/3/2006 12:58:31 PM
|
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
|
|
Reply By:
|
gbianchi
|
Reply Date:
|
1/3/2006 1:46:38 PM
|
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
|
|
Reply By:
|
jmss66
|
Reply Date:
|
1/3/2006 2:02:21 PM
|
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.
|
|
Reply By:
|
gbianchi
|
Reply Date:
|
1/3/2006 2:07:06 PM
|
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
|
|
Reply By:
|
jmss66
|
Reply Date:
|
1/3/2006 2:17:56 PM
|
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.
|
|
Reply By:
|
gbianchi
|
Reply Date:
|
1/3/2006 2:26:24 PM
|
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
|
|
Reply By:
|
jmss66
|
Reply Date:
|
1/3/2006 2:32:51 PM
|
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.
|
|
Reply By:
|
gbianchi
|
Reply Date:
|
1/3/2006 2:40:22 PM
|
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
|
|
Reply By:
|
jmss66
|
Reply Date:
|
1/3/2006 3:04:13 PM
|
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"
|
|
Reply By:
|
gbianchi
|
Reply Date:
|
1/3/2006 3:19:41 PM
|
from this, can you do the work backwards?? that is.. try to make the string from the property page??
HTH
Gonzalo
|
|
Reply By:
|
jmss66
|
Reply Date:
|
1/3/2006 3:51:38 PM
|
That's what I am working on right now and I am encountering errors in the program like if I am openning a view, it's not letting, otherwise everythings working. The connection string on the property page is below, maybe you can help me figure out what I can strike out from the connection string.
objConnOracle = "DRIVER={ORACLE ODBC DRIVER};SERVER=HFIRE_PRD;UID=ID_NAME;PWD=PASSWORD;DBQ=HFIRE_PRD;DBA=W;APA=T;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;FRL=F;MTS=F;CSR=F;PFC=10;TLO=O;"
|
|
Reply By:
|
jmss66
|
Reply Date:
|
1/3/2006 4:09:34 PM
|
I get a run-time error 91;
Object variable or With block variable not set.
This is the error message I get. Once we get this resolved I will use this connection string for all Oracle connections. Thanks for your help.
|
|
Reply By:
|
jmss66
|
Reply Date:
|
1/3/2006 7:59:12 PM
|
I was wrong in pressuming that I get this error only when I access a view. I decided to use a table and it gave me the same error message. It seems like when there is no record in the table it gives me this error. I validate the recordset by with
If not recordset.eof then
update ACCESS table
End if
Where am I going wrong?
Thanks,
Judy
|
|
Reply By:
|
jmss66
|
Reply Date:
|
1/4/2006 8:39:38 AM
|
Okay, I finally got it to work. I had to try different connection strings. I ended up using the following connection string:
objConnOracle = "DRIVER={Microsoft ODBC for Oracle};UID=[MY_USERID];PWD=[MY_PASSWORD];SERVER=[SERVER_NAME];"
Thanks for your help. I appreciate all the suggestions you gave me. That got me started to experiment.
Cheers,
Judy
|
|
Reply By:
|
Star007
|
Reply Date:
|
4/6/2006 8:14:45 AM
|
hi,
the error msg is : Run-time Error '3706'
Provider cannot be found. It may not be properly installed.
I am having problem with my VB application. I was using sql server 2000 local on my pc with VB and it was working fine. NOw I have sql server 2005 express on a network pc.
when I changed the connection string for that, I am getting the above error
here is my connection string:
Dim cn As ADODB.Connection
Set cn = New Connection
cn.ConnectionString = "Provider=SQLNCLI.1;Integrated Security=SSPI;" & _
"Persist Security Info=False;" & _
"AttachDBFileName=" & App.Path & "\xstar_Data.mdf;Data Source=starsql\sqlexpress"
cn.Open
please help me.
I try installing the latest mdac_tpe and vbrun60sp5.exe for VB
but no help.
please help?????????
***************
***************
|
