Hello All:
First of all sorry for the long title. As for my question:
I have been assigned to write a VB6 interface that opens .dat files and applies SQL logic to them which then returns the result as an XML.
Now, the trouble I am having is:
EVERYONE TALKS ABOUT PERVASIVE.SQL V8!!!
I cannot (am not allowed) to ask the ppl to upgrade to pervasive. End of story. No funds is the reason I am given. Trouble is, either I make this interface or I get fired! (so no pressure at all :?)
What have I been able to do so far?
I used Pervasive's ActiveX in VB6 to open the dat files with the DDF. Then I can view them no trouble as well. But that's where I get stuck! It asks to connect to a database (there is none!)
I searched all over and found a software called, "Betrieve Database Desktop" by Yanis Kregers. It does EXACTLY what I need it to do, minus the few quarks and export functionality. Trouble is, it was written in Delphi and it doesn't export to anywhere! But it does open dat files and it does apply SQL logic to them. So obviously, it is possible (or so my boss keeps pointing to me)
I am assigning 5000 points to this question. (no joke! I will assign 500 now (max), then open up a few questions for the accepted answer person to reply and get points to upto 5000! don't worry it's allowed as long as the questions I ask are helping the community.)
Please respond as soon as possible!
TIA!
P.S. Another way I have tried approaching is attempting to convert the .dat files into .mdb files. If you can do that, you will also get the points. I have already built a similar program for .mdb files, so that won't be any trouble.
Start Free Trial
