I have read that msdn post and it did clear up some problems. But my main question is should there be a ORDINAL_POSITION in my Pervasive table that I'm trying to export. When I run the system stored procedure in pervasive to see the metadata there does not seem to be a ORDINAL_POSITION field. Is it there and I cannot see it?
I cannot upgrade because the Pervasive V9 is tied into my accounting system, and I would have to upgrade the accounting system to upgrade to v11.
No, ORDINAL_POSITION should not be a field in your database. It's a property of the ODBC metadata and should be returned as part of the System.Data.ODBC DBConnection.GetSchema call from within the Import Export Tool.
You can use ODBC Test or C#/VB.NET to simulate what the Tool is doing. In ODBC Test, you would issue a SQLColumns call. On my test system running v11, I see an ORDINAL_POSITION data returned by that call. You could also make a call to GetSchema from a C# / VB.NET program pointing to your table.
If ORDINAL_POSITION is not there, you'll need to talk to Microsoft about fixing their tool to work when ORDINAL_POSITION isn't available. EIther that or you'll need to look at other options.
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.