MyODBC 3.51 help

Good Day

I have MySQL server 4.1 running in Windows XP pro (with sp2)
I have couple of data base. There is one that I would like to access
across my network. Two other systems are Windows XP and I'm using Linksys
router (with VoIP).

On the server system I have installed MyODBC 3.51 and I'm using Access 2003
as the front end and everything seems to be working grate. how ever when I
installed the MyODBC 3.51 on the other two systems, and pick the database I
get this error message "[MySQL][ODBC 3.51 Driver]Host
'du15-1.ppp.algonet.se' is not allowed to connect to this MySQL server"

I don't know where this address is coming from.



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.10.5/67 - Release Date: 09/08/2005



--
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: MyODBC 3.51 help

Please check that the MySQL userid you are using to connect from the clients
allows connections from hostname "%" (or your specific clients). If it only
works from the server, one reason could be that the userid is only
authorised from localhost.

-----Original Message-----
From: Louie Henry [mailto:louiehenry@brktel.on.ca]
Sent: 10 August 2005 20:32
To: myodbc@lists.mysql.com
Subject: MyODBC 3.51 help



Good Day

I have MySQL server 4.1 running in Windows XP pro (with sp2)
I have couple of data base. There is one that I would like to access
across my network. Two other systems are Windows XP and I'm using Linksys
router (with VoIP).

On the server system I have installed MyODBC 3.51 and I'm using Access 2003
as the front end and everything seems to be working grate. how ever when I
installed the MyODBC 3.51 on the other two systems, and pick the database I
get this error message "[MySQL][ODBC 3.51 Driver]Host
'du15-1.ppp.algonet.se' is not allowed to connect to this MySQL server"

I don't know where this address is coming from.



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.10.5/67 - Release Date: 09/08/2005



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=martin.kt@nb2bc.co.uk


--
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: MyODBC 3.51 Help

You should be able to do what you are trying. Did you put the subnet
mask on the end of the server IP or did the ODBC error message do that?

I presume the MySQL server is actually running and on the normal port?
Have you tried accessing the server with the command line tool 'mysql'?

Something like

mysql -h10.0.0.5 -umyuser -p Land

should get a response (it will prompt for the user password)

John B.

-----Original Message-----
From: George Ganchev [mailto:gganchev@agro-invest.com]=20
Sent: Monday, 17 April 2006 6:39 PM
To: myodbc@lists.mysql.com
Subject: MyODBC 3.51 Help

Dear coleagues,

I am now develop a simple test with MySQl, and have a problem with=20
remote conection to the mysql server.

The test is this:

1. Have a 2 PC, one named "alfa.mydomain.com" with IP 10.0.0.5 and=20
second "beta.mydomain.com" with IP 10.0.0.10

2. Alfa is my MySQL server, and I'm created a database "Land", and user=20
"myuser" wit all privilegs for "Land".

3. In PC Beta I'm install a MyODBC Driver 3.51and I'm have to create=20
connections to Land that located in PC Alfa.

4. I'm configure an ODBC in Windows 98, and then I press a "Test" in=20
"Diagnostics" write this

MySQL][ODBC 3.51 Driver]Unknown MySQL server host=20
'10.0.0.5/255.255.255.0' (11001)

=20

My idea is generate a small database that I'm need to fill in remote PC=20
Beta using Visual C++ 6.00

=20

Where I'm wrong, and if this is posible at all.

Best regards

George Ganchev.
gganchev@agro-invest.com



--
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