I guess it is my understanding of fileDSN that is wrong then. I was
thinking that it was treating a file as a database. I thought the
representation of the DSN in ini file format was just for the sake of
transcribing the details for us to read. I know that with ODBC on
Linux it is done as an
a few years ago, before I learned Revolution, I did database
applications for Windows in hta/javascript. It used dsn-less connection
via ActiveX ADODB to a database where all tables were stored in plain
text files. It could use Access files as well.
For plain text databases it was necessary
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
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
Bernard, Perhaps I'm misunderstanding what a fileDSN is, but I don't
believe so. A DSN is a collection of connection parms used to connect
to an ODBC compliant data source. A System DSN and User DSN store that
information in the Windows Registry. A file DSN stores that information
in a
I would also be interested if this was possible - and even more so, if it was
possible to use a DSN-less connection for an ODBC database.
I distribute several apps for which I have to send people detailed
instructions on setting up a DSN; it would be far more convenient if I could
handle
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
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.