RE: access-mysql

2002-12-05 Thread Chris Couture
I have used Access to MySQL pro and it worked for a few of my databases. http://www.convert-in.com/acc2sqlp.htm Chris -Original Message- From: Sandeep Murphy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 8:39 AM To: MySQL List Subject: access-mysql Hi, Can anyone

Where should I start looking? Relationships? Joins? Temp Tables?

2002-11-15 Thread Chris Couture
Hello, I am trying to create a shopping cart for my company and have hit a snag. I have created a database in MySQL that has several tables. How would I go about displaying the fields from one table based on the fields in the other? Let me explain. I have a table called forder_details which

RE: access db port to mysql

2002-11-13 Thread Chris Couture
When you say port are you asking to export the access DB to mysql? If so, Intelligent Converters makes one and you can also do it with EMS MySQL manager. If you wanting to view the mysql data in access; you can do this using myodbc and open it using external data using the ODBC source.

RE: Where are db files ??

2002-10-04 Thread Chris Couture
1 - Where does mySQL normally store it's data base files? * From what I have seen, it depends on how you install it. You can check in the my.ini file and that will let you know where it is. 2 - Can you change the default directory for a data base? * Yes, you can change this in the

RE: Need Driver to connect Unix SCO 5.2 Open Server to MySQL DB?

2002-10-03 Thread Chris Couture
This is what I thought. Thanks. I think we are almost there! Chris -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 8:51 AM To: Chris Couture Cc: [EMAIL PROTECTED] Subject: Re: Need Driver to connect Unix SCO 5.2 Open Server to MySQL

RE: Need Driver to connect Unix SCO 5.2 Open Server to MySQL DB?

2002-10-03 Thread Chris Couture
all of our orders to dump the data to the MySQL database instead of inserting it into the text file so that everything is tied together. Thanks again, Chris -Original Message- From: Grimes, Dean [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 8:01 AM To: Chris Couture

RE: MySQL and ODBC prolbme

2002-10-03 Thread Chris Couture
Can the two machines ping each other? -Original Message- From: Jeff Bluemel [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 9:11 AM To: [EMAIL PROTECTED] Subject: MySQL and ODBC prolbme I have mysql on a linux box (IP 192.168.0.1), and I've got a windows 2000 box that I

RE: Need Driver to connect Unix SCO 5.2 Open Server to MySQL DB?

2002-10-02 Thread Chris Couture
: gerald_clark [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 9:12 AM To: Chris Couture Cc: [EMAIL PROTECTED] Subject: Re: Need Driver to connect Unix SCO 5.2 Open Server to MySQL DB? Chris Couture wrote: Thanks for the info. Let me see if I have this right. (I am asking

Need Driver to connect Unix SCO 5.2 Open Server to MySQL DB?

2002-10-01 Thread Chris Couture
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

RE: Need Driver to connect Unix SCO 5.2 Open Server to MySQL DB?

2002-10-01 Thread Chris Couture
, 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