I'm devastated and really need your help. I have to connect to a FoxPro database. I use the FoxPro-oledb driver and the following connection settings.
<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.Dialect.GenericDialect, NHibernate"
/>
<add
key="hibernate.connection.driver_class"
value="NHibernate.Driver.OleDbDriver, NHibernate"
/>
<add
key="hibernate.connection.connection_string"
value="Provider=vfpoledb.1;Data Source=C:\Dokumente und Einstellungen\All Users\Dokumente\Visual Studio 2005\FoxProDataBase\MasterData_User.DBC; Collating Sequence=machine;"
/>
<add
key="hibernate.show_sql"
value="true"
/>
</nhibernate>
As dialect I also tried MSSQL2000Dialect and one which I have ported from Hibernate which is designed for FoxPro. All of the work well as long as I read and update data. Inserting data (insert into) works with none of them. Now I have no further idea what to do. Does anybody have an hint or idea how I can fully connect to the FoxPro Tables. If I do not get that to work, I'm in deep trouble. Can anybody help me please!!!!
Login
FAQ
Search
