Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Patrick C
  Where is Patrick C?
 St. Michael
 Barbados
 Patrick C
 To: anand kulkarni
  Where is anand kulkarni?
 sholapur
 India
 anand kulkarni
 Tags
Subject: RE: MySQL distribution
Thread ID: 392689 Message ID: 393715 # Views: 37 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Sunday, December 22, 2013 5:21:49 PM         
   


> > Hi All,
> >
> > This is my first MySQL app. When distributing a vfp app which uses a MySQL backend, what procedures do I need to follow or what are the steps involved in distributing an app with a MySQL database? Essentially, what I need to know is:
> >
> > what files are needed on the workstations for seamless database operations
> > What files are needed on the 'server' for easy workstation access
> > What specific drivers are needed on both 'server' and workstation
> >
> > I quoted 'server' since I'm using Windows 7 machine as server
> >
> > Thanks and Regards,
> >
> > Patrick
> Hi Patrick
>
> Install mysql at server side (mysql server ) .
> Install mysql odbc connectors at client side
> If you need the gui query browser you may install it at client side .
>
> p.N.= When you install Mysql at server side . Restore your application schema ( datbase) . Create user assign user rights and enjoy .
>
> regards
> Anand S. Kulkarni
>
> When it rains ... all Birds occupy shelter , but Eagle is the only bird with its capacity to fly over the sky to avoid rains !!!
> https://www.facebook.com/pages/Ask-Software-Consultant-Solapur/163446803786335?ref=stream



Thank you Anand. Could you clarify "Create user assign user rights" for me? I share a connection string with each workstation.

Regards,

Patrick

ENTIRE THREAD

MySQL distribution Posted by Patrick Cadogan @ 12/10/2013 10:07:51 PM
RE: MySQL distribution Posted by anand kulkarni @ 12/11/2013 5:49:25 AM
RE: MySQL distribution Posted by Patrick Cadogan @ 12/22/2013 5:21:49 PM
RE: MySQL distribution Posted by David Mustakim @ 12/11/2013 6:20:01 AM
RE: MySQL distribution Posted by Patrick Cadogan @ 12/22/2013 5:33:55 PM
RE: MySQL distribution Posted by Patrick Cadogan @ 12/23/2013 3:35:50 PM
RE: MySQL distribution Posted by David Mustakim @ 12/23/2013 3:42:50 PM