ODBC - Can use file DSN in Rev?

[Bernard Devlin]

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 <spepper at 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 at 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 at 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>