Wrox Programmer Forums
Go Back   Wrox Programmer Forums > C# and C > C# 1.0 > C#
|
C# Programming questions specific to the Microsoft C# language. See also the forum Beginning Visual C# to discuss that specific Wrox book and code.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the C# 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 November 6th, 2003, 03:53 PM
Registered User
 
Join Date: Nov 2003
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default Can't open .MDB database

Hello,

I am a beginning programmer. Problem:

I am trying to open a Microsoft ACCESS database using OLEDB. The exception raised when trying to open the .MDB is "database is not registered on this machine"

Here is the code I am using:

using System;
using System.Data;
using System.Data.OleDB;

namespace Wrox.BeginningCSharpDatabases.Chapter05
{
  class Connection_OleDB {
    static void Main()
    {
      OleDBConnection thisConnection = new OleDBConnection(
                               @"Provider=Microsoft.Jet.OLEDB.4.0;" +
                                @"Data Source=c:\Northwind.MDB");

    // Open connection
    thisConnection.Open();
    }//end Main

No access databases will open. I am able to open SQL databases (by changing appropriate references)just fine.

How do you register an Access database on the local (or) remote machine???

Thanks so much in advance,

Baffled,
Saxitalis
 
Old November 7th, 2003, 04:18 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 440
Thanks: 0
Thanked 0 Times in 0 Posts
Default

What are the '@' there for!? My connection strings look something like this...
Code:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\someDatabase.mdb
Jacob.





Similar Threads
Thread Thread Starter Forum Replies Last Post
The Microsoft Jet database engine cannot open .mdb hunzian78@yahoo.com ASP.NET 1.0 and 1.1 Professional 13 February 1st, 2007 12:47 PM
Open mde or mdb access file from vb6 gorgo Pro VB 6 1 February 20th, 2006 01:39 AM
Using VB6 SP2 to Open Access 2003 .mdb DWSTERRETT VB Databases Basics 1 June 13th, 2005 08:24 AM
compacting an open mdb using VBA Dwight Pro VB 6 5 July 7th, 2004 01:53 PM
Beginning C# Databases - Can;t open .MDB file saxitalis All Other Wrox Books 0 November 6th, 2003 03:56 PM





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