今天接了一个小型网站,准备用 nhibernate 链接 access
配置文件:
<nhibernate>
<add
key="hibernate.show_sql"
value="true"
/>
<add
key="hibernate.connection.provider"
value="NHibernate.Connection.DriverConnectionProvider"
/>
<!-- SQL Server
<add
key="hibernate.dialect"
value="NHibernate.Dialect.MsSql2000Dialect"
/>
<add
key="hibernate.connection.driver_class"
value="NHibernate.Driver.SqlClientDriver"
/>
<add
key="hibernate.connection.connection_string"
value="Server=.;initial catalog=CquMstc;UID=sa;"
/>-->
<!-- Access -->
<!--<add
key="hibernate.dialect"
value="NHibernate.Dialect.GenericDialect"
/>-->
<add
key="hibernate.dialect"
value="NHibernate.Dialect.MsSql2000Dialect"
/>
<add
key="hibernate.connection.driver_class"
value="NHibernate.Driver.OleDbDriver"
/>
<!--
<add
key="hibernate.connection.connection_string"
value="Provider=Microsoft.Jet.OleDb.4.0;data source=E:/upload/guest/CqMsClub/bbs/_datastores/cqumstc.mdb"
/>-->
<add
key="hibernate.connection.connection_string"
value="Provider=Microsoft.Jet.OleDb.4.0;data source=F:/MyProject2005/CquMstc/WebUI/_datastores/cqumstc.mdb"
/>
</nhibernate>
链接成功,Load也顺利,但是Create的时候总是报错:FROM 子句语法错误,
用log4net,也不见输出 insert 语句,跟踪半天不晓得哪里出问题,估计是 Access不支持比较复杂的SQL,只好放弃,以后研究