Connecting to Access via the wizard  
Author Message
StumblingInTheDark





PostPosted: Visual Basic General, Connecting to Access via the wizard Top

I was attempting to use a DataGridView and am having troubles connecting to an Access Database.

I'm running the Data Source Configuration Wizard. I get to Choose Your Data Connection. I click New Connection. I click Change. I select Microsoft Access Database File. I click OK.

Here is where my problems start.

My box says Add Connection. In it is a field to enter a Connection String. It also has 3 buttons -> Test Connection, OK, Cancel. And it has a disabled Advance button.

I have 2 computers that show this.

2 other machines display what I expect. The box says Add Connection. It has the Change button that I clicked previously. It has the Browse button to search for my Database. It has the 3 buttons and disabled Advance button also.

Help!

Thanks!



Visual Basic18  
 
 
nobugz





PostPosted: Visual Basic General, Connecting to Access via the wizard Top

Be sure to pick the correct Data Source, you'll need "Microsoft Access Database File (OLE DB)". That's the only one that gives you a "Browse" button. Your box probably has the ODBC provider selected by default.

 
 
StumblingInTheDark





PostPosted: Visual Basic General, Connecting to Access via the wizard Top

Thanks for the reply nobugz.

When I start out initially, the Data Source is set to none. When I click on the drop-down box for the Data Source, it displays None, but on the bottom is a hotlink 'Add Project Data Source'. When I click that, it starts up the wizard.

I went through the steps again and when I select Microsoft Access Database File, the Description to the right reads "Use this selection to connect to a Microsoft Access database file using the native Jet provider through the .NET Framework Data Provider for OLE DB."

So I think it should work (like it does following the same steps on the other 2 computers), but I don't get the Browse button.

Is it possible that something isn't installed right or Any other ideas/suggestions

Thanks again for the reply.


 
 
nobugz





PostPosted: Visual Basic General, Connecting to Access via the wizard Top

Something is broken, I couldn't guess what. Very odd that you don't see the button instead of it just being disabled. Try to post a screenshot at Imageshack for us to look at. Also post one from a good computer if you're using VS2003. Try installing MDAC V2.8 SP1


 
 
StumblingInTheDark





PostPosted: Visual Basic General, Connecting to Access via the wizard Top

Thanks everyone for their help and thought!

In case anyone wants to see what was going on, I did put images over at Image Shack:

http://img99.imageshack.us/img99/5965/goodvx3.jpg

http://img236.imageshack.us/img236/6922/problemzh9.jpg

But before I got to come back here and post them, someone pointed me to http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=662216&SiteID=1&mode=1&PageID=2. It's towards the bottom of the page and the answer is that some (all ) registry cleaners seem to like to delete:

quoting:

HKEY_CLASSES_ROOT\CLSID\{F9AE8980-7E52-11d0-8964-00C04FD611D7}

Underneath this key should be a sub-key called "ProgID" with a value of "MSIDXS.1". If you can't find this, it is causing the problem you are seeing. Adding this back should fix the issue.

end quote.

Thanks again!