Jet.OLEDB.4 provider not registered error on Win 8.1

Posts   
 
    
Max avatar
Max
User
Posts: 221
Joined: 14-Jul-2006
# Posted on: 09-May-2014 17:49:46   

I'm using the latest version of LLBLGen Pro 2.6 (07-Nov-2012) to update an LLBLGen project based on Access 2000 MDB file.

On a new Win 8.1 x64 PC, I get the error "The 'Microsoft.Jet.OLEDB.4.0' provider is not registered" when I try to test the connection to the MDB database.

Things I've tried:

  • Start LLBLGen with the LLBLGenPro_x86.exe launcher, but then it lock when I try to navigate to the DB file (so I can't event try to test the connection)
  • copy all the LLBLGen folder in "c:\" : still get the "provider is not registered" error
  • manually register the Jet 4 DLL : still get the "provider is not registered" error
daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 10-May-2014 09:36:45   

I think this is related to the warning pointed in the documentation:

documentation wrote:

If you want to run LLBLGen Pro on a 64bit windows system and you want to retrieve Relational Model Data from an MS Access database, you will run into the limitation that Microsoft still hasn't shipped a 64bit MS Access JET driver. To overcome this, please run the LLBLGen Pro designer as a 32bit application. To do so, please use the 32bit enforcer helper executable LLBLGenPro_x86.exe which is located in the LLBLGen Pro installation folder and which will run the designer in 32bit, regardless whether you have a 64bit OS or not.

If you want to use the newer Microsoft Access Database Engine (ACE driver) which is supported on 64bit windows and which can also work with .accdb files (MS Access 2007/2010/2013), please visit this link at the Microsoft download center to obtain the engine to make the LLBLGen Pro MS Access driver work properly on 64bit and with .accdb files.

Max wrote:

Things I've tried: Start LLBLGen with the LLBLGenPro_x86.exe launcher, but then it lock when I try to navigate to the DB file (so I can't event try to test the connection)

I don't understand. Did you try to run it as Administrator?

(Edit) Is there any change that you try using a newer LLBLGen version (3.5 or 4)?

David Elizondo | LLBLGen Support Team
Max avatar
Max
User
Posts: 221
Joined: 14-Jul-2006
# Posted on: 10-May-2014 10:20:20   

thanks for the very fast response.

Max wrote:

Things I've tried: Start LLBLGen with the LLBLGenPro_x86.exe launcher, but then it lock when I try to navigate to the DB file (so I can't event try to test the connection)

I don't understand. Did you try to run it as Administrator?

mmmh... no, probably I didn't try to run it as admin. As soon as I get back to the office I'll try (monday).

(Edit) Is there any change that you try using a newer LLBLGen version (3.5 or 4)?

The project we are working on is very big (more than 300k line of codes), we started it in 2006 (this is why we use LLBLGen 2.6), and it's heavily based on LLBLGen class/entity/fields/enum/filter/prefetch path...

Can LLBLGen 3.5/4 generate code that is compatible with code generated by LLBLGen 2.6?

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 12-May-2014 06:55:06   

Max wrote:

mmmh... no, probably I didn't try to run it as admin. As soon as I get back to the office I'll try (monday).

Ok. We'll be looking forward for your tests.

Max wrote:

Can LLBLGen 3.5/4 generate code that is compatible with code generated by LLBLGen 2.6?

No. LLBLGen v3.5 generates code for target LLBLGen Framework v3.5, LLBLGen v4.0 generates code for target LLBLGen Framework v4.0, and so. You should schedule a v2.6->v3.x migration for the future, and then a migration to v4.x, that way you would benefit from the new features.

David Elizondo | LLBLGen Support Team
Max avatar
Max
User
Posts: 221
Joined: 14-Jul-2006
# Posted on: 12-May-2014 14:53:01   

daelmo wrote:

Max wrote:

mmmh... no, probably I didn't try to run it as admin. As soon as I get back to the office I'll try (monday).

Ok. We'll be looking forward for your tests.

No change, LLBLGen lock even if run as admin. It seem something related to the "files access" function: sometime it lock when I try to browse for he LLBLGen project, sometime, it lock when (after opening the LLBLGen project) I try to browse for the updated DB.

We solved by running LLBLGen in a virtual PC with WinXp simple_smile

daelmo wrote:

Max wrote:

Can LLBLGen 3.5/4 generate code that is compatible with code generated by LLBLGen 2.6?

No. LLBLGen v3.5 generates code for target LLBLGen Framework v3.5, LLBLGen v4.0 generates code for target LLBLGen Framework v4.0, and so. You should schedule a v2.6->v3.x migration for the future, and then a migration to v4.x, that way you would benefit from the new features.

Ok, thanks for the info.