-------- Original Message -------- Subject: Re: Connecting Stack to Remote On-Rev MySQL Database (15-Feb-2010 18:23) From: Rick Harrison <harri...@all-auctions.com> To: runrev260...@m-r-d.de
> 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. But if you replace in the example - "localhost" with your on-rev domain - "bentest_people" with the name of your MySQLDB - "bentest_samples" with the username of your DB - "samples09" with the password of the user of your DB then you can remote connect to your db. > I am specifically looking for code examples, not the basics. What do you mean with code examples? Do you want to know how to create/update or delete records, how to do a select or what? There is no difference, if you connect locally or remote. Regards, Matthias > > 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 > > > > > 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