Connecting Stack to Remote On-Rev MySQL Database
runrev260805 at m-r-d.de
runrev260805 at m-r-d.de
Sun Feb 14 16:58:25 EST 2010
Rick,
first of all you have to enable Remote Access for your database. You can do that in cPanel ->Databases->RemoteDatabase Access Hosts. If the computer, which runs the stack, does not have a static internet ip, then you have to enter %.%.%.% as ip-adress in Access Hosts.
At http://samples.on-rev.com/database.irev you find a code example how to access an MySQL database. It is an irev example, but the sections
#Open the database connection
#Construct the SQL Statement
#Close the database connection
can also be used in an stack.
Hth,
Matthias
-------- Original Message --------
Subject: Connecting Stack to Remote On-Rev MySQL Database (14-Feb-2010 22:29)
From: Rick Harrison <harrison at all-auctions.com>
To: runrev260805 at m-r-d.de
> Hi there,
>
> I've been all through the archives, and found
> some hints that it is possible to connect to
> a remote MySQL database on On-Rev.
>
> Doe anyone have a clear step by step
> example of how this is done?
>
> I don't have time to keep struggling with this
> problem. I need a solution A.S.A.P.
>
> Any help is greatly appreciated!
>
> Thanks,
>
> Rick
> _______________________________________________
> 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
>
>
>
>
> To: use-revolution at lists.runrev.com
More information about the use-livecode
mailing list