Anyone ever connected to a "PIC" database?

[Lawson]

I have to get & update data from two databases. One is Oracle - no problem. How about "Pick"? From what I can gather, this is old & is not ODBC compliant.

Can I connect using RDO w/o ODBC or DSN?

Thanks for any info.

-Lawson

[Edited by Lawson on 12-06-2000 at 12:32 PM]

[crispin]

I have some colleagues in another office who use PIC and Delphi together, I believe they use ODBC; i'll find out for you and post the results, (might not be till tomorrow though, it's getting late in England...)

[Lawson]

Thanks Crispin. I'll be watching.

-Lawson

[crispin]

Yes Lawson they use ODBC:

First you have to "un3D" the PIC database i.e. remove the temporal aspects of it by turning it into a flat structure (im finding out some more about that tomorrow)

Then you can connect to it via ODBC, and I have some drivers coming tomorrow for that, i'll send those on to you.

[Lawson]

Once again -Thank you Crispin.

..and looking forward to more info.

-Lawson