Hi,

I am evaluating the LLBGen for the purpose of generating the data model source code against the syabase database.

After creating the LLBGen project using the LLBGen Pro v4.0 tool and I tried the option "Add Relational Model Data from a database" to add the data model from the datbase that prompted me with the wizard, where I selected the Sybase ASE Driver (ASE client) from the Database driver list and provided the connection details like server name, port, user/password.

When I clicked next, i get the test failed with the below error message:

Exception information.

LLBLGen Pro version: v4.0. Build: May 15th, 2013

Exception details:

Message: Unable to find the requested .Net Framework Data Provider. It may not be installed. Source: System.Data Stack trace: at System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName) at SD.LLBLGen.Pro.DBDriverCore.DBDriverBase.GetDbProviderFactory() at SD.LLBLGen.Pro.DBDriverCore.DBDriverBase.CreateConnection() at SD.LLBLGen.Pro.Gui.Controls.WizardPages.MetaDataRetrievalWizard_Step_ConnectionData.TestConnectionData(Boolean showSuccess)

Inner exception: <null>

I would like to know the LLB support for Sybase ASE 15.x. I have the ADO.NET driver (Sybase.AdoNet2.AseClient.dll version 4.157.401.0) and I am wondering how to use it in the place of some default sybase driver that LLBGen uses it.

Appreciate your comments on this issue.

Nazim

It's likely LLBLGen can't find the appropriate provider. LLBLGen works with DbProviderFactory, so if the provider is installed properly, it should work.

• In your machine config, is the Sybase DBProviderFactory installed? You can check at C:\Windows\Microsoft.NET\Framework\v2.0.50727\CONFIG C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config

• Are you running the default LLBLGen pro exe (LLBLGenPro.exe)? Please try to run the LLBLGenPro_x86.exe one.

daelmo wrote:

It's likely LLBLGen can't find the appropriate provider. LLBLGen works with DbProviderFactory, so if the provider is installed properly, it should work.

• In your machine config, is the Sybase DBProviderFactory installed? You can check at C:\Windows\Microsoft.NET\Framework\v2.0.50727\CONFIG C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config

• Are you running the default LLBLGen pro exe (LLBLGenPro.exe)? Please try to run the LLBLGenPro_x86.exe one.

I added the entry for the Sybase ASE 15.x driver details in the DbFactory section of the LLBLGenPro_x86.exe.config file. But it still doesn't work.

Do I need to use specific name to the DbFactory that the LLBGenPro expects? Please let me know.

Thanks,

Nazim

nazeem.khan wrote:

I added the entry for the Sybase ASE 15.x driver details in the DbFactory section of the LLBLGenPro_x86.exe.config file. But it still doesn't work.

Did you try with LLBLGenPro.exe.config?

I think the provider factory should look like: What about the LLBLGen

<system.data>
     <DbProviderFactories>
       <add name="SybaseAseClient Data Provider" invariant="Sybase.Data.AseClient" description=".Net Framework Data Provider for Sybase Ase" type="Sybase.Data.AseClient, Version=4.157.401.0, Culture=neutral, PublicKeyToken=26e0f1529304f4a7" />
     </DbProviderFactories>
   </system.data>

Although, I don't think you need to do that if the client is properly installed. I would check your installation again.

You have to add it to the machine.config file of .net 4, but indeed, if you have installed the .NET client for ASE, this should be done for you.