Scott, are you sure you want a fileDSN? The issue in the forum thread you refer to is about connecting to Access i.e. connecting to a database as a local file, not a database server.
The person who had the problem in that initial thread then posts a subsequent thread where he talks about connecting using a system DSN using a UNC path. Again, this is probably Access-specific. Unless you are talking about a situation where you are going to be installing DB2 on every user's local PC, I don't think you mean a fileDSN. In fact, I would say that a fileDSN is a distinctly unusual way to use ODBC. Bernard On Mon, May 18, 2009 at 4:16 PM, Scott Pepperdine <spep...@byu.net> wrote: > Thanks Victoras, > > The data is in a DB2 database, as are a number of stored procedures I need > to call, so ODBC still seems like the best fit. I'm also a little cautious > when it comes to SQLite when the database is reaching the many millions of > records size. I know SQLite proponents will swear by it for large data > sets, but I haven't had time to trial this. > > So the question is still 'Will Revolution use fileDSN' configuration to > access databases using ODBC? > > Thank, > --Scott > > viktoras d. wrote: >> >> Hi Scott, >> >> The simplest way is using SQLite files, then you even do not need ODBC, >> and this will be 100% crossplatform and works "out of the box". >> >> Best regards >> Viktoras >> >> Scott Pepperdine wrote: >>> >>> Hi, >>> >>> Will Revolution work with a FileDSN to make an ODBC connection to a >>> database? I've tried a little without success. I found some entries in the >>> Rev forums that concluded that it was broken >>> (http://forums.runrev.com/phpBB2/viewtopic.php?t=2382) and they were going >>> to submit a bug report. But I could not locate this report in the QCC. >>> >>> I'd like to make my app self-contained and avoid making the user >>> configure a DSN, or make registry entries to be able to connect to a remote >>> database. >>> >>> Any knowledge out there on this subject? >>> >>> Thanks, >>> --Scott >>> _______________________________________________ >>> use-revolution mailing list >>> use-revolution@lists.runrev.com >>> Please visit this url to subscribe, unsubscribe and manage your >>> subscription preferences: >>> http://lists.runrev.com/mailman/listinfo/use-revolution >>> >> >> _______________________________________________ >> use-revolution mailing list >> use-revolution@lists.runrev.com >> Please visit this url to subscribe, unsubscribe and manage your >> subscription preferences: >> http://lists.runrev.com/mailman/listinfo/use-revolution >> > _______________________________________________ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
