Frontend Dilema

2001-01-18 Thread Richard Reina
I run a small business. A year and a half ago I embarked on a jorney to port my DOS Foxpro Database to linux. I selected mysql as an the engine and and begand writing the app. using perl/dbi and perlmenu module/curses as the front end at first I used NFS to share the databse files on the LAN.

Re: Frontend Dilema

2001-01-18 Thread Jeremy D. Zawodny
On Wed, Jan 17, 2001 at 03:17:52PM -0600, Richard Reina wrote: I run a small business. A year and a half ago I embarked on a jorney to port my DOS Foxpro Database to linux. I selected mysql as an the engine and and begand writing the app. using perl/dbi and perlmenu module/curses as the

Re: Frontend Dilema

2001-01-18 Thread Richard Reina
Thanks for the reply. Curses worked OK. But I was convinced that a web server would be more efficient than NFS for sharing the database files. Is that true? Or is a NFS a longtime viable solution for clients on the LAN quering the database. Richard "Jeremy D. Zawodny" wrote: On Wed, Jan

RE: Frontend Dilema

2001-01-18 Thread Scott Gerhardt
You can connect to the DB on Linux using ODBC over any TCP/IP network, and you don't need to worry about NFS, File sharing, Samba etc. All you need is MySQL on Linux connected to your network and ODBC will connect on port 3306 over TCP/IP, that's all you need. A system built this way can use many

Re: Frontend Dilema

2001-01-18 Thread Jeremy D. Zawodny
On Thu, Jan 18, 2001 at 01:49:30PM -0800, Jeremy D. Zawodny wrote: On Wed, Jan 17, 2001 at 03:58:11PM -0600, Richard Reina wrote: Thanks for the reply. Curses worked OK. But I was convinced that a web server would be more efficient than NFS for sharing the database files. Is that

Re: Frontend Dilema

2001-01-18 Thread Richard Reina
Can someone tell me whats worng with my syntax: use DBI; $dbh = DBI-connect("DBI:mysql:rushload\@leader","richard", "passwd"); leader = name of server, rushload = name of database Do I need a port number if so which one should I use? Richard "Jeremy D. Zawodny" wrote: On Wed, Jan 17,