Connecting Stack to Remote On-Rev MySQL Database

[Rick Harrison]

Hi Matthias,

I've already seen http://samples.on-rev.com/database.irev which only shows
how to open a local MySQL database not a remote one.

I am specifically looking for code examples, not the basics.

The information you provided about %.%.%.% as an ip-address was helpful,
and I thank you for that!

Rick



On Feb 14, 2010, at 4:58 PM, runrev260805 at m-r-d.de wrote:

> 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
> 
> 
> _______________________________________________
> 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

__________________________________
Rick Harrison

You can buy my $10 music album "Funny Time Machine" digital CD on the iTunes Store Now!

To visit the iTunes Store now to listen to samples of my CD please click on the
following link.  (Please note you must have iTunes installed on your computer for this link to work.)  

http://phobos.apple.com/WebObjects/MZStore.woa/wa/viewAlbum?playListId=213668290