Hi,

LLBLGen 2.6 and 3.5

i've got a project that i developed against Access 2003. (OLEDB.12.0). I moved the project over to a machine that only has Office 2010 (OLEDB.14.0).

I can open the project and generate the code, but if i try to refresh catalog if gives the subject error message. I can still explore the catalog in catalog explorer though, so the access drivers are definitely working.

Any ideas? I don't want to have to install the runtimes for 12.0. I just want to change the 12 to a 14

Here is the stack from 3.5: LLBLGen Pro version 3.5. Build March 23rd, 2012 -----[Core exception]-------------------- at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper) at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OleDb.OleDbConnection.Open() at SD.LLBLGen.Pro.Gui.Controls.WizardPages.MetaDataRetrievalWizard_Step_ConnectionData.TestConnectionData(Boolean showSuccess)

Thanks

steven

I think you need the OLDB for Jet v4.0 Also, Are you on a x64 machine? Please read the MS Access part of this link to understand what you need to get this working.

daelmo wrote:

I think you need the OLDB for Jet v4.0 Also, Are you on a x64 machine? Please read the MS Access part of this link to understand what you need to get this working.

hi David,

thanks for the quick response and the link. That got me sorted. I am running on 7 64-bit. Have a great weekend.

Cheers

Steven

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), 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.