That is a thought - use the OleDb rather than SQL, however you pay a bit of a performance penalty - might be best to code the SQL to be "cross-platform" and call into 2 different data access classes instead - one coded for SQL, one for Access.
Besides, you go the OleDb route only to get 99% of the way there and find you can't get the last 1% to work, so have to revert back - I hate that situation. Cheers, Dino -----Original Message----- From: The DOTNET list will be retired 7/1/02 [mailto:[EMAIL PROTECTED]] On Behalf Of Brad Wilson Sent: Friday, 7 June 2002 10:01 To: [EMAIL PROTECTED] Subject: Re: [DOTNET] Using DataSets as an IMDB Dean Cleaver wrote: > Means I have to have 2 different database access methods, although I > guess that's not so bad now - have to get out of the COM mindset and > think assemblies... If you use the OleDb* family of classes and limit yourself to the lowest common denominator, it's just one set of code (controlled by an external connection string). That's not always possible (or even feasable), so yeah, drop in data layers would be the next best thing. The primary problem you fight with XML is that it's not a database, no matter how much its advocates wish is were. ;) XPath is nice, but if you have lots of data, it's just not smart to load up a DOM just to search. Even Access is going to beat that kind of thing black-and-blue. Good luck. :) Brad -- Read my web log at http://www.quality.nu/dotnetguy/ You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com. --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.370 / Virus Database: 205 - Release Date: 05/06/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.370 / Virus Database: 205 - Release Date: 05/06/2002 You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
