SQL Access with Rev CGI
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.
On 8/6/07, Bridger Maxwell <bridgeyman at gmail.com> wrote:
> 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.
> Bridger Maxwell
More information about the use-livecode