using LLBL 2.6, .NET 3.51sp1, VS2010 RC
I am trying to create an LLBL project on windows 7 64-bit for an Access database source. When I select the database driver for MS Access and then select the database file then click on <Test Connection> button, I receive the following error message
Connection failed Error: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine
When I create a connection string inside visual studio's project settings, I am successfull in creating the connection string and at run-time I can retrieve and access the data from the MS Access file.
Since I want my DAL from LLBL, how can I resolve this matter?
The exe does run in 32-bit BUT when I click on the button to select the Access MDB file, it hang s. The funny thing about this is that it is only happening with the Access driver. If I select the SQL driver it would work fine
2- using the CorFlags utility to force run the LLBL designer in 32-bit, the screen capture shows the errors I am getting.
It is basically telling me that I need to use the switch /Force because LLBL.exe is strongly signed. When I do so, I get another error telling me that using the /Force switch will invalidate the signature!!
If it stalls on the ms access db: do you have it open? Is the file locked by another application? Other than that, I don't know... the 32bit runner should run the designer under 32bit and thus make sure the oledb provider will work.
If you run it under 32bit on another machine, is the same mdb file readable?
Frans.. as I am doing this small application as a proof of concept (a real life application mind you) to adopt WPF, would you advice using the LLBL beta for this case ?
The runtime has not changed much in v3, and we don't have a known bug logged for the runtime/templates at the moment, so you shouldn't run into a problem with it. It's doable to alter v2.6 to support .net 4.0 btw. I'll dig up a thread which documents it, just a sec.