Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
VB How-To Ask your "How do I do this with VB?" questions in this forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB How-To section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old January 3rd, 2006, 01:58 PM
Friend of Wrox
Points: 1,035, Level: 12
Points: 1,035, Level: 12 Points: 1,035, Level: 12 Points: 1,035, Level: 12
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: , , USA.
Posts: 196
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to jmss66
Default Run-time error 3706

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

  #2 (permalink)  
Old January 3rd, 2006, 02:46 PM
Friend of Wrox
Points: 7,395, Level: 36
Points: 7,395, Level: 36 Points: 7,395, Level: 36 Points: 7,395, Level: 36
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Capital Federal, , Argentina.
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

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
  #3 (permalink)  
Old January 3rd, 2006, 03:02 PM
Friend of Wrox
Points: 1,035, Level: 12
Points: 1,035, Level: 12 Points: 1,035, Level: 12 Points: 1,035, Level: 12
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: , , USA.
Posts: 196
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to jmss66
Default

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.

  #4 (permalink)  
Old January 3rd, 2006, 03:07 PM
Friend of Wrox
Points: 7,395, Level: 36
Points: 7,395, Level: 36 Points: 7,395, Level: 36 Points: 7,395, Level: 36
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Capital Federal, , Argentina.
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

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
  #5 (permalink)  
Old January 3rd, 2006, 03:17 PM
Friend of Wrox
Points: 1,035, Level: 12
Points: 1,035, Level: 12 Points: 1,035, Level: 12 Points: 1,035, Level: 12
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: , , USA.
Posts: 196
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to jmss66
Default

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.

  #6 (permalink)  
Old January 3rd, 2006, 03:26 PM
Friend of Wrox
Points: 7,395, Level: 36
Points: 7,395, Level: 36 Points: 7,395, Level: 36 Points: 7,395, Level: 36
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Capital Federal, , Argentina.
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

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
  #7 (permalink)  
Old January 3rd, 2006, 03:32 PM
Friend of Wrox
Points: 1,035, Level: 12
Points: 1,035, Level: 12 Points: 1,035, Level: 12 Points: 1,035, Level: 12
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: , , USA.
Posts: 196
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to jmss66
Default

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.


  #8 (permalink)  
Old January 3rd, 2006, 03:40 PM
Friend of Wrox
Points: 7,395, Level: 36
Points: 7,395, Level: 36 Points: 7,395, Level: 36 Points: 7,395, Level: 36
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Capital Federal, , Argentina.
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

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
  #9 (permalink)  
Old January 3rd, 2006, 04:04 PM
Friend of Wrox
Points: 1,035, Level: 12
Points: 1,035, Level: 12 Points: 1,035, Level: 12 Points: 1,035, Level: 12
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: , , USA.
Posts: 196
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to jmss66
Default

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"



  #10 (permalink)  
Old January 3rd, 2006, 04:19 PM
Friend of Wrox
Points: 7,395, Level: 36
Points: 7,395, Level: 36 Points: 7,395, Level: 36 Points: 7,395, Level: 36
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Capital Federal, , Argentina.
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

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

HTH

Gonzalo




Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert Query Error & Run-Time Error 3022 DavidWE Access 1 July 31st, 2008 11:17 AM
Run-time Error '3706' Provider cannot be found Star007 VB How-To 1 August 10th, 2006 05:02 AM
Run-time Error '3706' Star007 Beginning VB 6 1 April 20th, 2006 11:58 AM
Run-time Error '3706' Star007 VB Databases Basics 0 April 6th, 2006 07:01 AM
Run-time Error '3706' Provider cannot be found. It Star007 Pro VB Databases 1 April 5th, 2006 04:55 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.