June 19, 2007 at 4:46 am
Howdy
I was wondering if anyone had experience with Clipper.
Specifically importing data to SQL and exporting data from SQL to Clipper.
I couldn't find much on Clipper, looks like it is almost 25 years old.
Any help would be lovely.
Thanks
June 19, 2007 at 5:01 am
Cannot say I have but if Clipper supports ODBC, a quick search on google says it has drivers, then you should not have any problems getting data out.
You problems will come in when you try put data back in as SSIS does not support ODBC destinations. You would have to use a Script component and write the code to insert the rows. A pain.
Alternatively, assuming it has ODBC, use a linked server(?).
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
June 19, 2007 at 7:23 am
Thanks!
Turns out the database itself is Advantage.
How about that one? Anyone heard of that?
Geesh. Where do people get this stuff?
June 19, 2007 at 7:26 am
it would appear that to has ODBC drivers.
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
June 19, 2007 at 8:20 am
Interesting.
BTW, Clipper uses dBase format, so you can use those drivers.
June 20, 2007 at 7:32 am
Clipper, all versions use the the DB3 file format, which is the same as the DB2 format. It came from when when we had to build all of the neat stuff that we take for granted in db server software nowadays, like checking and rebuilding indexes .........
John.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply