Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Connecting XP/ODBC to MySql
Name: KBB Date: March 11, 2004 at 18:13:09 Pacific OS: Linux 9.0 CPU/Ram: 850 MHz/1 GHz
Comment:
I am trying to configure ODBC on my Windows XP machine to connect to a MySql database on my Linux server. I want to write an .Net application that will connect to a MySql database using ODBC. I have installed the ODBC MySql driver on my XP machine. The machines are connect using Samba, but I don't know what else needs to be setup for MySql. Can this be done?
Name: Jared Felton Date: March 14, 2004 at 23:36:09 Pacific
Reply:
I don't know any .net, you can probably "Map Network Drive" to give a samba share a windows drive letter and use that drive letter to let your program access it over samba.
It's probably better to use some sort of TCP/IP solution, though. There are probably libraries in .Net for that.
I don't know the mysql server well enough (i've only written applications with the database on the same machine) to tell you how to access it over tcp/ip either, but I know it can be done - probably fairly easily.
0
Response Number 2
Name: 3Dave Date: March 15, 2004 at 08:12:36 Pacific
Reply:
MySQL uses port 3306 by default. Make sure that it is open on any firewalls inbetween the two computers. Have you entered all the relavent info into the XP ODBC driver? Can it test the connection?
0
Response Number 3
Name: KBB Date: March 17, 2004 at 18:40:29 Pacific
Reply:
I found my problem. I needed to enter my machine name as the host in the host, user, and db tables of the mysql database.
Summary: I am trying to connect my Mac Powerbook G4 running Mac OS/X to my Red Hat Linux 9 Server through a NetGear wireless router. I have a Airport Extream wireless card in my powerbook. It seams to detect...
Summary: OK so i have a very busy website, which used to use a flat file database system for members i have just covnerted it to run completely from MYSQL, however now with 200 users online MYSQL is going craz...
Summary: Try exporting your access information to mysql. http://www.cynergi.net/exportsql/exportsql2.txt http://www.cynergi.net/exportsql/exportsql2b.txt http://mysql.mirrors.cybercity.dk/Downloads/Contrib/acc...
0 
