Doug:

Any quick tips on the NO-NOs of talking to ACCPAC? I corrupted a record within 10 minutes yesterday. Is there an updated ODBC driver (I'm using 7.51.160.00)? Or maybe I should avoid INSERT INTO and stick with APPEND BLANK?

I don't want accounting unhappy with me...

Brian


>Hi Brian.
>
>>Anyone ever pulled data from a Pervasive backend running on a Novell server? (It's an ACCPAC database.)
>>
>>Do you happen to have an example of how to establish a connection?
>
>Yup, I do that all the time (specifically with ACCPAC, as a matter of fact). You need to ensure the Pervasive ODBC driver is installed on the workstation, plus (and this is kind of weird) you need to create an ODBC datasource with that driver and "create" the ACCPAC database. You're not really creating the database as you and I would know it, but you're registering it with the local Pervasive engine.
>
>After that, it's a piece of cake. You can create remote views against the ODBC datasource or use SQLCONNECT/SQLSTRINGCONNECT() to connect to the database and use SQLEXEC() to get or change data.
>
>Doug