-
Oct 27th, 2009, 12:33 AM
#1
Thread Starter
Junior Member
run-time error 3706 provider cannot be found
Hi,
I have packaged the VB files and used the provider,
strProvider = "Provider= Microsoft.Jet.OLEDB.3.51;"
strDataSource = App.Path
strDataBaseName = "\kra.mdb;"
When installed the package in some other machine and try to connect the DB , i see the error
run-time error 3706 , provider cannot be found. it may not be properly installed.
Please suggest the fix for this.
Thanks
Giri
-
Oct 27th, 2009, 02:21 AM
#2
Re: run-time error 3706 provider cannot be found
You might be missing some dll or ocx files... Which one are you using... ADO or DAO..?
What is the program used for packaging??
If my post was helpful to you, then express your gratitude using Rate this Post.
And if your problem is SOLVED, then please Mark the Thread as RESOLVED (see it in action - video)
My system: AMD FX 6100, Gigabyte Motherboard, 8 GB Crossair Vengance, Cooler Master 450W Thunder PSU, 1.4 TB HDD, 18.5" TFT(Wide), Antec V1 Cabinet
Social Group: VBForums - Developers from India
Skills: PHP, MySQL, jQuery, VB.Net, Photoshop, CodeIgniter, Bootstrap,...
-
Oct 27th, 2009, 02:49 AM
#3
Thread Starter
Junior Member
Re: run-time error 3706 provider cannot be found
Hi,
Am using ADO recordset and the process i followed is
start menu-> Microsoft Visual studio -> Microsoft Visual studio tools-> package and deployment wizard
-
Oct 27th, 2009, 02:52 AM
#4
Re: run-time error 3706 provider cannot be found
Have you tried downloading the latest Jet drivers from microsoft's website
If my post was helpful to you, then express your gratitude using Rate this Post.
And if your problem is SOLVED, then please Mark the Thread as RESOLVED (see it in action - video)
My system: AMD FX 6100, Gigabyte Motherboard, 8 GB Crossair Vengance, Cooler Master 450W Thunder PSU, 1.4 TB HDD, 18.5" TFT(Wide), Antec V1 Cabinet
Social Group: VBForums - Developers from India
Skills: PHP, MySQL, jQuery, VB.Net, Photoshop, CodeIgniter, Bootstrap,...
-
Oct 27th, 2009, 03:02 AM
#5
Thread Starter
Junior Member
Re: run-time error 3706 provider cannot be found
nope.
problem is, its working in my PC.
but when i install the package in some other PC where VB is not installed i am facing the issue.
-
Oct 27th, 2009, 03:21 AM
#6
Re: run-time error 3706 provider cannot be found
How are you distributing your application? Have you developed your application through P&D or similar kind of packaging software?
A good exercise for the Heart is to bend down and help another up...
Please Mark your Thread "Resolved", if the query is solved
MyGear:
★ CPU ★ Ryzen 5 5800X
★ GPU ★ NVIDIA GeForce RTX 3080 TI Founder Edition
★ RAM ★ G. Skill Trident Z RGB 32GB 3600MHz
★ MB ★ ASUS TUF GAMING X570 (WI-FI) ATX Gaming
★ Storage ★ SSD SB-ROCKET-1TB + SEAGATE 2TB Barracuda IHD
★ Cooling ★ NOCTUA NH-D15 CHROMAX BLACK 140mm + 10 of Noctua NF-F12 PWM
★ PSU ★ ANTEC HCG-1000-EXTREME 1000 Watt 80 Plus Gold Fully Modular PSU
★ Case ★ LIAN LI PC-O11 DYNAMIC XL ROG (BLACK) (G99.O11DXL-X)
★ Monitor ★ LG Ultragear 27" 240Hz Gaming Monitor
★ Keyboard ★ TVS Electronics Gold Keyboard
★ Mouse ★ Logitech G502 Hero
-
Oct 27th, 2009, 03:29 AM
#7
Re: run-time error 3706 provider cannot be found
How are you distributing your application? Have you developed your application through P&D or similar kind of packaging software?
Hi,
Am using ADO recordset and the process i followed is
start menu-> Microsoft Visual studio -> Microsoft Visual studio tools-> package and deployment wizard
He is using P&D...
If my post was helpful to you, then express your gratitude using Rate this Post.
And if your problem is SOLVED, then please Mark the Thread as RESOLVED (see it in action - video)
My system: AMD FX 6100, Gigabyte Motherboard, 8 GB Crossair Vengance, Cooler Master 450W Thunder PSU, 1.4 TB HDD, 18.5" TFT(Wide), Antec V1 Cabinet
Social Group: VBForums - Developers from India
Skills: PHP, MySQL, jQuery, VB.Net, Photoshop, CodeIgniter, Bootstrap,...
-
Oct 27th, 2009, 03:31 AM
#8
Re: run-time error 3706 provider cannot be found
Ah I missed that post... That's what happens when you are trying to answer more multiple posts
A good exercise for the Heart is to bend down and help another up...
Please Mark your Thread "Resolved", if the query is solved
MyGear:
★ CPU ★ Ryzen 5 5800X
★ GPU ★ NVIDIA GeForce RTX 3080 TI Founder Edition
★ RAM ★ G. Skill Trident Z RGB 32GB 3600MHz
★ MB ★ ASUS TUF GAMING X570 (WI-FI) ATX Gaming
★ Storage ★ SSD SB-ROCKET-1TB + SEAGATE 2TB Barracuda IHD
★ Cooling ★ NOCTUA NH-D15 CHROMAX BLACK 140mm + 10 of Noctua NF-F12 PWM
★ PSU ★ ANTEC HCG-1000-EXTREME 1000 Watt 80 Plus Gold Fully Modular PSU
★ Case ★ LIAN LI PC-O11 DYNAMIC XL ROG (BLACK) (G99.O11DXL-X)
★ Monitor ★ LG Ultragear 27" 240Hz Gaming Monitor
★ Keyboard ★ TVS Electronics Gold Keyboard
★ Mouse ★ Logitech G502 Hero
-
Oct 27th, 2009, 10:33 AM
#9
Re: run-time error 3706 provider cannot be found
Thread moved to 'Database Development' forum (the 'VB6' forum is only meant for questions which don't fit in more specific forums)
The problem is that the computer does not have the Microsoft.Jet.OLEDB.3.51 provider installed. It may have a different version instead (eg: Microsoft.Jet.OLEDB.4.0 ), or none at all.
As such, what you should do is install a valid version of Jet with your application (and use the same version number in your code). You can find the download for Jet via the link at the bottom of my signature.
-
Oct 27th, 2009, 08:33 PM
#10
Thread Starter
Junior Member
Re: run-time error 3706 provider cannot be found
Hi,
Jet 4.0 Service Pack 8 (SP8) for Windows XP (KB829558)
is it i need to install ?
-
Oct 28th, 2009, 01:28 AM
#11
Re: run-time error 3706 provider cannot be found
Hi,
Jet 4.0 Service Pack 8 (SP8) for Windows XP (KB829558)
is it i need to install ?
Try them !
If my post was helpful to you, then express your gratitude using Rate this Post.
And if your problem is SOLVED, then please Mark the Thread as RESOLVED (see it in action - video)
My system: AMD FX 6100, Gigabyte Motherboard, 8 GB Crossair Vengance, Cooler Master 450W Thunder PSU, 1.4 TB HDD, 18.5" TFT(Wide), Antec V1 Cabinet
Social Group: VBForums - Developers from India
Skills: PHP, MySQL, jQuery, VB.Net, Photoshop, CodeIgniter, Bootstrap,...
-
Oct 28th, 2009, 09:27 AM
#12
Re: run-time error 3706 provider cannot be found
You should install that on your computer, and the users computers.
You should also change your code from "3.51" to "4.0".
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|