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