Click to See Complete Forum and Search --> : mySQL Communication Problems


jbmarsh80
02-02-2003, 02:00 PM
Hi everyone,

This is my first post and my first time using Linux. I'm having a problem with mySQL. I want to use my sql in connection with Windows 2000 so i can create a few ASP.NET pages. I am having a problem though connecting to the databse. I keep getting an error stating:
[MySQL][ODBC 3.51 Driver] Can't Connect to mySQL server on '192.168.1.199' (10054).

I followed the directions on the mysql web site to set up a connection with mysql using the .net framwork. I isntalled the new MDAC, installed the ODBC drivers from mircrosoft and also installed myODBC.

I am completely lost. Could someone please help? Thanks!

theN
02-03-2003, 02:10 AM
want to use my sql in connection with Windows 2000This forum is for Linux users, not W2K. You could try looking for answers in the appropriate newsgroup on Google Newsgroups.

If it's a Linux+MySQL problem, look up your error on Google and this forum.

hth
theN

jbmarsh80
02-03-2003, 09:25 AM
maybe I confused everyone by the post. I have a Linux box running MySQL, but cannot connect to it from any other computer. I want to be able to access the databases from my w2k server and am having problems with that. If i use ssh i can use mysql and write commands, but i want to be able to use the Linux box/MySql Server to store data for my websites that are run on a Windows 2000 server. I felt it was appropriate to ask here because i believe the error is from a setting on the linux box that I am not aware of or cannot find information about!

Thanks for your help! I'll keep looking around!

theN
02-04-2003, 02:59 AM
a Linux box running MySQL, but cannot connect to it from any other computer...If i use ssh i can use mysql and write commandsMaybe I am misreading you post, so kindly clarify. You are able to connect to your Linux box or you aren't , which one?

In the quoted text, the first part states you aren't able to connect to Linux box and the second part alludes to a successfull connection via secure telnet.

I want to be able to access the databases from my w2k server and am having problems with that.
please describe the problems in detail. State your conclusions, offer evidence / logs. Or just offer relevant logs for the perusal of the experts.

I felt it was appropriate to ask here because i believe the error is from a setting on the linux box...
how and why did you reach that conclusion?

regards
theN
ps: kindly try to be more lucid with your questions.