Wrox Programmer Forums
|
BOOK: Beginning Visual Basic 2005 Databases ISBN: 978-0-7645-8894-5
This is the forum to discuss the Wrox book Beginning Visual Basic 2005 Databases by Thearon Willis; ISBN: 9780764588945
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning Visual Basic 2005 Databases ISBN: 978-0-7645-8894-5 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
 
Old May 8th, 2006, 10:49 AM
Authorized User
 
Join Date: May 2006
Posts: 10
Thanks: 1
Thanked 0 Times in 0 Posts
Default Chapter 5 Connecting to Access Database

Hello Out There,
I have a problem with opening a connection to the TimeTracker database in Access. I opened a fileDialog box and navigated to the Time Tracker Access database. The address of Time tracker is then inserted into the txtDataBase but, when I try to open the connection I get this error message:

The 'Microsoft.Jet.oledb.4.0' provider is not registered on the local machine

Why am I getting this error message and why can't I open the connection?
Thanx,
robodent

 
Old May 8th, 2006, 06:24 PM
Authorized User
 
Join Date: Dec 2003
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to luishrd
Default

Hi again robodent,

Could you please Copy and Paste the piece of code with the error?

I used this to test and it works, all you need to change is the path, but the Dialog takes care of that:

Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=D:\Documents\Solutions\Time Tracker\ProjectTimeTracker.mdb"

Dim cn As New OleDbConnection(strConn)

cn.Open()

PS: if you hard code the connection string, does it work? also you DO have access or the Microsoft Data Access Components (Mdac) installed.

Good luck mate

________________________________
I'm just a noob...
 
Old May 8th, 2006, 10:21 PM
Authorized User
 
Join Date: Dec 2003
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to luishrd
Default

Hi again also check out this link and download the tool to make sure your MDAC is configured correctly...

http://www.dotnet247.com/247referenc...yurl.com/388bm

I'm just a noob
 
Old May 10th, 2006, 07:37 AM
Authorized User
 
Join Date: May 2006
Posts: 10
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Hello luishrd,

Thank you for responding to my question. It seems that I victimized myself again with another misspelling. It is amazing how many times I can look at a common word such as "Microsofoft" and not notice it was misspelled!!

robodent


 
Old May 11th, 2006, 03:32 PM
Authorized User
 
Join Date: Dec 2003
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to luishrd
Default

Believe me I know!!! LOL


__________________________
I'm just a noob





Similar Threads
Thread Thread Starter Forum Replies Last Post
connecting to a remote Access Project Database bright_mulenga Access 2 August 15th, 2006 06:33 AM
Problem Connecting to Microsoft Access Database eric_lim_1 Classic ASP Databases 1 September 17th, 2005 03:12 AM
Issues Connecting to an Access 2000 Database... Jonny ADO.NET 1 February 11th, 2004 09:54 AM
Connecting to an Access 2000 database Jonny .NET Web Services 0 November 10th, 2003 03:13 PM
connecting PHP to an MS Access database pb7 PHP Databases 1 September 18th, 2003 04:28 PM





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