Hi Gang,

I have a potential client with the following needs:

Create a custom .NET invoicing program (entry/edit/printing, etc.) that will send summary batch information to their existing accounting system. Sounds like gravy, but you know there just has to be a hair in that gravy: the accounting system backend is Pervasive.SQL (good ole [read old] BTrieve). I can use MSDE for the backend of the .NET program where my custom detailed invoices will reside, but I have to pull out of and update the Pervasive.SQL side with summary invoice data as well as the last used invoice numbers, customer information, etc.

I know the accounting system currently relies upon ODBC connections to the Pervasive.SQL databases. I have used some utilities and can usually only see the data in hex format from the tables.

Can I setup Pervasive.SQL as a linked server and use it's OLE DB provider to make the changes I want ???

Any advice would help, I'm sure somebody has been down this road before.

Thanks in advance !!!

Best Regards,
Jace