--0-357282339-1136765799=:34673
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Hello,

Any assistance will be appreciated. I recieve the following error when trying to make a connection from my machine (A) to the host provider machine (B): [MySQL][ODBC 3.51 Driver]Access denied for user: 'admin3 (AT) adsl-69-151-60-28 (DOT) dsl.rcsntx.swbell.net' (Using password: YES)

The only thing I noticed is that for some reason my ISP address is appended to the username.

Machine A:
Windows XP Service Pack 1
MySQL OBDC 3.51.12

Machine B:
Operating system Linux
Service Status Click to View
Kernel version 2.4.21-32.0.1.ELsmp
Machine Type i686
Apache version 1.3.33 (Unix)
MySQL version 4.0.25-standard




George


--0-357282339-1136765799=:34673--

------_=_NextPart_001_01C79BC1.2F682539
Content-Type: text/plain;
charset="koi8-r"
Content-Transfer-Encoding: quoted-printable

Hi,
=20
In my experience one needs to configure "User DSN" not "System DSN" for =
ODBC to work.
=20
Also, I am not sure if this is a typo in your E-mail or in the ODBC =
configuration.
=20
You saying "MySQL host: "locflhost" should read "MySQL host:localhost"
=20
Uspexov,

Mikhail Berman

-----Original Message-----
From: =F3=C1=C4=CF=D7=D3=CB=C9=CA =F7.=F4. =
[mailto:svt (AT) mogilev (DOT) beltelecom.by]
Sent: Monday, May 21, 2007 9:19 AM
To: myodbc (AT) lists (DOT) mysql.com
Subject: MyODBC

