Thanks for the info. Let me see if I have this right. (I am asking these question on behalf of my UNIX programmer who will be doing all of the programming so sorry if I am asking simple questions.)
To make this simple, let's label the computers. The MySQL database server will be labeled "B" and the UNIX machine doing the inserts will be "A" This is what I understand so far. I install the client on "A" and it can then talk to the mysqld server on "B"? How do I need to go about telling "A" where the mysql server is located? Is this something I can set up in a ini file or does it need to be in the scripts that are ran to do the inserts (like a php or asp script does). My UNIX guy asked me to ask about an ODBC connector. Will MyODBC work on Unix? Thanks so much for the help! Chris -----Original Message----- From: gerald_clark [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 3:16 PM To: Chris Couture Cc: [EMAIL PROTECTED] Subject: Re: Need Driver to connect Unix SCO 5.2 Open Server to MySQL DB? You need the client 'mysql' on the unix machine to talk to the server 'mysqld' on whatever machine. This will allow you to write shell scripts that call mysql. If you want to program in PHP or perl, then you need their mysql drivers which talk to the server. Chris Couture wrote: >Hi, > >I'm a MySQL Newbie and am working on my first real project. The project >involves removing the Access database off of our system and using MySQL >in its place. Here is what happens now with this database.... > >The Unix machine writes information to the end of a text file every time >an invoice is processed. This text file is FTP'd every 10 minutes over >to our server. Access starts up and querys all the data and puts it >into the proper tables. (Currently there are 15,000+ records and this >has only been running for 6 months so you can see the need to rethink >this process.) > >This process allows our shipping computers, using OBDC to connect to the >access database where they can pull the information into the fields >(name, address, service type etc) > >Anyway, here is where I stand now. I have built the MySQL server and it >has been up and running for 3 weeks now and seems stable. I have >installed MyODBC on the shipping computers and they connect. My >question is what type of driver do I need to put on the Unix machine to >make it where it can write insert statements directly to the database? > >Thanks, > >Chris > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
