Problem

Discussion in 'Databases' started by frictionadd, Oct 12, 2003.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. System.Data.OleDb.OleDbException: No error information available: REGDB_E_CLASSNOTREG(0x80040154).

    What is this? I am getting it both on my personal web server and on this discountASP.net one. Below is posted the code that creates the error and the web.config information to decipher it. Also, in the user section of the website on discountasp.net it tell's me what my Server.MapPath is so i put that in the web.config. The database is an Access XP mdb in a "database" folder in the root of my site.

    Line 26: string connectionString = ConfigurationSettings.AppSettings["ConnectionString"];
    Line 27: OleDbConnection Conn1 = new OleDbConnection(connectionString); // The error is on this line.

    web.config:
    <add key="ConnectionString" value="Provider=Microsoft Access Driver (*.mdb)};Data Source=x:\xxxxx\xxxxxxx\htdocs\database\rockweb.mdb" />


    Thanks in advance for any responses.
     
  2. Thanks for the help. About an hour later, however, I found the error and fixed it. It turns out that the DRIVER is supposed to be the "Microsoft Access Database" string and the Provider should be the library to load it with. The final string looks like:

    Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\xxx\xxxxxxxx\htdocs\database\rockweb.mdb;

    Thanks
     
  3. this error occurs when a COM class is not registered. Looking at your connection string (you're going to kick yourself after I say this) it looks like there is an extraneous curly-brace in the provider name. So it's probably trying to load the DLL for a provider that doesn't exist.
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page