Connecting Stack to Remote On-Rev MySQL Database

[runrev260805 at m-r-d.de]

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