Connecting Stack to Remote On-Rev MySQL Database

[Michael Kann]

Rick, 

Are you using MySQL on the on-rev server?

--- On Mon, 2/15/10, Rick Harrison <harrison at all-auctions.com> wrote:

> From: Rick Harrison <harrison at all-auctions.com>
> Subject: Re: Connecting Stack to Remote On-Rev MySQL Database
> To: "How to use Revolution" <use-revolution at lists.runrev.com>
> Date: Monday, February 15, 2010, 11:19 AM
> 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
> 
> 
> _______________________________________________
> 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
>