Re-2: Connecting Stack to Remote On-Rev MySQL Database

[runrev260805 at m-r-d.de]

-------- Original Message --------
Subject: Re: Connecting Stack to Remote On-Rev MySQL Database (15-Feb-2010 18:23)
From:    Rick Harrison <harrison at all-auctions.com>
To:      runrev260805 at 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, 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
> 
> 
> 
> 
> To: use-revolution at lists.runrev.com