Hi there
I was trying to figure this problem for long time but no success.
I could make NHibernate 2.0 interact with an existing simple Ms-Access DB
But when it comes to generate the schema for it using the hbm2ddl, I get in a problem that i don't understand.
Here is the log from log4net:
Code:
2009-01-18 00:14:17,625 DEBUG create table NHBM.User (LogonId INT !!! REPLACE THE PRECEEDING 'INT' AND THIS PLACEHOLDER WITH 'COUNTER' !!!, Name TEXT($1) null, [Password] TEXT($1) null, EmailAddress TEXT($1) null, LastLogon DATETIME null, primary key (LogonId))
2009-01-18 00:14:17,625 WARN Unsuccessful: create table NHBM.User (LogonId INT !!! REPLACE THE PRECEEDING 'INT' AND THIS PLACEHOLDER WITH 'COUNTER' !!!, Name TEXT($1) null, [Password] TEXT($1) null, EmailAddress TEXT($1) null, LastLogon DATETIME null, primary key (LogonId))
2009-01-18 00:14:17,625 WARN Syntax error in field definition.
2009-01-18 00:14:17,625 ERROR Syntax error in field definition.
System.Data.OleDb.OleDbException: Syntax error in field definition.
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
But when i take the generated script and run it myself in another app, it works fjust fine
Do you have any idea?
Thx