Hi Michael, Yes, I'm using MySQL on the on-rev server.
I can access it fine from an irev script. I need to access it remotely from a stack. Rick On Feb 15, 2010, at 1:40 PM, Michael Kann wrote: > Rick, > > Are you using MySQL on the on-rev server? > > --- On Mon, 2/15/10, Rick Harrison <harri...@all-auctions.com> wrote: > >> From: Rick Harrison <harri...@all-auctions.com> >> Subject: Re: Connecting Stack to Remote On-Rev MySQL Database >> To: "How to use Revolution" <use-revolution@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, runrev260...@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 <harri...@all-auctions.com> >>> To: runrev260...@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@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@lists.runrev.com >>> >>> >>> _______________________________________________ >>> use-revolution mailing list >>> use-revolution@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@lists.runrev.com >> Please visit this url to subscribe, unsubscribe and manage >> your subscription preferences: >> http://lists.runrev.com/mailman/listinfo/use-revolution >> > > > > _______________________________________________ > use-revolution mailing list > use-revolution@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
