MyODBC for XP connects Linux MySQL Server
MyODBC for XP connects Linux MySQL Server
am 06.09.2005 07:59:22 von Tata Respecia
hello!
can somebody help me how MyODBC for XP connects to
mysql server on linux fedora4? is there something that
i need to install on the server side? how to install
it? my present MyODBC can only connect to mysql server
residing on xp box.
thanks,
tatarespecia
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
Re: MyODBC for XP connects Linux MySQL Server
am 06.09.2005 09:17:06 von Bernard LEFEUVRE
Hello, it'easy to realize.
1 - On server Linux :
in my.cnf file verify you have invalidated the line skip-networking
-> #skip-networking
2 - Configure ODBC :
- Data Source Name The local name you want for your Database
- Description Just a comment
- Server Name or IP adress of the Linux server
- User The name of the user who access
the Database
- Password Password for the user
- Database The name of the MySql Database on
the server
Press "Test" button permit you to verify your settings.
Bernard
Tata Respecia a écrit :
>hello!
>
>can somebody help me how MyODBC for XP connects to
>mysql server on linux fedora4? is there something that
>i need to install on the server side? how to install
>it? my present MyODBC can only connect to mysql server
>residing on xp box.
>
>thanks,
>tatarespecia
>
>__________________________________________________
>Do You Yahoo!?
>Tired of spam? Yahoo! Mail has the best spam protection around
>http://mail.yahoo.com
>
>
>
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
RE: MyODBC for XP connects Linux MySQL Server
am 08.09.2005 00:43:37 von jbonnett
There are several things that could be wrong. How far do you get? Do you
get any error messages when you try to test the connection?
John B.
-----Original Message-----
From: Tata Respecia [mailto:tatarespecia@yahoo.com]=20
Sent: Tuesday, 6 September 2005 3:29 PM
To: win32@lists.mysql.com
Subject: MyODBC for XP connects Linux MySQL Server
hello!
can somebody help me how MyODBC for XP connects to
mysql server on linux fedora4? is there something that
i need to install on the server side? how to install
it? my present MyODBC can only connect to mysql server
residing on xp box.
thanks,
tatarespecia
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around=20
http://mail.yahoo.com=20
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org
RE: MyODBC for XP connects Linux MySQL Server
am 08.09.2005 03:49:41 von Tata Respecia
when i test the connection it says:
[MySQL][ODBC 3.51 Driver]Can't connect to MySQL Server
on ('10.10.10.50') (10065)
i guess ther must be something that i have to install
on on the server. only that i don't know what it is or
is it possible.
--- jbonnett@sola.com.au wrote:
> There are several things that could be wrong. How
> far do you get? Do you
> get any error messages when you try to test the
> connection?
>
> John B.
>
> -----Original Message-----
> From: Tata Respecia [mailto:tatarespecia@yahoo.com]
> Sent: Tuesday, 6 September 2005 3:29 PM
> To: win32@lists.mysql.com
> Subject: MyODBC for XP connects Linux MySQL Server
>
> hello!
>
> can somebody help me how MyODBC for XP connects to
> mysql server on linux fedora4? is there something
> that
> i need to install on the server side? how to install
> it? my present MyODBC can only connect to mysql
> server
> residing on xp box.
>
> thanks,
> tatarespecia
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam
> protection around
> http://mail.yahoo.com
>
>
______________________________________________________
Click here to donate to the Hurricane Katrina relief effort.
http://store.yahoo.com/redcross-donate3/
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
RE: MyODBC for XP connects Linux MySQL Server
am 08.09.2005 04:59:57 von bullijr
------=_NextPart_000_0017_01C5B3FF.DC3D3B80
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: 7bit
The ODBC driver does need to be installed on the server, but it sounds as
though this is a permissions problem.
Can you connect to the server via 'root'@'localhost'? If so, try the
username and password that want to use with your ODBC. If you cannot connect
that way, make sure that either you have 'username'@'10.10.10.50' in your
user configs, or use 'username'@'%' to make sure that you can connect for
the time being.
If not, you probably don't have the connection permissions with the username
and password that you are using. Did you set up a DSN to connect to the
server or are you using code?
If the former, can you run the TEST DSN and tell us what you get? (is it a
'connection failed' or is it a 'username/password' error?)
If the latter, can you post the code, removing the username and password?
There are lots of reasons that the connection string might not work, but I
still think that we need more data to help you out.
Here's some data that we will need:
What, if any, programming language are you using (PHP, ASP, ASP.NET,
VB.NET, Java, etc.)
Is your Linux box a web server or is this a client/server config?
J.R.
-----Original Message-----
From: Tata Respecia [mailto:tatarespecia@yahoo.com]
Sent: Wednesday, September 07, 2005 9:50 PM
To: jbonnett@sola.com.au; win32@lists.mysql.com
Subject: RE: MyODBC for XP connects Linux MySQL Server
when i test the connection it says:
[MySQL][ODBC 3.51 Driver]Can't connect to MySQL Server on ('10.10.10.50')
(10065)
i guess ther must be something that i have to install on on the server. only
that i don't know what it is or is it possible.
--- jbonnett@sola.com.au wrote:
> There are several things that could be wrong. How far do you get? Do
> you get any error messages when you try to test the connection?
>
> John B.
>
> -----Original Message-----
> From: Tata Respecia [mailto:tatarespecia@yahoo.com]
> Sent: Tuesday, 6 September 2005 3:29 PM
> To: win32@lists.mysql.com
> Subject: MyODBC for XP connects Linux MySQL Server
>
> hello!
>
> can somebody help me how MyODBC for XP connects to mysql server on
> linux fedora4? is there something that i need to install on the server
> side? how to install it? my present MyODBC can only connect to mysql
> server residing on xp box.
>
> thanks,
> tatarespecia
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
>
______________________________________________________
Click here to donate to the Hurricane Katrina relief effort.
http://store.yahoo.com/redcross-donate3/
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=bullijr@innovatim.com
------=_NextPart_000_0017_01C5B3FF.DC3D3B80
Content-Type: application/x-pkcs7-signature;
name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="smime.p7s"
MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEH AQAAoIIIyzCCAlMw
ggG8oAMCAQICAw2wbDANBgkqhkiG9w0BAQQFADBiMQswCQYDVQQGEwJaQTEl MCMGA1UEChMcVGhh
d3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBl cnNvbmFsIEZyZWVt
YWlsIElzc3VpbmcgQ0EwHhcNMDQxMjI1MDU1MDI3WhcNMDUxMjI1MDU1MDI3 WjBHMR8wHQYDVQQD
ExZUaGF3dGUgRnJlZW1haWwgTWVtYmVyMSQwIgYJKoZIhvcNAQkBFhVidWxs aWpyQGlubm92YXRp
bS5jb20wgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAMq8xll8x9DXRaF4 Jb1JrfXT2+/AbYgl
/EbzRxjgWlkoNGax5RvXNQP8v6glF5XkYPIhtVz2YekUGPxysrTCga+jCWej JGIG8FU9VWK8LFWr
KDEpuKKyptu13AyJlFoFBAXUVz29R5ebNAerI2PhlJpUBdyaL0nCwdf3i719 sEYlAgMBAAGjMjAw
MCAGA1UdEQQZMBeBFWJ1bGxpanJAaW5ub3ZhdGltLmNvbTAMBgNVHRMBAf8E AjAAMA0GCSqGSIb3
DQEBBAUAA4GBAIPvkbSmB9MC9npZ2X4uE22c6y/7wwk551mGOgy+zY5eNivS i65WK7AuUnbgk/az
pDLMYQIwvaNE4y/tIXM5DrLCejaBBPxfVzbM2nwV81DnUbE8HVrBLpMv9AkT UcFrs0GNGb8rfdom
JFZSPorna4hIKV4HhxyYo8o6VnuZqkfdMIIDLTCCApagAwIBAgIBADANBgkq hkiG9w0BAQQFADCB
0TELMAkGA1UEBhMCWkExFTATBgNVBAgTDFdlc3Rlcm4gQ2FwZTESMBAGA1UE BxMJQ2FwZSBUb3du
MRowGAYDVQQKExFUaGF3dGUgQ29uc3VsdGluZzEoMCYGA1UECxMfQ2VydGlm aWNhdGlvbiBTZXJ2
aWNlcyBEaXZpc2lvbjEkMCIGA1UEAxMbVGhhd3RlIFBlcnNvbmFsIEZyZWVt YWlsIENBMSswKQYJ
KoZIhvcNAQkBFhxwZXJzb25hbC1mcmVlbWFpbEB0aGF3dGUuY29tMB4XDTk2 MDEwMTAwMDAwMFoX
DTIwMTIzMTIzNTk1OVowgdExCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0 ZXJuIENhcGUxEjAQ
BgNVBAcTCUNhcGUgVG93bjEaMBgGA1UEChMRVGhhd3RlIENvbnN1bHRpbmcx KDAmBgNVBAsTH0Nl
cnRpZmljYXRpb24gU2VydmljZXMgRGl2aXNpb24xJDAiBgNVBAMTG1RoYXd0 ZSBQZXJzb25hbCBG
cmVlbWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJlZW1haWxA dGhhd3RlLmNvbTCB
nzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEA1GnX1LCUZFtx6UfYDFG26nKR sIRefS0Nj3sS34Ul
dSh0OkIsYyeflXtL734Zhx2G6qPduc6WZBrCFG5ErHzmj+hND3EfQDimAKOH ePb5lIZererAXnbr
2RSjXW56fAylS1V/Bhkpf56aJtVquzgkCGqYx7Hao5iR/Xnb5VrEHLkCAwEA AaMTMBEwDwYDVR0T
AQH/BAUwAwEB/zANBgkqhkiG9w0BAQQFAAOBgQDH7JJ+Tvj1lqVnYiqk8E0R YNBvjWBYYawmu1I1
XAjPMPuoSpaKH2JCI4wXD/S6ZJwXrEcp352YXtJsYHFcoqzceePnbgBHH7UN KOgCneSa/RP0ptl8
sfjcXyMmCZGAc9AUG95DqYMl8uacLxXK/qarigd1iwzdUYRr5PjRzneigTCC Az8wggKooAMCAQIC
AQ0wDQYJKoZIhvcNAQEFBQAwgdExCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxX ZXN0ZXJuIENhcGUx
EjAQBgNVBAcTCUNhcGUgVG93bjEaMBgGA1UEChMRVGhhd3RlIENvbnN1bHRp bmcxKDAmBgNVBAsT
H0NlcnRpZmljYXRpb24gU2VydmljZXMgRGl2aXNpb24xJDAiBgNVBAMTG1Ro YXd0ZSBQZXJzb25h
bCBGcmVlbWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJlZW1h aWxAdGhhd3RlLmNv
bTAeFw0wMzA3MTcwMDAwMDBaFw0xMzA3MTYyMzU5NTlaMGIxCzAJBgNVBAYT AlpBMSUwIwYDVQQK
ExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3 dGUgUGVyc29uYWwg
RnJlZW1haWwgSXNzdWluZyBDQTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkC gYEAxKY8VXNV+065
yplaHmjAdQRwnd/p/6Me7L3N9VvyGna9fww6YfK/Uc4B1OVQCjDXAmNaLIkV cI7dyfArhVqqP3FW
y688Cwfn8R+RNiQqE88r1fOCdz0Dviv+uxg+B79AgAJk16emu59l0cUqVIUP SAR/p7bRPGEEQB5k
GXJgt/sCAwEAAaOBlDCBkTASBgNVHRMBAf8ECDAGAQH/AgEAMEMGA1UdHwQ8 MDowOKA2oDSGMmh0
dHA6Ly9jcmwudGhhd3RlLmNvbS9UaGF3dGVQZXJzb25hbEZyZWVtYWlsQ0Eu Y3JsMAsGA1UdDwQE
AwIBBjApBgNVHREEIjAgpB4wHDEaMBgGA1UEAxMRUHJpdmF0ZUxhYmVsMi0x MzgwDQYJKoZIhvcN
AQEFBQADgYEASIzRUIPqCy7MDaNmrGcPf6+svsIXoUOWlJ1/TCG4+DYfqi2f Ni/A9BxQIJNwPP2t
4WFiw9k6GX6EsZkbAMUaC4J0niVQlGLH2ydxVyWN3amcOY6MIE9lX5Xa9/eH 1sYITq726jTlEBpb
NU1341YheILcIRk13iSx0x1G/11fZU8xggLPMIICywIBATBpMGIxCzAJBgNV BAYTAlpBMSUwIwYD
VQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNU aGF3dGUgUGVyc29u
YWwgRnJlZW1haWwgSXNzdWluZyBDQQIDDbBsMAkGBSsOAwIaBQCgggG8MBgG CSqGSIb3DQEJAzEL
BgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTA1MDkwODAyNTk1NFowIwYJ KoZIhvcNAQkEMRYE
FE5GKm9kXr0T8RyePAhg1UwxpCC8MGcGCSqGSIb3DQEJDzFaMFgwCgYIKoZI hvcNAwcwDgYIKoZI
hvcNAwICAgCAMA0GCCqGSIb3DQMCAgFAMAcGBSsOAwIHMA0GCCqGSIb3DQMC AgEoMAcGBSsOAwIa
MAoGCCqGSIb3DQIFMHgGCSsGAQQBgjcQBDFrMGkwYjELMAkGA1UEBhMCWkEx JTAjBgNVBAoTHFRo
YXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQ ZXJzb25hbCBGcmVl
bWFpbCBJc3N1aW5nIENBAgMNsGwwegYLKoZIhvcNAQkQAgsxa6BpMGIxCzAJ BgNVBAYTAlpBMSUw
IwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQD EyNUaGF3dGUgUGVy
c29uYWwgRnJlZW1haWwgSXNzdWluZyBDQQIDDbBsMA0GCSqGSIb3DQEBAQUA BIGAOSleLvSqPAcw
BQG0kZUh+3O16YH7JsdQ4GzAXT/R8Oupu9nZmEquy7fM+a4F0S1w7u71IN2n 4QBhWCUWwlJ1KXx0
yPKFXtg9Er+Ip7s4PRfkt7ZlDTmTCHwSMMgRROG1SMTjZV9ZQEzQYmdmyN4G GqUjmP3yS/6C12Bn
9KOy38IAAAAAAAA=
------=_NextPart_000_0017_01C5B3FF.DC3D3B80--
Re: MyODBC for XP connects Linux MySQL Server
am 08.09.2005 15:46:22 von Daniel da Veiga
I may be wrong, but it seems that's not an ODBC problem, if you can't
connect because of a permission problem, the server returns another
error regarding user and host permission. Maybe a firewall blocking
the connection. Try connecting using the console, or another
application that has native (not ODBC) support for MySQL (like the
administrator or query browser) using the same user and pass. Check
the versions, if both the local and the remote mysqls are the same
(password format problems).
--=20
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org
Re: MyODBC for XP connects Linux MySQL Server
am 08.09.2005 16:36:22 von Jorge Bastos
I would advise to use:
telnet hostname 3306
That's the best way to try :-)
Jorge
----- Original Message -----
From: "Daniel da Veiga"
To: "MySQL Win32 List"
Sent: Thursday, September 08, 2005 2:46 PM
Subject: Re: MyODBC for XP connects Linux MySQL Server
I may be wrong, but it seems that's not an ODBC problem, if you can't
connect because of a permission problem, the server returns another
error regarding user and host permission. Maybe a firewall blocking
the connection. Try connecting using the console, or another
application that has native (not ODBC) support for MySQL (like the
administrator or query browser) using the same user and pass. Check
the versions, if both the local and the remote mysqls are the same
(password format problems).
--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=mysql.jorge@decimal.pt
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
Re: MyODBC for XP connects Linux MySQL Server
am 08.09.2005 16:48:31 von SGreen
--=_alternative 0051B39585257076_=
Content-Type: text/plain; charset="US-ASCII"
I had problems connecting via ODBC until I figured out that the Database
Name field was not optional (my permissions were fine. I know because I
had been using it by the CLI for some time). For some reason the driver
needs that information to make an initial connection or a test. Sorry but
it was so long ago that I have forgotten the exact error message but I do
remember it was something very bland and not very informative like the one
she is getting.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Daniel da Veiga wrote on 09/08/2005 10:46:22 AM:
> I may be wrong, but it seems that's not an ODBC problem, if you can't
> connect because of a permission problem, the server returns another
> error regarding user and host permission. Maybe a firewall blocking
> the connection. Try connecting using the console, or another
> application that has native (not ODBC) support for MySQL (like the
> administrator or query browser) using the same user and pass. Check
> the versions, if both the local and the remote mysqls are the same
> (password format problems).
>
> --
> Daniel da Veiga
> Computer Operator - RS - Brazil
> -----BEGIN GEEK CODE BLOCK-----
> Version: 3.1
> GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
> PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
> ------END GEEK CODE BLOCK------
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=sgreen@unimin.com
>
--=_alternative 0051B39585257076_=--
RE: MyODBC for XP connects Linux MySQL Server
am 09.09.2005 01:07:39 von Tata Respecia
the former: a connection failed.
i used the root acct
--- "J.R. Bullington" wrote:
> The ODBC driver does need to be installed on the
> server, but it sounds as
> though this is a permissions problem.
>
> Can you connect to the server via
> 'root'@'localhost'? If so, try the
> username and password that want to use with your
> ODBC. If you cannot connect
> that way, make sure that either you have
> 'username'@'10.10.10.50' in your
> user configs, or use 'username'@'%' to make sure
> that you can connect for
> the time being.
>
> If not, you probably don't have the connection
> permissions with the username
> and password that you are using. Did you set up a
> DSN to connect to the
> server or are you using code?
>
> If the former, can you run the TEST DSN and tell us
> what you get? (is it a
> 'connection failed' or is it a 'username/password'
> error?)
> If the latter, can you post the code, removing the
> username and password?
>
> There are lots of reasons that the connection string
> might not work, but I
> still think that we need more data to help you out.
>
> Here's some data that we will need:
> What, if any, programming language are you using
> (PHP, ASP, ASP.NET,
> VB.NET, Java, etc.)
> Is your Linux box a web server or is this a
> client/server config?
>
>
> J.R.
>
>
> -----Original Message-----
> From: Tata Respecia [mailto:tatarespecia@yahoo.com]
> Sent: Wednesday, September 07, 2005 9:50 PM
> To: jbonnett@sola.com.au; win32@lists.mysql.com
> Subject: RE: MyODBC for XP connects Linux MySQL
> Server
>
> when i test the connection it says:
>
> [MySQL][ODBC 3.51 Driver]Can't connect to MySQL
> Server on ('10.10.10.50')
> (10065)
>
> i guess ther must be something that i have to
> install on on the server. only
> that i don't know what it is or is it possible.
>
>
> --- jbonnett@sola.com.au wrote:
>
> > There are several things that could be wrong. How
> far do you get? Do
> > you get any error messages when you try to test
> the connection?
> >
> > John B.
> >
> > -----Original Message-----
> > From: Tata Respecia
> [mailto:tatarespecia@yahoo.com]
> > Sent: Tuesday, 6 September 2005 3:29 PM
> > To: win32@lists.mysql.com
> > Subject: MyODBC for XP connects Linux MySQL Server
> >
> > hello!
> >
> > can somebody help me how MyODBC for XP connects to
> mysql server on
> > linux fedora4? is there something that i need to
> install on the server
> > side? how to install it? my present MyODBC can
> only connect to mysql
> > server residing on xp box.
> >
> > thanks,
> > tatarespecia
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam? Yahoo! Mail has the best spam
> protection around
> > http://mail.yahoo.com
> >
> >
>
>
>
>
>
>
______________________________________________________
> Click here to donate to the Hurricane Katrina relief
> effort.
> http://store.yahoo.com/redcross-donate3/
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
>
http://lists.mysql.com/win32?unsub=bullijr@innovatim.com
>
>
______________________________________________________
Click here to donate to the Hurricane Katrina relief effort.
http://store.yahoo.com/redcross-donate3/
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
Re: MyODBC for XP connects Linux MySQL Server
am 09.09.2005 01:15:16 von Tata Respecia
i tried the telnet, this error occured:
Could not open connection to the host, on port 3306:
Connect failed
--- Jorge Bastos wrote:
> I would advise to use:
>
> telnet hostname 3306
>
> That's the best way to try :-)
>
> Jorge
>
>
>
> ----- Original Message -----
> From: "Daniel da Veiga"
> To: "MySQL Win32 List"
> Sent: Thursday, September 08, 2005 2:46 PM
> Subject: Re: MyODBC for XP connects Linux MySQL
> Server
>
>
> I may be wrong, but it seems that's not an ODBC
> problem, if you can't
> connect because of a permission problem, the server
> returns another
> error regarding user and host permission. Maybe a
> firewall blocking
> the connection. Try connecting using the console, or
> another
> application that has native (not ODBC) support for
> MySQL (like the
> administrator or query browser) using the same user
> and pass. Check
> the versions, if both the local and the remote
> mysqls are the same
> (password format problems).
>
> --
> Daniel da Veiga
> Computer Operator - RS - Brazil
> -----BEGIN GEEK CODE BLOCK-----
> Version: 3.1
> GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$
> N o+ K- w O M- V-
> PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+
> y++
> ------END GEEK CODE BLOCK------
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
>
http://lists.mysql.com/win32?unsub=mysql.jorge@decimal.pt
>
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
>
http://lists.mysql.com/win32?unsub=tatarespecia@yahoo.com
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
RE: MyODBC for XP connects Linux MySQL Server
am 09.09.2005 03:13:23 von bullijr
------=_NextPart_000_0025_01C5B4BA.24DF5520
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: 7bit
Since you cannot telnet into it, this is more than likely a Firewall issue.
On your Linux box and your router, make sure that port 3306 is open to
connections. This will make sure that you can connect to the MySQL server.
J.R.
-----Original Message-----
From: Tata Respecia [mailto:tatarespecia@yahoo.com]
Sent: Thursday, September 08, 2005 7:15 PM
To: mysql.jorge@decimal.pt; win32@lists.mysql.com
Subject: Re: MyODBC for XP connects Linux MySQL Server
i tried the telnet, this error occured:
Could not open connection to the host, on port 3306:
Connect failed
--- Jorge Bastos wrote:
> I would advise to use:
>
> telnet hostname 3306
>
> That's the best way to try :-)
>
> Jorge
>
>
>
> ----- Original Message -----
> From: "Daniel da Veiga"
> To: "MySQL Win32 List"
> Sent: Thursday, September 08, 2005 2:46 PM
> Subject: Re: MyODBC for XP connects Linux MySQL Server
>
>
> I may be wrong, but it seems that's not an ODBC
> problem, if you can't
> connect because of a permission problem, the server
> returns another
> error regarding user and host permission. Maybe a
> firewall blocking
> the connection. Try connecting using the console, or
> another
> application that has native (not ODBC) support for
> MySQL (like the
> administrator or query browser) using the same user
> and pass. Check
> the versions, if both the local and the remote
> mysqls are the same
> (password format problems).
>
> --
> Daniel da Veiga
> Computer Operator - RS - Brazil
> -----BEGIN GEEK CODE BLOCK-----
> Version: 3.1
> GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$
> N o+ K- w O M- V-
> PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+
> y++
> ------END GEEK CODE BLOCK------
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
>
http://lists.mysql.com/win32?unsub=mysql.jorge@decimal.pt
>
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
>
http://lists.mysql.com/win32?unsub=tatarespecia@yahoo.com
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=bullijr@innovatim.com
------=_NextPart_000_0025_01C5B4BA.24DF5520
Content-Type: application/x-pkcs7-signature;
name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="smime.p7s"
MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEH AQAAoIIIyzCCAlMw
ggG8oAMCAQICAw2wbDANBgkqhkiG9w0BAQQFADBiMQswCQYDVQQGEwJaQTEl MCMGA1UEChMcVGhh
d3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBl cnNvbmFsIEZyZWVt
YWlsIElzc3VpbmcgQ0EwHhcNMDQxMjI1MDU1MDI3WhcNMDUxMjI1MDU1MDI3 WjBHMR8wHQYDVQQD
ExZUaGF3dGUgRnJlZW1haWwgTWVtYmVyMSQwIgYJKoZIhvcNAQkBFhVidWxs aWpyQGlubm92YXRp
bS5jb20wgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAMq8xll8x9DXRaF4 Jb1JrfXT2+/AbYgl
/EbzRxjgWlkoNGax5RvXNQP8v6glF5XkYPIhtVz2YekUGPxysrTCga+jCWej JGIG8FU9VWK8LFWr
KDEpuKKyptu13AyJlFoFBAXUVz29R5ebNAerI2PhlJpUBdyaL0nCwdf3i719 sEYlAgMBAAGjMjAw
MCAGA1UdEQQZMBeBFWJ1bGxpanJAaW5ub3ZhdGltLmNvbTAMBgNVHRMBAf8E AjAAMA0GCSqGSIb3
DQEBBAUAA4GBAIPvkbSmB9MC9npZ2X4uE22c6y/7wwk551mGOgy+zY5eNivS i65WK7AuUnbgk/az
pDLMYQIwvaNE4y/tIXM5DrLCejaBBPxfVzbM2nwV81DnUbE8HVrBLpMv9AkT UcFrs0GNGb8rfdom
JFZSPorna4hIKV4HhxyYo8o6VnuZqkfdMIIDLTCCApagAwIBAgIBADANBgkq hkiG9w0BAQQFADCB
0TELMAkGA1UEBhMCWkExFTATBgNVBAgTDFdlc3Rlcm4gQ2FwZTESMBAGA1UE BxMJQ2FwZSBUb3du
MRowGAYDVQQKExFUaGF3dGUgQ29uc3VsdGluZzEoMCYGA1UECxMfQ2VydGlm aWNhdGlvbiBTZXJ2
aWNlcyBEaXZpc2lvbjEkMCIGA1UEAxMbVGhhd3RlIFBlcnNvbmFsIEZyZWVt YWlsIENBMSswKQYJ
KoZIhvcNAQkBFhxwZXJzb25hbC1mcmVlbWFpbEB0aGF3dGUuY29tMB4XDTk2 MDEwMTAwMDAwMFoX
DTIwMTIzMTIzNTk1OVowgdExCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0 ZXJuIENhcGUxEjAQ
BgNVBAcTCUNhcGUgVG93bjEaMBgGA1UEChMRVGhhd3RlIENvbnN1bHRpbmcx KDAmBgNVBAsTH0Nl
cnRpZmljYXRpb24gU2VydmljZXMgRGl2aXNpb24xJDAiBgNVBAMTG1RoYXd0 ZSBQZXJzb25hbCBG
cmVlbWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJlZW1haWxA dGhhd3RlLmNvbTCB
nzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEA1GnX1LCUZFtx6UfYDFG26nKR sIRefS0Nj3sS34Ul
dSh0OkIsYyeflXtL734Zhx2G6qPduc6WZBrCFG5ErHzmj+hND3EfQDimAKOH ePb5lIZererAXnbr
2RSjXW56fAylS1V/Bhkpf56aJtVquzgkCGqYx7Hao5iR/Xnb5VrEHLkCAwEA AaMTMBEwDwYDVR0T
AQH/BAUwAwEB/zANBgkqhkiG9w0BAQQFAAOBgQDH7JJ+Tvj1lqVnYiqk8E0R YNBvjWBYYawmu1I1
XAjPMPuoSpaKH2JCI4wXD/S6ZJwXrEcp352YXtJsYHFcoqzceePnbgBHH7UN KOgCneSa/RP0ptl8
sfjcXyMmCZGAc9AUG95DqYMl8uacLxXK/qarigd1iwzdUYRr5PjRzneigTCC Az8wggKooAMCAQIC
AQ0wDQYJKoZIhvcNAQEFBQAwgdExCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxX ZXN0ZXJuIENhcGUx
EjAQBgNVBAcTCUNhcGUgVG93bjEaMBgGA1UEChMRVGhhd3RlIENvbnN1bHRp bmcxKDAmBgNVBAsT
H0NlcnRpZmljYXRpb24gU2VydmljZXMgRGl2aXNpb24xJDAiBgNVBAMTG1Ro YXd0ZSBQZXJzb25h
bCBGcmVlbWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJlZW1h aWxAdGhhd3RlLmNv
bTAeFw0wMzA3MTcwMDAwMDBaFw0xMzA3MTYyMzU5NTlaMGIxCzAJBgNVBAYT AlpBMSUwIwYDVQQK
ExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3 dGUgUGVyc29uYWwg
RnJlZW1haWwgSXNzdWluZyBDQTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkC gYEAxKY8VXNV+065
yplaHmjAdQRwnd/p/6Me7L3N9VvyGna9fww6YfK/Uc4B1OVQCjDXAmNaLIkV cI7dyfArhVqqP3FW
y688Cwfn8R+RNiQqE88r1fOCdz0Dviv+uxg+B79AgAJk16emu59l0cUqVIUP SAR/p7bRPGEEQB5k
GXJgt/sCAwEAAaOBlDCBkTASBgNVHRMBAf8ECDAGAQH/AgEAMEMGA1UdHwQ8 MDowOKA2oDSGMmh0
dHA6Ly9jcmwudGhhd3RlLmNvbS9UaGF3dGVQZXJzb25hbEZyZWVtYWlsQ0Eu Y3JsMAsGA1UdDwQE
AwIBBjApBgNVHREEIjAgpB4wHDEaMBgGA1UEAxMRUHJpdmF0ZUxhYmVsMi0x MzgwDQYJKoZIhvcN
AQEFBQADgYEASIzRUIPqCy7MDaNmrGcPf6+svsIXoUOWlJ1/TCG4+DYfqi2f Ni/A9BxQIJNwPP2t
4WFiw9k6GX6EsZkbAMUaC4J0niVQlGLH2ydxVyWN3amcOY6MIE9lX5Xa9/eH 1sYITq726jTlEBpb
NU1341YheILcIRk13iSx0x1G/11fZU8xggLPMIICywIBATBpMGIxCzAJBgNV BAYTAlpBMSUwIwYD
VQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNU aGF3dGUgUGVyc29u
YWwgRnJlZW1haWwgSXNzdWluZyBDQQIDDbBsMAkGBSsOAwIaBQCgggG8MBgG CSqGSIb3DQEJAzEL
BgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTA1MDkwOTAxMTMyMlowIwYJ KoZIhvcNAQkEMRYE
FAx3+Dp+NOaxyEMHdSRtmr/tihejMGcGCSqGSIb3DQEJDzFaMFgwCgYIKoZI hvcNAwcwDgYIKoZI
hvcNAwICAgCAMA0GCCqGSIb3DQMCAgFAMAcGBSsOAwIHMA0GCCqGSIb3DQMC AgEoMAcGBSsOAwIa
MAoGCCqGSIb3DQIFMHgGCSsGAQQBgjcQBDFrMGkwYjELMAkGA1UEBhMCWkEx JTAjBgNVBAoTHFRo
YXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQ ZXJzb25hbCBGcmVl
bWFpbCBJc3N1aW5nIENBAgMNsGwwegYLKoZIhvcNAQkQAgsxa6BpMGIxCzAJ BgNVBAYTAlpBMSUw
IwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQD EyNUaGF3dGUgUGVy
c29uYWwgRnJlZW1haWwgSXNzdWluZyBDQQIDDbBsMA0GCSqGSIb3DQEBAQUA BIGAATNJmMQvZsRU
o8YZ1cSH/UnRzhZEP+ddr0SrPOrM3eF3uPGAw52tYY2P4wCWw7319AMsFmoM ABB5Xw9JUTNtfH+2
rNEmZkU+hsunzngNSHrPcCjZRXHCJHS+UrLf0xPNgsPd5+7csPwRQXex6ApR sIrCsqSTdsMOi+gP
SEXcSwgAAAAAAAA=
------=_NextPart_000_0025_01C5B4BA.24DF5520--