=FA=C4=D2=C1=D7=D4=D7=D5=CA=D4=C5 =C4=CF=D2=CF=C7=C9=C5 =
=DC=CB=D3=D0=C5=D4=D9!!!
=EE=C5 =CD=CF=C7=D5 =D7=CF=D3=D0=CF=CC=D8=DA=CF=D7=C1=D4=D8=D3=D1 =
=D5=D3=D4=C1=CE=D7=CC=C5=CE=CE=D9=CD MyODBC!
=F0=CF=D3=CC=C5 =D5=D3=D4=C1=CE=CF=D7=CB=C9 MyODBC =DA=C1=D7=CF=D6=D5 =
=CE=C1 Microsoft ODBC - DSN (=C9=CD=D1), =C4=D2=C1=CA=D7=C5=D2 MySQL. =
MySQL host: "locflhost", MySQL database name: "BRUL"
user: "svt", Password: "235", port: 3306, =C1 =D4=C1=CB=D6=C5 =
=D5=D3=D4=C1=CE=C1=D7=CC=C9=D7=C1=C0 =CF=D0=C3=C9=C9: Don`t =
optimize...,Return matching rows.
=E4=C1=CC=C5=C5 =D0=D9=D4=C1=C0=D3=D8 =
=D7=CF=D3=D0=CF=CC=D8=DA=CF=D7=C1=D4=D8=D3=D1 "ADOConnection" Delphi6 =
=C9 =CE=C1=D3=D4=D2=C1=C9=D7=C1=C0 =CB=C1=CB =CF=C2=D9=DE=CE=CF =
"ADOConnection":
1)Connetcnion string- =C9=D3=D0=CF=CC=D8=DA=D5=C0 Build string - =
=DA=C1=D0=CF=CC=CE=D1=C0 =D0=CF=CC=D1, Click_=C1=C0
"=F0=D2=CF=D7=C5=D2=C9=D4=D8 =D0=CF=C4=CB=CC=C0=DE=C5=CE=C9=C5 " =C9 =
=D0=CF=CC=D5=DE=C1=C0 "=EE=C5 =D7=D9=D0=CF=CC=CE=C5=CE=C1 =
=D0=D2=CF=D2=D7=C5=D2=CB=C1 =D0=CF=C4=CB=CC=C0=DE=C5=CE=C9=D1 =
=C9=DA-=DA=C1 =CF=DB=C9=C2=CB=C9 =D0=D2=C9 =
=C9=CE=C9=C3=C9=C1=CC=C9=DA=C1=C3=C9=C9 =D0=CF=D3=D4=C1=D7=DD=C9=CB=C1. =
[TCX][MyODBC]Client does not support authentcation protocol requested by =
server; consider upgrading MySQL client."

=F0=CF=CD=CF=C7=C9=D4=D4=C5=C5=C5=C5!!!!, =E7=C4=C5 =CD=CF=D6=CE=CF =
=D3=CB=C1=DE=C1=D4=D8 =D0=CF=C4 Windows XP clienta MySQL (My ODBC) - =
MySQL-56.01
=F3 =F5=D7=C1=D6=C5=CE=C9=C5=CD =C9 =
=C2=CC=C1=C7=CF=C4=CF=D2=CE=CF=D3=D4=D8=C0 svt.


------_=_NextPart_001_01C79BC1.2F682539--

An additional issue:
You get an authentcation protocol error. Try to use authentcation =
compatible
version of client/server; or configure your server to use old password
format. You can check this issue by an user with empty password.

Shlomi Zlatopolsky

-----Original Message-----
From: Mikhail Berman [mailto:mberman (AT) ivesinc (DOT) com]=20
Sent: Monday, May 21, 2007 7:01 PM
To: =F3=C1=C4=CF=D7=D3=CB=C9=CA =F7.=F4.; myodbc (AT) lists (DOT) mysql.com
Subject: RE: MyODBC

Hi,
=20
In my experience one needs to configure "User DSN" not "System DSN" for
ODBC to work.
=20
Also, I am not sure if this is a typo in your E-mail or in the ODBC
configuration.
=20
You saying "MySQL host: "locflhost" should read "MySQL host:localhost"
=20
Uspexov,

Mikhail Berman

-----Original Message-----
From: =F3=C1=C4=CF=D7=D3=CB=C9=CA =F7.=F4. =
[mailto:svt (AT) mogilev (DOT) beltelecom.by]
Sent: Monday, May 21, 2007 9:19 AM
To: myodbc (AT) lists (DOT) mysql.com
Subject: MyODBC

=FA=C4=D2=C1=D7=D4=D7=D5=CA=D4=C5 =C4=CF=D2=CF=C7=C9=C5 =
=DC=CB=D3=D0=C5=D4=D9!!!
=EE=C5 =CD=CF=C7=D5 =D7=CF=D3=D0=CF=CC=D8=DA=CF=D7=C1=D4=D8=D3=D1 =
=D5=D3=D4=C1=CE=D7=CC=C5=CE=CE=D9=CD MyODBC!
=F0=CF=D3=CC=C5 =D5=D3=D4=C1=CE=CF=D7=CB=C9 MyODBC =DA=C1=D7=CF=D6=D5 =
=CE=C1 Microsoft ODBC - DSN (=C9=CD=D1), =C4=D2=C1=CA=D7=C5=D2 MySQL.
MySQL host: "locflhost", MySQL database name: "BRUL"
user: "svt", Password: "235", port: 3306, =C1 =D4=C1=CB=D6=C5 =
=D5=D3=D4=C1=CE=C1=D7=CC=C9=D7=C1=C0 =CF=D0=C3=C9=C9: Don`t
optimize...,Return matching rows.
=E4=C1=CC=C5=C5 =D0=D9=D4=C1=C0=D3=D8 =
=D7=CF=D3=D0=CF=CC=D8=DA=CF=D7=C1=D4=D8=D3=D1 "ADOConnection" Delphi6 =
=C9 =CE=C1=D3=D4=D2=C1=C9=D7=C1=C0 =CB=C1=CB
=CF=C2=D9=DE=CE=CF "ADOConnection":
1)Connetcnion string- =C9=D3=D0=CF=CC=D8=DA=D5=C0 Build string - =
=DA=C1=D0=CF=CC=CE=D1=C0 =D0=CF=CC=D1, Click_=C1=C0
"=F0=D2=CF=D7=C5=D2=C9=D4=D8 =D0=CF=C4=CB=CC=C0=DE=C5=CE=C9=C5 " =C9 =
=D0=CF=CC=D5=DE=C1=C0 "=EE=C5 =D7=D9=D0=CF=CC=CE=C5=CE=C1 =
=D0=D2=CF=D2=D7=C5=D2=CB=C1 =D0=CF=C4=CB=CC=C0=DE=C5=CE=C9=D1 =
=C9=DA-=DA=C1
=CF=DB=C9=C2=CB=C9 =D0=D2=C9 =C9=CE=C9=C3=C9=C1=CC=C9=DA=C1=C3=C9=C9 =
=D0=CF=D3=D4=C1=D7=DD=C9=CB=C1. [TCX][MyODBC]Client does not support
authentcation protocol requested by server; consider upgrading MySQL
client."

=F0=CF=CD=CF=C7=C9=D4=D4=C5=C5=C5=C5!!!!, =E7=C4=C5 =CD=CF=D6=CE=CF =
=D3=CB=C1=DE=C1=D4=D8 =D0=CF=C4 Windows XP clienta MySQL (My ODBC) -
MySQL-56.01 =F3 =F5=D7=C1=D6=C5=CE=C9=C5=CD =C9 =
=C2=CC=C1=C7=CF=C4=CF=D2=CE=CF=D3=D4=D8=C0 svt.


No virus found in this incoming message.
Checked by AVG Free Edition.=20
Version: 7.5.467 / Virus Database: 269.7.6/813 - Release Date: =
20.05.2007
7:54
=20

No virus found in this outgoing message.
Checked by AVG Free Edition.=20
Version: 7.5.467 / Virus Database: 269.7.6/813 - Release Date: =
20.05.2007
7:54
=20


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=...ie.nctu.edu.tw