I am running LLBLGen Pro 5.5.1. How can I add this driver?

I am attempting to connect to an Azure Sql Database and add relational model data from a database.

jecraton wrote:

I am running LLBLGen Pro 5.5.1. How can I add this driver?

I am attempting to connect to an Azure Sql Database and add relational model data from a database.

SqlClient is part of .net framework which is part of windows, so it has to be there. What's the exact error you're getting? (and the stack trace). You're running the designer on windows 10 or 11 I presume?

There's no error. When I run the wizard, I do not see SQL Client in the Wizard dropdown. I see firebird, IBM DB2, Access, MySQL, Oracle, and PostGres. I do not see SqlClient in the dropdown.

I am running the designer on Windows 10.

Is this in a new empty project?

or are you trying to add a new relation model data to a project where one (SQL) has been added before?

Also what do you see in the application output log, it's a tab docked at the bottom of the designer. You don't have to start a sync, after you've started the designer, it should report an error there if it can't find the sqlclient

Here is the output from the application. I see the sql server driver in the application log, but it's not showing in the dropdown when I try to pull in a new database table.

Otis wrote:

Also what do you see in the application output log, it's a tab docked at the bottom of the designer. You don't have to start a sync, after you've started the designer, it should report an error there if it can't find the sqlclient

DatabaseDriverStore::Successfully loaded driver 'MS Access Driver (OleDb)' from 'C:\Program Files (x86)\Solutions Design\LLBLGen Pro v5.5\Drivers\Access\SD.LLBLGen.Pro.DBDrivers.AccessDBDriver.dll'
DatabaseDriverStore::Successfully loaded driver 'IBM DB2 UDB Driver (IBM DB2 .NET)' from 'C:\Program Files (x86)\Solutions Design\LLBLGen Pro v5.5\Drivers\DB2\SD.LLBLGen.Pro.DBDrivers.DB2DBDriver.dll'
DatabaseDriverStore::Successfully loaded driver 'Firebird Driver (Firebird.NET)' from 'C:\Program Files (x86)\Solutions Design\LLBLGen Pro v5.5\Drivers\Firebird\SD.LLBLGen.Pro.DBDrivers.FirebirdDBDriver.dll'
DatabaseDriverStore::Successfully loaded driver 'MySql Driver (MySQLDirect)' from 'C:\Program Files (x86)\Solutions Design\LLBLGen Pro v5.5\Drivers\MySql\SD.LLBLGen.Pro.DBDrivers.MySqlDBDriver.dll'
DatabaseDriverStore::Successfully loaded driver 'Oracle Driver (MS Oracle)' from 'C:\Program Files (x86)\Solutions Design\LLBLGen Pro v5.5\Drivers\OracleMSOracle\SD.LLBLGen.Pro.DBDrivers.OracleDBDriver_MSOracle.dll'
DatabaseDriverStore::Successfully loaded driver 'Oracle Driver (ODP.NET)' from 'C:\Program Files (x86)\Solutions Design\LLBLGen Pro v5.5\Drivers\OracleODPNET\SD.LLBLGen.Pro.DBDrivers.OracleDBDriver_ODPNET.dll'
DatabaseDriverStore::Successfully loaded driver 'PostgreSql Driver (Npgsql)' from 'C:\Program Files (x86)\Solutions Design\LLBLGen Pro v5.5\Drivers\PostgreSql\SD.LLBLGen.Pro.DBDrivers.PostgreSqlDBDriver.dll'
DatabaseDriverStore::Successfully loaded driver 'SQL Server Driver (SqlClient)' from 'C:\Program Files (x86)\Solutions Design\LLBLGen Pro v5.5\Drivers\SqlServer\SD.LLBLGen.Pro.DBDrivers.SqlServerDBDriver.dll'
TypeConverterLoader::Successfully instantiated type converter 'SD.LLBLGen.Pro.TypeConverters.BooleanNumericConverter' from assembly file 'C:\Program Files (x86)\Solutions Design\LLBLGen Pro v5.5\TypeConverters\SD.LLBLGen.Pro.TypeConverters.dll'.
TypeConverterLoader::Successfully instantiated type converter 'SD.LLBLGen.Pro.TypeConverters.BooleanCharYNConverter' from assembly file 'C:\Program Files (x86)\Solutions Design\LLBLGen Pro v5.5\TypeConverters\SD.LLBLGen.Pro.TypeConverters.dll'.
TypeConverterLoader::Successfully instantiated type converter 'SD.LLBLGen.Pro.TypeConverters.ByteDecimalConverter' from assembly file 'C:\Program Files (x86)\Solutions Design\LLBLGen Pro v5.5\TypeConverters\SD.LLBLGen.Pro.TypeConverters.dll'.
TypeConverterLoader::Successfully instantiated type converter 'SD.LLBLGen.Pro.TypeConverters.ByteArrayStringConverter' from assembly file 'C:\Program Files (x86)\Solutions Design\LLBLGen Pro v5.5\TypeConverters\SD.LLBLGen.Pro.TypeConverters.dll'.
TypeConverterLoader::Successfully instantiated type converter 'SD.LLBLGen.Pro.TypeConverters.CharStringConverter' from assembly file 'C:\Program Files (x86)\Solutions Design\LLBLGen Pro v5.5\TypeConverters\SD.LLBLGen.Pro.TypeConverters.dll'.
TypeConverterLoader::Successfully instantiated type converter 'SD.LLBLGen.Pro.TypeConverters.DateTimeBinaryConverter' from assembly file 'C:\Program Files (x86)\Solutions Design\LLBLGen Pro v5.5\TypeConverters\SD.LLBLGen.Pro.TypeConverters.dll'.
TypeConverterLoader::Successfully instantiated type converter 'SD.LLBLGen.Pro.TypeConverters.DateTimeDateTimeUTCConverter' from assembly file 'C:\Program Files (x86)\Solutions Design\LLBLGen Pro v5.5\TypeConverters\SD.LLBLGen.Pro.TypeConverters.dll'.
TypeConverterLoader::Successfully instantiated type converter 'SD.LLBLGen.Pro.TypeConverters.DateTimeInt64Converter' from assembly file 'C:\Program Files (x86)\Solutions Design\LLBLGen Pro v5.5\TypeConverters\SD.LLBLGen.Pro.TypeConverters.dll'.
TypeConverterLoader::Successfully instantiated type converter 'SD.LLBLGen.Pro.TypeConverters.DateTimeOffsetBinaryConverter' from assembly file 'C:\Program Files (x86)\Solutions Design\LLBLGen Pro v5.5\TypeConverters\SD.LLBLGen.Pro.TypeConverters.dll'.
TypeConverterLoader::Successfully instantiated type converter 'SD.LLBLGen.Pro.TypeConverters.DateTimeOffsetByteArrayConverter' from assembly file 'C:\Program Files (x86)\Solutions Design\LLBLGen Pro v5.5\TypeConverters\SD.LLBLGen.Pro.TypeConverters.dll'.
TypeConverterLoader::Successfully instantiated type converter 'SD.LLBLGen.Pro.TypeConverters.DateTimeOffsetStringConverter' from assembly file 'C:\Program Files (x86)\Solutions Design\LLBLGen Pro v5.5\TypeConverters\SD.LLBLGen.Pro.TypeConverters.dll'.
TypeConverterLoader::Successfully instantiated type converter 'SD.LLBLGen.Pro.TypeConverters.DateTimeStringConverter' from assembly file 'C:\Program Files (x86)\Solutions Design\LLBLGen Pro v5.5\TypeConverters\SD.LLBLGen.Pro.TypeConverters.dll'.
TypeConverterLoader::Successfully instantiated type converter 'SD.LLBLGen.Pro.TypeConverters.GuidByteArrayConverter' from assembly file 'C:\Program Files (x86)\Solutions Design\LLBLGen Pro v5.5\TypeConverters\SD.LLBLGen.Pro.TypeConverters.dll'.
TypeConverterLoader::Successfully instantiated type converter 'SD.LLBLGen.Pro.TypeConverters.GuidStringConverter' from assembly file 'C:\Program Files (x86)\Solutions Design\LLBLGen Pro v5.5\TypeConverters\SD.LLBLGen.Pro.TypeConverters.dll'.
TypeConverterLoader::Successfully instantiated type converter 'SD.LLBLGen.Pro.TypeConverters.DoubleDecimalConverter' from assembly file 'C:\Program Files (x86)\Solutions Design\LLBLGen Pro v5.5\TypeConverters\SD.LLBLGen.Pro.TypeConverters.dll'.
TypeConverterLoader::Successfully instantiated type converter 'SD.LLBLGen.Pro.TypeConverters.SingleDecimalConverter' from assembly file 'C:\Program Files (x86)\Solutions Design\LLBLGen Pro v5.5\TypeConverters\SD.LLBLGen.Pro.TypeConverters.dll'.
TypeConverterLoader::Successfully instantiated type converter 'SD.LLBLGen.Pro.TypeConverters.Int64DecimalConverter' from assembly file 'C:\Program Files (x86)\Solutions Design\LLBLGen Pro v5.5\TypeConverters\SD.LLBLGen.Pro.TypeConverters.dll'.
TypeConverterLoader::Successfully instantiated type converter 'SD.LLBLGen.Pro.TypeConverters.Int32DecimalConverter' from assembly file 'C:\Program Files (x86)\Solutions Design\LLBLGen Pro v5.5\TypeConverters\SD.LLBLGen.Pro.TypeConverters.dll'.
TypeConverterLoader::Successfully instantiated type converter 'SD.LLBLGen.Pro.TypeConverters.Int16DecimalConverter' from assembly file 'C:\Program Files (x86)\Solutions Design\LLBLGen Pro v5.5\TypeConverters\SD.LLBLGen.Pro.TypeConverters.dll'.
TypeConverterLoader::Successfully instantiated type converter 'SD.LLBLGen.Pro.TypeConverters.StringByteArrayConverter' from assembly file 'C:\Program Files (x86)\Solutions Design\LLBLGen Pro v5.5\TypeConverters\SD.LLBLGen.Pro.TypeConverters.dll'.
TypeConverterLoader::Successfully instantiated type converter 'SD.LLBLGen.Pro.TypeConverters.TimeSpanInt64Converter' from assembly file 'C:\Program Files (x86)\Solutions Design\LLBLGen Pro v5.5\TypeConverters\SD.LLBLGen.Pro.TypeConverters.dll'.
TypeConverterLoader::Successfully instantiated type converter 'SD.LLBLGen.Pro.TypeConverters.TimeSpanStringConverter' from assembly file 'C:\Program Files (x86)\Solutions Design\LLBLGen Pro v5.5\TypeConverters\SD.LLBLGen.Pro.TypeConverters.dll'.
PluginStore::Successfully loaded plug-in 'Add Custom Properties Plug-in' from assembly file 'C:\Program Files (x86)\Solutions Design\LLBLGen Pro v5.5\Plugins\SD.LLBLGen.Pro.Plugins.dll'.
PluginStore::Successfully loaded plug-in 'Plural to Singular converter plug-in' from assembly file 'C:\Program Files (x86)\Solutions Design\LLBLGen Pro v5.5\Plugins\SD.LLBLGen.Pro.Plugins.dll'.
PluginStore::Successfully loaded plug-in 'Singular to Plural converter plug-in' from assembly file 'C:\Program Files (x86)\Solutions Design\LLBLGen Pro v5.5\Plugins\SD.LLBLGen.Pro.Plugins.dll'.
PluginStore::Successfully loaded plug-in 'Project Inspector Plug-in' from assembly file 'C:\Program Files (x86)\Solutions Design\LLBLGen Pro v5.5\Plugins\SD.LLBLGen.Pro.Plugins.dll'.
ImporterStore::Successfully loaded importer plug-in 'LLBLGen Pro project importer' from assembly file 'C:\Program Files (x86)\Solutions Design\LLBLGen Pro v5.5\Plugins\SD.LLBLGen.Pro.Importers.dll'.
ImporterStore::Successfully loaded importer plug-in 'EntityFramework EDMX importer' from assembly file 'C:\Program Files (x86)\Solutions Design\LLBLGen Pro v5.5\Plugins\SD.LLBLGen.Pro.Importers.dll'.
System::Done
System::Initialization done. Ready.
Project File I/O::Project 'Gravitate' loaded successfully

I see the driver when I'm creating a new project, but not when I'm trying to bring in a new table for an existing project.

jecraton wrote:

I see the driver when I'm creating a new project, but not when I'm trying to bring in a new table for an existing project.

Ah, then it's understandable You already have a catalog with sqlclient in the project! So this is a matter of syncing with the database, so you should start a sync, see https://www.llblgen.com/Documentation/5.11/Designer/Functionality%20Reference/SyncTab.htm

Basically you open the sync tab, start the sync task and you get an overview of the relational model data in the database after the connection has been established. You then will be able to select new tables if you want.