Re: PHP front to mySQL database

From: Dave Darden (qwanfoo_at_yahoo.com)
Date: 03/10/04 

Date: Wed, 10 Mar 2004 12:46:08 -0700

You should be able to set up MySQL to respond via ODBC to calls from VB.
You will need the MySQL ODBC driver and set up a data set name (DSN) on each of
the Microsoft clients that access the data.

Personally I swore off programming in Access. It was messy, buggy, and slow
compared to VB.
You can use the Access database format directly from VB with several data access
protocols (DAO, ADO, etc.) without an Access license.
Set up the database file table structure in Access and call it from VB.
As I recall, Microsoft calls the VB / Access database the Jet database engine.
The VB syntax is very similar using either VB or Access.

I also prefer to use the web browser as the client interface instead of VB.
That way I don't have to worry about VB installation and update headaches and
various assorted conflicting dll issues ON EACH CLIENT.
It is also easier to secure the database and set variable security levels for
portions of the application through the web server and php.

It is such fun when a client installs your VB application with the latest shared
dll's and it breaks some old application of theirs that needed the old dll
version.
I have read that with MS "dot net" dll's can be statically linked these days and
not shared dynamically in a VB application.
That should help get rid of the dll hell problem that historically made VB such
an installation pain.
But why mess with client installation at all?
And why work with a difficult security model?
Linux / Apache / MySQL / PHP is the way to go for shared database applications.
If they need to use the data in Excel or Access then just add a data export
routine.

Dave Darden
www.dardensystems.com

"Stuart Mueller" <I.Dont.Have@email.address> wrote in message
news:404eef75_1@mk-nntp-2.news.uk.tiscali.com...
> I am creating a database for someone, to hold information on their clients,
> such as client addresses, contact details etc. it won't be webbased as it's
> just for their in-house use.
>
> At the moment they have one done in access, but they would like it redoing.
> I was thinking I could either do it in access again, and use a VB front end.
> But I would prefer to have a go with mySQL.
>
> If I were to do it in mySQL would I need a PHP front end, and if so that
> would mean installing a webserver wouldn't it?
>
> Stu
>
>
> --
> "I'll rob that rich person and give it to some poor deserving slob.
> That will *prove* I'm Robin Hood."
> -- Daffy Duck, "Robin Hood Daffy", [1958, Chuck Jones]
>
>

Relevant Pages

  • Re: toolkits or APIs to create a web interface as a frontend to mysql
    ... I am also *not* looking for a web based full fledged mysql client. ... For simple display of tabulated data the most useful thing is a displaywhich uses 's with absolute coordinates to position text in a box of defined width, formatted to be left, right or center justified, an using a preselected style from a a style sheet. ... As far as the actual database calls go, those are specific to each form, and apart from a little coding so that 'database_open, database_close' exist in the library, taking such things as the database name, user name and password from an included file I find it easiest to simply do the query and iterate through it to display the data requested. ...
    (comp.os.linux.misc)
  • Re: Confusion about database updates
    ... all connecting to the same database server. ... MySQL can easily handle many simultaneous clients. ... AlphaCluster all open multiple connections to a MySQL server running on ... Let the MySQL server do that when your client ...
    (comp.lang.java.databases)
  • Re: Base Pair Patterns Database
    ... There is a MySQL database open to the Internet public, ... ODBC client driverfirst, depending on what client software you ... This new server allows MySQL access to the same set of data ...
    (talk.origins)
  • Re: [PHP] Re: Getting last record ID created from DB
    ... increment auto id fields (e.g. they could fill in the blanks from ... My own knowledge of mysql is about 5 years old and never really used. ... transferrable to other database engines. ... Each client will receive the ...
    (php.general)
  • Re: Sql Server express 2005 deployment
    ... From your answer I infer that the client ... having to restore the database or do anything manually on the clients ... To make an installation package use the build in setup ... SQL Server 2005 installed on their end for this to work. ...
    (microsoft.public.dotnet.languages.csharp)