I tried a mapping of one single table on different Databases. The key column is suppused to be of generator class="guid".
With MS SQL I do not have any problems. Using the OLE DB driver for FoxPro it throws an exception telling me that the column will not accept null values.
No changes in coding - I just mapped in app.config to a different database.
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
<section
name="nhibernate"
type="System.Configuration.NameValueSectionHandler, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
/>
</configSections>
<!--MS SQL Connection-->
<connectionStrings>
<add name="DOCexpert.Anwenderstammdaten.Explorer.Properties.Settings.ForDBConnectionTestConnectionString"
connectionString="Data Source=TORSTEN\SQLEXPRESS;Initial Catalog=ForDBConnectionTest;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
<nhibernate>
<add
key="hibernate.connection.provider"
value="NHibernate.Connection.DriverConnectionProvider"
/>
<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=.\SQLEXPRESS;initial catalog=ForDBConnectionTest;Integrated Security=SSPI"
/>
</nhibernate>
<!--FOXPRO Connection-->
<!--<connectionStrings>
<add name="DOCexpert.Anwenderstammdaten.Explorer.Properties.Settings.ForDBConnectionTestConnectionString"
connectionString="Provider=vfpoledb.1;Data Source=C:\Dokumente und Einstellungen\All Users\Dokumente\Visual FoxPro Projects\ForDBConnectionTest.dbc;Collating Sequence=machine;"
providerName="System.Data.OleDb"/>
</connectionStrings>
<nhibernate>
<add
key="hibernate.connection.provider"
value="NHibernate.Connection.DriverConnectionProvider"
/>
<add
key="hibernate.dialect"
value="NHibernate.JetDriver.JetDialect, NHibernate.JetDriver"
/>
<add
key="hibernate.connection.driver_class"
value="NHibernate.JetDriver.JetDriver, NHibernate.JetDriver"
/>
<add
key="hibernate.connection.connection_string"
value=" Provider=vfpoledb.1;Data Source=C:\Dokumente und Einstellungen\All Users\Dokumente\Visual FoxPro Projects\ForDBConnectionTest.dbc; Collating Sequence=machine;"
/>
</nhibernate>-->
<!--value="Provider=vfpoledb.1;Data Source=C:\Dokumente und Einstellungen\All Users\Dokumente\Visual FoxPro Projects\Anwenderstammdaten\AnwenderstammdatenV2.dbc;Collating Sequence=machine;"-->
</configuration>
What could cause the problem? Any idea how to make work around so I can run that also on foxpro?
Login
FAQ
Search
