RE: ODBC connection

[Ferguson, Michael]

Thanks guys. I seem to have it working now. 'preciate it.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Friday, November 12, 2004 11:05 AM
To: Ferguson, Michael
Cc: [EMAIL PROTECTED]
Subject: Re: ODBC connection



The MySQL ODBC driver v3.51 acts as a pre-4.1 MySQL client. That
means it does not use the new (v4.1+) password hashing. 

http://dev.mysql.com/doc/mysql/en/Password_hashing.html 
http://dev.mysql.com/doc/mysql/en/Access_denied.html 
http://dev.mysql.com/doc/mysql/en/Old_client.html 

 I would create a new user just for your ODBC connection.(Use a
GRANT statement with all of the correct bells and whistles for your
situation) 
http://dev.mysql.com/doc/mysql/en/GRANT.html 

GRANT SELECT on *.* to 'remoteuser'@'%' 

Then reset the password to the OLD hashing style 

UPDATE  mysql.user set
password=OLD_PASSWORD('plaintextpassword") where user='remoteuser'; 

FLUSH PRIVILEGES; 

My example creates a pre-4.1 user account on your 4.1+ server
for the user 'remoteuser' with read-only rights to all databases on your
server with permission to login from anywhere. Adjust it to suit your
situation. 

One other gotcha that I had to figure out on my own... I had to
declare an initial database in my ODBC connection (DSN). Without it my
connections kept failing (sorry but I don't remember the exact message)
even when everything else was fine. 

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine 

"Ferguson, Michael" <[EMAIL PROTECTED]> wrote on 11/12/2004
10:30:14 AM:

>  
> G'Day All,
>  
> I am going nuts trying to setup ODBC to my MySQL database.
Help Please.
> My workstation is WinXP Pro. I downloaded the MySQL ODBC 3.51,
unzipped
> it and am trying to configure it to connect to the database on
a RedHat
> ES box.
>  
> In the Add Data Source Name my DSN is "closing" Description is
"TCAM"
> server is "xxx.xxx.xxx.xxx" local ip address for my server. I
enter the
> user and password and I keep getting the failure"
>  
> [MySQL][ODBC 3.51 Driver]Access denied for user
> 'root'@'myworkstationname.domainname.com' ( using
password:YES)
>  
> I am stuck. Help please. Thanks

RE: ODBC connection

[J.R. Bullington]

It is my Digital Signature. Sorry that it didn't come through.

J.R. 

-Original Message-
From: Ferguson, Michael [mailto:[EMAIL PROTECTED] 
Sent: Friday, November 12, 2004 11:19 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: ODBC connection

Thanks. I will give it a try. I also saw a reply from a J. Bullington but I
cannot open it due to some underlying security stuff.
 
Thanks though

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Friday, November 12, 2004 11:05 AM
To: Ferguson, Michael
Cc: [EMAIL PROTECTED]
Subject: Re: ODBC connection



The MySQL ODBC driver v3.51 acts as a pre-4.1 MySQL client. That
means it does not use the new (v4.1+) password hashing. 

http://dev.mysql.com/doc/mysql/en/Password_hashing.html 
http://dev.mysql.com/doc/mysql/en/Access_denied.html 
http://dev.mysql.com/doc/mysql/en/Old_client.html 

 I would create a new user just for your ODBC connection.(Use a
GRANT statement with all of the correct bells and whistles for your
situation) 
http://dev.mysql.com/doc/mysql/en/GRANT.html 

GRANT SELECT on *.* to 'remoteuser'@'%' 

Then reset the password to the OLD hashing style 

UPDATE  mysql.user set
password=OLD_PASSWORD('plaintextpassword") where user='remoteuser'; 

FLUSH PRIVILEGES; 

My example creates a pre-4.1 user account on your 4.1+ server for
the user 'remoteuser' with read-only rights to all databases on your server
with permission to login from anywhere. Adjust it to suit your situation. 

One other gotcha that I had to figure out on my own... I had to
declare an initial database in my ODBC connection (DSN). Without it my
connections kept failing (sorry but I don't remember the exact message) even
when everything else was fine. 

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine 

"Ferguson, Michael" <[EMAIL PROTECTED]> wrote on 11/12/2004
10:30:14 AM:

>  
> G'Day All,
>  
> I am going nuts trying to setup ODBC to my MySQL database.
Help Please.
> My workstation is WinXP Pro. I downloaded the MySQL ODBC 3.51,
unzipped
> it and am trying to configure it to connect to the database on a
RedHat
> ES box.
>  
> In the Add Data Source Name my DSN is "closing" Description is
"TCAM"
> server is "xxx.xxx.xxx.xxx" local ip address for my server. I
enter the
> user and password and I keep getting the failure"
>  
> [MySQL][ODBC 3.51 Driver]Access denied for user
> 'root'@'myworkstationname.domainname.com' ( using
password:YES)
>  
> I am stuck. Help please. Thanks




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ODBC connection

[Gleb Paharenko]

Hello.



See:

  http://dev.mysql.com/doc/mysql/en/Access_denied_error.html





>G'Day All,

> 

> I am going nuts trying to setup ODBC to my MySQL database. Help Please.

> My workstation is WinXP Pro. I downloaded the MySQL ODBC 3.51, unzipped

> it and am trying to configure it to connect to the database on a RedHat

> ES box.

>  

>  In the Add Data Source Name my DSN is "closing" Description is "TCAM"

>  server is "xxx.xxx.xxx.xxx" local ip address for my server. I enter the

>  user and password and I keep getting the failure"

>   

>   [MySQL][ODBC 3.51 Driver]Access denied for user

>   'root'@'myworkstationname.domainname.com' ( using password:YES)

>"Ferguson, Michael" <[EMAIL PROTECTED]> wrote:



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: ODBC connection

[Ferguson, Michael]

Thanks. I will give it a try. I also saw a reply from a J. Bullington
but I cannot open it due to some underlying security stuff.
 
Thanks though

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Friday, November 12, 2004 11:05 AM
To: Ferguson, Michael
Cc: [EMAIL PROTECTED]
Subject: Re: ODBC connection



The MySQL ODBC driver v3.51 acts as a pre-4.1 MySQL client. That
means it does not use the new (v4.1+) password hashing. 

http://dev.mysql.com/doc/mysql/en/Password_hashing.html 
http://dev.mysql.com/doc/mysql/en/Access_denied.html 
http://dev.mysql.com/doc/mysql/en/Old_client.html 

 I would create a new user just for your ODBC connection.(Use a
GRANT statement with all of the correct bells and whistles for your
situation) 
http://dev.mysql.com/doc/mysql/en/GRANT.html 

GRANT SELECT on *.* to 'remoteuser'@'%' 

Then reset the password to the OLD hashing style 

UPDATE  mysql.user set
password=OLD_PASSWORD('plaintextpassword") where user='remoteuser'; 

FLUSH PRIVILEGES; 

My example creates a pre-4.1 user account on your 4.1+ server
for the user 'remoteuser' with read-only rights to all databases on your
server with permission to login from anywhere. Adjust it to suit your
situation. 

One other gotcha that I had to figure out on my own... I had to
declare an initial database in my ODBC connection (DSN). Without it my
connections kept failing (sorry but I don't remember the exact message)
even when everything else was fine. 

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine 

"Ferguson, Michael" <[EMAIL PROTECTED]> wrote on 11/12/2004
10:30:14 AM:

>  
> G'Day All,
>  
> I am going nuts trying to setup ODBC to my MySQL database.
Help Please.
> My workstation is WinXP Pro. I downloaded the MySQL ODBC 3.51,
unzipped
> it and am trying to configure it to connect to the database on
a RedHat
> ES box.
>  
> In the Add Data Source Name my DSN is "closing" Description is
"TCAM"
> server is "xxx.xxx.xxx.xxx" local ip address for my server. I
enter the
> user and password and I keep getting the failure"
>  
> [MySQL][ODBC 3.51 Driver]Access denied for user
> 'root'@'myworkstationname.domainname.com' ( using
password:YES)
>  
> I am stuck. Help please. Thanks

Re: ODBC connection

[SGreen]

The MySQL ODBC driver v3.51 acts as a pre-4.1 MySQL client. That means it 
does not use the new (v4.1+) password hashing.

http://dev.mysql.com/doc/mysql/en/Password_hashing.html
http://dev.mysql.com/doc/mysql/en/Access_denied.html
http://dev.mysql.com/doc/mysql/en/Old_client.html

 I would create a new user just for your ODBC connection.(Use a GRANT 
statement with all of the correct bells and whistles for your situation)
http://dev.mysql.com/doc/mysql/en/GRANT.html

GRANT SELECT on *.* to 'remoteuser'@'%'

Then reset the password to the OLD hashing style

UPDATE  mysql.user set password=OLD_PASSWORD('plaintextpassword") where 
user='remoteuser';

FLUSH PRIVILEGES;

My example creates a pre-4.1 user account on your 4.1+ server for the user 
'remoteuser' with read-only rights to all databases on your server with 
permission to login from anywhere. Adjust it to suit your situation.

One other gotcha that I had to figure out on my own... I had to declare an 
initial database in my ODBC connection (DSN). Without it my connections 
kept failing (sorry but I don't remember the exact message) even when 
everything else was fine.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

"Ferguson, Michael" <[EMAIL PROTECTED]> wrote on 11/12/2004 10:30:14 
AM:

> 
> G'Day All,
> 
> I am going nuts trying to setup ODBC to my MySQL database. Help Please.
> My workstation is WinXP Pro. I downloaded the MySQL ODBC 3.51, unzipped
> it and am trying to configure it to connect to the database on a RedHat
> ES box.
> 
> In the Add Data Source Name my DSN is "closing" Description is "TCAM"
> server is "xxx.xxx.xxx.xxx" local ip address for my server. I enter the
> user and password and I keep getting the failure"
> 
> [MySQL][ODBC 3.51 Driver]Access denied for user
> 'root'@'myworkstationname.domainname.com' ( using password:YES)
> 
> I am stuck. Help please. Thanks

Re: ODBC connection issues

[Steve Grosz]

I noticed at the bottom of that page there are some user comments about 
recompiling and ODBC not working.  Any concerns regarding those comments 
and the issues I'm having?

Steve
Michael Stassen wrote:
No, I'm saying that your client (ODBC from Coldfusion) was built against 
an earlier version of the mysql client library, so it doesn't understand 
the new, more secure, authentication protocol introduced in mysql 4.1.

Did you read the manual section I suggested?  It contains an explanation 
of your exact error message, along with a link to another page 
 which offers 
work-arounds.

Michael
Steve Grosz wrote:
So, you're saying its a problem with the password on the root account? 
This was a brand new install.

I'm a little confused here.
Steve
Michael Stassen wrote:
See the manual 
.

Michael
Steve Grosz wrote:
I am trying to set up a ODBC connection from a Coldfusion server to 
a MySql server, both running on Windows2003 Servers.  I installed 
the ODBC 3.51 driver on the Coldfusion server, and am trying to make 
the connection.

When I go to set up the ODBC link and say 'test data source' I get a 
message that says [MySQL][ODBC 3.51 Driver] Client does not support 
authentication protocol requested by server; consider upgrading 
MySql client'.

What is this refering to???
Thanks,
Steve

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ODBC connection issues

[Michael Stassen]

No, I'm saying that your client (ODBC from Coldfusion) was built against an 
earlier version of the mysql client library, so it doesn't understand the 
new, more secure, authentication protocol introduced in mysql 4.1.

Did you read the manual section I suggested?  It contains an explanation of 
your exact error message, along with a link to another page 
 which offers work-arounds.

Michael
Steve Grosz wrote:
So, you're saying its a problem with the password on the root account? 
This was a brand new install.

I'm a little confused here.
Steve
Michael Stassen wrote:
See the manual .
Michael
Steve Grosz wrote:
I am trying to set up a ODBC connection from a Coldfusion server to a 
MySql server, both running on Windows2003 Servers.  I installed the 
ODBC 3.51 driver on the Coldfusion server, and am trying to make the 
connection.

When I go to set up the ODBC link and say 'test data source' I get a 
message that says [MySQL][ODBC 3.51 Driver] Client does not support 
authentication protocol requested by server; consider upgrading MySql 
client'.

What is this refering to???
Thanks,
Steve

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ODBC connection issues

[Steve Grosz]

So, you're saying its a problem with the password on the root account? 
This was a brand new install.

I'm a little confused here.
Steve
Michael Stassen wrote:
See the manual .
Michael
Steve Grosz wrote:
I am trying to set up a ODBC connection from a Coldfusion server to a 
MySql server, both running on Windows2003 Servers.  I installed the 
ODBC 3.51 driver on the Coldfusion server, and am trying to make the 
connection.

When I go to set up the ODBC link and say 'test data source' I get a 
message that says [MySQL][ODBC 3.51 Driver] Client does not support 
authentication protocol requested by server; consider upgrading MySql 
client'.

What is this refering to???
Thanks,
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ODBC connection issues

[Michael Stassen]

See the manual .
Michael
Steve Grosz wrote:
I am trying to set up a ODBC connection from a Coldfusion server to a 
MySql server, both running on Windows2003 Servers.  I installed the ODBC 
3.51 driver on the Coldfusion server, and am trying to make the connection.

When I go to set up the ODBC link and say 'test data source' I get a 
message that says [MySQL][ODBC 3.51 Driver] Client does not support 
authentication protocol requested by server; consider upgrading MySql 
client'.

What is this refering to???
Thanks,
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: ODBC connection from Windows app to Linux backend?

[David Brodbeck]

Would MyODBC do what you want?  I'm using it to connect MS Access to MySQL,
and also to connect a Borland Delphi application to a MySQL database.  It
works pretty well.  Consult the FAQ for known glitches with specific
applications.

> -Original Message-
> From: LaBranche, Kevin [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 26, 2003 5:02 PM
> To: '[EMAIL PROTECTED]'
> Subject: ODBC connection from Windows app to Linux backend?
> 
> 
> How would I connect my Windows app to a linux MySQL DB.
> 
> Would I just modify the DSN I am using to point to the correct server?
> 
> Thanks,
> Kevin
>  
> -Original Message-
> From: LaBranche, Kevin [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, March 26, 2003 12:18 PM
> To: '[EMAIL PROTECTED]'
> Subject: Query not returning what I expect
> 
> 
> The following query returns 0 for sCode instead of a string like
> "XXX:XX".
> 
> I am modifying an existing app from SQL Server 7 so that it 
> can also run
> with a MySQL backend 
> 
> The existing query in SQL Server 7 works fine
> SELECT sDAMIONCode, (sORI + ':' + sDamionCode) as sCode FROM tblORI 
> 
> Any hints would be appreciated. 
> 
> Kevin
> 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: ODBC connection from Mysql to Mssql

[Venu]

Hi !!!
 
> hey guys
> 
> i got a scenario here i need to extract some CDR records from 
> a Mssql database into a mysql database and have them 
> available on a website. I have not really configured odbc 
> before, so i am having some problems, i am running SuSE 7.2 
> on my linux box, i got the the source (myodbc) from mysql.com 
> and followed the instructions in the README, and also got 
> iodbc-2.50.17, but it has failed to install am i missing 
> something out here, or have i missed to install something. 
> Could someone who has done something similar please take me 
> through the procedure maybe i have missed/overlooked something
> 

 The iODBC is pretty old, better you choose the latest 3.0.6
 one from www.iodbc.org.

 Whats the error you are getting ? It is at configure level 
 or at the compilation or during the setup of the DSN ?

 You can find complete detailed instructions for all these 
 from http://www.mysql.com/products/myodbc/faq_toc.html 
 under the section '2 : Installation '.

Regards, Venu
--
For technical support contracts, go to https://order.mysql.com
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /   Mr. Venu <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Developer
/_/  /_/\_, /___/\___\_\___/  Palo Alto, CA-94306
   <___/  www.mysql.com   USA
 



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: odbc connection problem

[Venu]

Hi, 

> -Original Message-
> From: Devore, Jacob [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 20, 2001 10:01 AM
> To: '[EMAIL PROTECTED]'
> Subject: odbc connection problem
> 
> 
> When I connect through odbc I get a succes with info, when I look at the
> info I have a sql state of s1000, native error 0.  If I try to query the
> database I get an error and the sql state is s1000 with native error code of
> 1142.  Everything I read on the internet says it's some kind of permissions
> thing.  I have tried the mysql commands

What is the (warning) message ?

Regards, Venu
--
For technical support contracts, go to https://order.mysql.com
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /   Mr. Venu <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Developer
/_/  /_/\_, /___/\___\_\___/  California, USA
   <___/  www.mysql.com
> 
> GRANT ALL PRIVILEGES ON fr6 TO "Devore"@"jdevore-02";
> 
> INSERT INTO user (Host, User, Password, Select_priv, Insert_priv,
> Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv,
> Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv,
> Index_priv, Alter_priv) VALUES ("jdevore-02", "Devore@jdevore-02", "", "Y",
> "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y");
> 
> GRANT ALL PRIVILEGES ON fr6 TO "%"@"%";
> 
> And when I used these it let me connect but I got all those errors.  Before
> I started adding people to the user table I couldn't even connect.  Does
> anyone know what I'm doing wrong or is the odbc driver not recommended?
> 
> Thanks,
> 
> jake
> 
> 
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail 
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php