Hi,

is there a way to access FoxPro with NHibernate?

Thanks for your help

antoschka

Hi,

I managed to connect to a foxpro database. Here re teh entries of my connection file:
<nhibernate>
<!--FOXPRO Connection-->
<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:\myDB.dbc;Collating Sequence=machine;"
/>
</nhibernate>

However, when trying to retrieve data I get an exception:
- Message "No row with the given identifier exists: , of class: ....Type"
- DeclaringType {Name = "UnresolvableObjectException" FullName = "NHibernate.UnresolvableObjectException"} System.Type {System.RuntimeType}

In table "Type" the primary key is defined as single column of type varchar

What could be the problem?

Thanks for your help antoschka