llblgen Pro v2.5
MySql 5.0
Adapter
C#.net 2005
Corelab MySql Version=4.25.22.0
llblgen designer can connect to the MySql but when i press the 'create' button i get the error below;
Fatal Exception caught in MySqlSchemaRetriever:: PopulateAllTableFields: Cannot find column [NON_UNIQUE].
Cannot find column [NON_UNIQUE].
Stack Trace of the error is;
-----[Core exception]--------------------
at SD.LLBLGen.Pro.DBDrivers.MySql.MySqlSchemaRetriever.PopulateAllTableFields(IDbConnection openConnection) in C:\Myprojects\VS.NET Projects\LLBLGen Pro v2.0\Drivers 2.5\MySql\MySqlSchemaRetriever.cs:line 340
at SD.LLBLGen.Pro.DBDrivers.MySql.MySqlSchemaRetriever.RetrieveSchema(String connectionString, IDBSchema schemaToRetrieve, SchemaFetchFlags fetchFlags) in C:\Myprojects\VS.NET Projects\LLBLGen Pro v2.0\Drivers 2.5\MySql\MySqlSchemaRetriever.cs:line 118
at SD.LLBLGen.Pro.DBDrivers.MySql.MySqlCatalogRetriever.RetrieveSchemas(String connectionString, IDBCatalog catalogToRetrieve, SchemaFetchFlags fetchFlags) in C:\Myprojects\VS.NET Projects\LLBLGen Pro v2.0\Drivers 2.5\MySql\MySqlCatalogRetriever.cs:line 71
at SD.LLBLGen.Pro.DBDrivers.MySql.MySqlDBDriver.PopulateSelectedCatalogs(Hashtable callBacks, Hashtable connectionElements, SchemaFetchFlags fetchFlags, Hashtable properties) in C:\Myprojects\VS.NET Projects\LLBLGen Pro v2.0\Drivers 2.5\MySql\MySqlDBDriver.cs:line 446
at SD.LLBLGen.Pro.Gui.Forms.NewProjectWizard.CreateNewProject()
-----[InnerException]--------------------
at System.Data.NameNode.Bind(DataTable table, List1 list)
at System.Data.BinaryNode.Bind(DataTable table, List
1 list)
at System.Data.BinaryNode.Bind(DataTable table, List`1 list)
at System.Data.DataExpression.Bind(DataTable table)
at System.Data.DataExpression..ctor(DataTable table, String expression, Type type)
at System.Data.DataView..ctor(DataTable table, String RowFilter, String Sort, DataViewRowState RowState)
at SD.LLBLGen.Pro.DBDrivers.MySql.MySqlSchemaRetriever.PopulateAllTableFields(IDbConnection openConnection) in C:\Myprojects\VS.NET Projects\LLBLGen Pro v2.0\Drivers 2.5\MySql\MySqlSchemaRetriever.cs:line 307
Source :
SD.LLBLGen.Pro.DBDrivers.MySqlDBDriver
System.Data
Driver Version of llblgen is: 2.5.03102008
I even tried it on a database with one table i get the error, i am adding the create statement of the database.
CREATE DATABASE llblgen_test
/*!40100 DEFAULT CHARACTER SET latin5 */;
DROP TABLE IF EXISTS llblgen_test
.acenta
;
CREATE TABLE llblgen_test
.acenta
(
acenta_kodu
decimal(4,0) NOT NULL,
org_firma_kodu
decimal(4,0) default NULL,
cari_kodu
varchar(20) default NULL,
acenta_adi
varchar(60) default NULL,
aciklama
varchar(512) default NULL,
durumu
char(1) default 'A',
PRIMARY KEY (acenta_kodu
),
KEY fk_acenta_acenta_ca_cari_kar
(org_firma_kodu
,cari_kodu
)
) ENGINE=InnoDB DEFAULT CHARSET=latin5;