> In other words, once you have your connect string working, just go for the > DBI documentation. Also, make sure your ODBC data source is set up as a > SYSTEM DSN. It won't work otherwise -- I'm not entirely sure why, but > there were posts on this group explaining that.
DBD::ODBC shouldn't absolutely require a system DSN, but that's usually better, especially if you are developing web applications as the "user" the web server logs in as will have access to the DSN. > > > Hi guys/gals, > > I need a tutorial or something on how to access Paradox > > databases with Perl, DBI and ODBC (I have the ODBC connection > setup and it > > works). The files I have are .db files, and I guess I need to > know, can I > > just run ANSI SQL statements against it? Is there special quirks with > > Paradox? Stuff like that. Can someone please point me in the right > > direction? Yes, there are "quirks" with Paradox (and all dbs, for that matter), but probably none that you're not already aware of. Table names are the file names, as I recall, etc. Refer to your Paradox ODBC guide for some more information, but I suggest just trying it. I think the ODBC DSN has to point to the directory where the tables reside. I haven't used paradox in 5 years or so. My information may be outdated. Regards, Jeff