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