Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General Discussion » View Thread |
Messages 1 to 2 of 2 total |
Best Approach for connecting different databases |
Sat, Jun 16 2007 11:02 AM | Permanent Link |
Paul Baumann | i wanna buld an application for finding an eleminating duplicate (fuzzy search) records, like it can be
in adress databases. this should support as much file formats/databases as possible. but i think target group will be the desktop user, not the oracle database administrator. but i dont know cause - in newer times i am often asked about ms-sql support or mysql in my apps. (no need for levate to hassle, i stay true to my beloved DBISAM) my first idea was to work with odbc, but for me seems this to be to much complicated for most users. the question is: do they have a odbc driver for their database and will this driver support all the features i need for my job. you know, some cant read booleans or not more than 100 chars of a blob or what else. my second idea was to work with the jet engine (DAO). But i hvae no experineces with that. So i dont know if it is stable, are there release conflicts or what ever. How much diffculties for endusers to choose the right setup. You know - is there is something that does not work, it is always the fault of your programm. At least i thought about importing the data, working internally with DBISAM and then export again. But this has to 2 disadvantages: not much formats are supported for import and the action is not done on the source, so the user has to import the "cleaned" data again in his application. Perhabs he isnt able to that. I know in most circustances it is not the best way to work on source file. But this programmers know, endusers not. And my maxime is the user is always right. (not in all cases) what do you think is the best way? thank you and greetings from germany |
Tue, Jun 19 2007 8:10 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Paul,
<< what do you think is the best way? >> IMO, the best way to handle this would be via ODBC or ADO. That's about the most reliable way to get at multiple databases via a Win32 application. Most ODBC drivers are pretty mature at this point, and so they'll be the most reliable (hopefully . -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Wednesday, April 24, 2024 at 11:07 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |