mysql odbc connector 5.1 connection error

mysql odbc connector 5.1 connection error

am 21.07.2008 21:32:38 von Martin Mabuwa

------=_Part_49712_14123839.1216668758955
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I have not able to connect to mysql dababase using the odbc connector from a
client windows workstation. I am able to connect using the odbc from the
machine that is hosting my sql server (localhost). I am using the ip
address of the server to try and configure the odbc connector and I continue
to receive errors. I have turned off the firewall but this does not seem to
help. Any recommendations

------=_Part_49712_14123839.1216668758955--

Re: mysql odbc connector 5.1 connection error

am 21.07.2008 21:44:01 von Imran Abizar

Martin,

What sort of error are you getting? Is it related to security or your
client does not even see the server?

If it is related to security, refer to
http://kb.synametrics.com/FrontController?operation=1&id=49

If it is related to Network, try the following.

* Open a console window (DOS prompt) on your client machine and type:
telnet serverHostName 3306
* If you see a blank screen, that mean your client can connect to your
server.
* If you see an error, that means it is a network problem and try to see
why.

Regards,
Imran.




Martin Mabuwa wrote:
> I have not able to connect to mysql dababase using the odbc connector from a
> client windows workstation. I am able to connect using the odbc from the
> machine that is hosting my sql server (localhost). I am using the ip
> address of the server to try and configure the odbc connector and I continue
> to receive errors. I have turned off the firewall but this does not seem to
> help. Any recommendations
>
>

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

RE: mysql odbc connector 5.1 connection error

am 22.07.2008 02:14:01 von John.Bonnett

It is good if you tell us exactly what error you are seeing.

One issue that springs to mind since you are connecting from a remote
client is, Is the user you are trying to connect as allowed to connect
from the IP address of the client. The security in MySQL is very
specific and you not only need to have a valid user name and password
but also be allowed to connect from the desired IP address. Check the
GRANTs for the user name you are trying to use and look for restrictions
on where it can connect from.

John Bonnett

-----Original Message-----
From: Martin Mabuwa [mailto:m.mabuwa@gmail.com]=20
Sent: Tuesday, 22 July 2008 5:03 AM
To: myodbc@lists.mysql.com
Subject: mysql odbc connector 5.1 connection error

I have not able to connect to mysql dababase using the odbc connector
from a client windows workstation. I am able to connect using the odbc
from the machine that is hosting my sql server (localhost). I am using
the ip address of the server to try and configure the odbc connector and
I continue to receive errors. I have turned off the firewall but this
does not seem to help. Any recommendations

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg