SQL Access with Rev CGI

Bridger Maxwell bridgeyman at gmail.com
Mon Aug 6 21:53:28 EDT 2007

Hey,  Again, somehow asking the question allows me to see the answer.  Funny
how that happens.  I thought I would share what works, in case someone else
runs into the same problem.  First of all, my Linux CGI engine is version
2.6.6, which I got off of the runrev ftp site.  The mysql driver I am using
is from the 2.6.1 distribution of Revolution found in the installation
folder /components/global environment/database_drivers/Linux/dbmysql.so.
 This driver is about 32 kb, in case you would like to check it against the
driver you have.
  Although I played around with different engine and driver versions, this
was not my main problem.  The problem was due to a simple, yet undocumented
(as far as I could find) quirk.  When using the revOpenDatabase() function,
if the database type is spelled "mySQL" then the database driver name must
be "dbmySQL.so", including the correct case.  That is where I was caught.

    Bridger Maxwell

On 8/6/07, Bridger Maxwell <bridgeyman at gmail.com> wrote:
> Hey,
>   I have just got a Rev CGI set up on my Dreamhost server, and I would
> like it to access my SQL database.  I have been searching around the list
> archive, and it seems like it is possible, but I  can't figure it out.  Is
> there a driver I need to download?  Where can I get that driver?  Whenever I
> execute revdb_connect, it returns "revdberr,invalid database type."  I am
> running the linux engine version 2.6.6.
>   TTFN
>     Bridger Maxwell

More information about the use-livecode mailing list