mysql odbc connection problem

[Machiel Richards]

Hi All

We are experiencing some problems when trying to connect to a mysql database
using ODBC.

The settings have been configured and it seems to be getting to the DB but
we getting the following error:

[S1T00][unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user
'root'@'hostname'
(using password: YES)
[ISQL]ERROR: Could not SQLConnect


can some perhaps assist please?

Regards

RE: mysql odbc connection problem

[John Daisley]

Make sure you have granted permissions in the db for root to connect from the 
host you are trying to connect from. Something like

GRANT priv ON db.table TO 'root'@'hostname' IDENTIFIED BY 'password';

FLUSH PRIVILEGES;

regards

Regards

John Daisley
Mobile +44(0)7812 451238
Email j...@butterflysystems.co.uk

Certified MySQL 5 Database Administrator (CMDBA)
Certified MySQL 5 Developer
Cognos BI Developer

---
Sent from HP IPAQ mobile device.



-Original Message-
From: Machiel Richards machiel.richa...@gmail.com
Sent: Tuesday, October 06, 2009 10:41 AM
To: mysql@lists.mysql.com
Subject: mysql odbc connection problem

Hi All

We are experiencing some problems when trying to connect to a mysql database
using ODBC.

The settings have been configured and it seems to be getting to the DB but
we getting the following error:

[S1T00][unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user
'root'@'hostname'
(using password: YES)
[ISQL]ERROR: Could not SQLConnect


can some perhaps assist please?

Regards


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

ODBC connection

[Ferguson, Michael]

 
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

[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

[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

[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

[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

ODBC connection issues

[Steve Grosz]

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 http://dev.mysql.com/doc/mysql/en/Password_hashing.html.
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 http://dev.mysql.com/doc/mysql/en/Password_hashing.html.
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 
http://dev.mysql.com/doc/mysql/en/Old_client.html 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 http://dev.mysql.com/doc/mysql/en/Password_hashing.html.
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]

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 
http://dev.mysql.com/doc/mysql/en/Old_client.html 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 
http://dev.mysql.com/doc/mysql/en/Password_hashing.html.

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]

Problems with maxdb odbc connection

[A . Beermann]

Hallo !

Strange problem with maxdb odbc connections.

I installed maxdb, databasemanager and sqlstudio on my local windows xp
pc and did some testing.
My application connects via system-dsn MAXDBLOKAL 
STORE
SQLSTRINGCONNECT('dsn=maxdblokal;port=7210;uid=DBA;pwd=DBA;DATABASE=BWNE
U') TO verbindungsnr

Everthing works as expected.
Then i installed maxdb on a linux server (same database name !!!)
Everthing seems to be ok. I can connect with the database manager, start
and stop ..
I can connect with sql studio and create and drop tables ..

BUT ?
When i open an connection from my pc to the server (dsn=MAXDBSERVER same
as MAXDBLOKAL but with different ip-adress) 
STORE
SQLSTRINGCONNECT('dsn=maxdbserver;port=7210;uid=DBA;pwd=DBA;DATABASE=BWN
EU') TO verbindungsnr
i'm always connected to my local database 
If the local database is not running there is an error message.

How can i connect to the server database ???

With mysql switching between lokal and server database by using two
different dsns works well !?


Any help welcomed

Best regards
Albert Beermann

'
  ' 
(0 0) 
 +-oOO---(_)---+ 
 | Tel: 0541/5841-868  | 
 | Fax: 0541/5841-869  | 
 | Mail: mailto:[EMAIL PROTECTED]  |  
 | Internet:  http://www.piepenbrock.de|
 +---oOO---+ 
   |__|__| 
|| || 
   ooO Ooo 

Re: Problems adding table to Crystal Reports using ODBC Connection

[Patrick]

The only other thing I can think of off the top of my head is Crystal's very
poor handling of prefix and postfix data in sub-reports.  If you are using
sub-reports make sure a field in the table in question is at least
referenced on the main report.

Sorry I couldn't be more help.

Pat...

- Original Message - 
From: Valère Palhoriès [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 21, 2004 6:50 PM
Subject: Re: Problems adding table to Crystal Reports using ODBC Connection


 Patrick,

 Yes I am. If I create a Linked Table from Access 2003 I can see the table.
 Additionally, I drop the Crystal Query into SQLyog and execute it and it
 works fine. Of course I modify the SQL Query slightly to be compliant with
 SQLYog!

 -- Val


 From: Patrick [EMAIL PROTECTED]
 To: Valère Palhoriès [EMAIL PROTECTED]
 Subject: Re: Problems adding table to Crystal Reports using ODBC
Connection
 Date: Wed, 21 Apr 2004 18:48:27 -0400
 
 Are you able to see the table with any other ODBC products (like
Access?).
 
 Pat...
 
 - Original Message -
 From: Valère Palhoriès [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Wednesday, April 21, 2004 6:45 PM
 Subject: Re: Problems adding table to Crystal Reports using ODBC
Connection
 
 
   Patrick,
  
   Yes, I have tried the Verify Database in Crystal and it comes back
with
   Database is up to date. I've also tried to RESET the Query from the
View
 SQL
   Query and it's correct!
  
   I'm at a loss!
  
   -- Val
  
  
   From: Patrick [EMAIL PROTECTED]
   To: Valère Palhoriès [EMAIL PROTECTED],
 [EMAIL PROTECTED]
   Subject: Re: Problems adding table to Crystal Reports using ODBC
 Connection
   Date: Wed, 21 Apr 2004 18:42:41 -0400
   
   Have you tried  'Verify Database' in Crystal?
   
   Pat...
   Patrick Sherrill
   CocoNet Corporation
   SW Florida's 1st ISP
   
   - Original Message -
   From: Valère Palhoriès [EMAIL PROTECTED]
   To: [EMAIL PROTECTED]
   Sent: Wednesday, April 21, 2004 5:26 PM
   Subject: Problems adding table to Crystal Reports using ODBC
Connection
   
   
 Hello,

 I have reports designed in Crystal Reports 8.5 that are connected
to
   MySql
 DB via an ODBC Connection. The reports run great and are accessed
   without
   a
 problem through our VB application.

 We have recently added a table to our database that needs to be
 added
 in
 addition to already existing tables on some of the reports. I Add
 the
   table,
 update the SQL Query and insert the field on the report. When I
try
 to
 preview the report I get the following error message:

 ODBC error: [MySql][ODBC 3.51 Driver][mysqld-4.0.16-nt]Unknown
table
 'tablename' in field list.

 I tried the same thing with several other reports and get the same
   results.
 The last table I add always gives the same message.

 I've tried re-creating the report from scratch and it works fine
 when
 I
   do.
 I tried to add another table onto the report I created from
scratch
 and
   get
 the same error message.

 Anyone know what's going on here?

 I'm trying to move towards the TTX concept but that will take me a
   couple
   of
 weeks. In the mean time, I have to get this problem resolved!

 Any help or light you can shed on this matter would be so much
   appreciated.

 Thanks

 -- Val

 _
 Lose those love handles! MSN Fitness shows you two moves to slim
 your
   waist.

  
 
http://fitness.msn.com/articles/feeds/article.aspx?dept=exercisearticle=et
 _pv_030104_lovehandles


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

   
  
   _
   MSN Toolbar provides one-click access to Hotmail from any Web page -
 FREE
   download! http://toolbar.msn.com/go/onm00200413ave/direct/01/
  
 

 _
 Watch LIVE baseball games on your computer with MLB.TV, included with MSN
 Premium!

http://join.msn.com/?page=features/mlbpgmarket=en-us/go/onm00200439ave/direct/01/



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

some problems with ODBC Connection

[akalend-vmb]

Dear Sir,

I download MySQL 1.4.1 version and ODBC 3.51 Connector.

I have some problem with connectoion name and nonblank password.
MySQL ODBC Drivers Errors: Client does not support autentifications protocol request 
by server.consider upgrading MySQL client.

If I  can connection without password (   use  blank password  ), I have succesfull 
connection.

What I can I do, download new ODBC version or new MySQL  server?

Alexander

corrupt odbc connection in MS Access

[Bob Ramsey]

Has anyone seen something like this before:

We have an Access database (about 9 megs in size) with linked tables in 
it.  The machine DSN shows that the information for the connection is 
correct.  But when you try to open the table in Access, a dialog pops up 
to connect to the mysql server and the information is wrong.  It has the 
wrong database name.  We correct the information in the odbc dialog box 
so that it matches the DSN information and the table opens.

We have triple checked the odbc connections for windows; they are all 
correct.  There's nothing in Access that references the wrong database.  
There's nothing in the registry.  Deleting the linked tables and 
re-linking them and repairing the access database appears to fix the 
problem.

Has any one else experienced this or know what might be causing it?  My 
only guess so far was that the mdb itself had become corrupt, which was 
why deleting and relinking the tables then repairing the database fixed 
the problem.

I'd appreciate any information you have.

Thanks,

bob

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

ODBC connection to MySQL problem

[florence florence]

Hi,
   
   
 nbsp;
   
  nbsp;   
   
   
   
nbsp; 
   
 
nbsp; 
   
   
   
  nbsp;   
   
   nbsp;  
   
   
nbsp; 
   
 
nbsp; 
   
   
   
  nbsp;   
   
   nbsp;  
   
   
   
 nbsp;
 
nbsp; 
   
   

 
Problems: 
 
[MYSQL][ODBC 3.51 driver] Client does not support authentication protocol requested 
by server. Consider upgrading MySQL client.
 
I am facing this problem when i try to add Data Source in User DSN in ODBC. It is fine 
if i don't put the password setting in MySQL database. But error occurs when i set the 
password. I am using MySQL4.1-alpha windows. How to solve this problem? Thanks for any 
help.


Yahoo! Games
- Who Wants to Be A Millionaire? Play now!

ODBC connection to MySQL problem

[florence florence]

Hi,
   
   
 nbsp;
   
  nbsp;   
   
   
   
nbsp; 
   
 
nbsp; 
   
   
   
  nbsp;   
   
   nbsp;  
   
   
nbsp; 
   
 
nbsp; 
   
   
   
  nbsp;   
   
   nbsp;  
   
   
   
 nbsp;
 
nbsp; 
   
   

 
Problems: 
 
[MYSQL][ODBC 3.51 driver] Client does not support authentication protocol requested 
by server. Consider upgrading MySQL client.
 
I am facing this problem when i try to add Data Source in User DSN in ODBC. It is fine 
if i don't put the password setting in MySQL database. But error occurs when i set the 
password. I am using MySQL4.1-alpha windows. How to solve this problem? Thanks for any 
help.



Yahoo! Games
- Who Wants to Be A Millionaire? Play now!

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]

ODBC connection from Windows app to Linux backend?

[LaBranche, Kevin]

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

ODBC connection with ssl support

[Giannis Vrentzos]

Hello.

I 'm trying to connect from vb to a mysql 4.0.5 server with ssl support 
with myodbc 3.51.The problem is that if i change the ssl_type in 
mysql.user table from nothing to 'ANY' or 'X509' i get the message of 
wrong password.Does anyone know what i have to do?

Thanks.

Giannis


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

ODBC connection from Mysql to Mssql

[David Lubowa]

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

all help is appreciated


cheers

ziggy


-
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

ODBC Connection to Linux MySQL

[yvon darang]

Hi,
I tried to connect to a mysql database running on a
linux server using an odbc connection in windows 98. I
get the following message:
 
[TCX][MyODBC]Host x.x.x.x is not allowed to connect to
this MySQL server
(#1130)[Microsoft][ODBC Driver Manager] Connection not
open (#0)
 
The username specified in the data source name is root
and I can ping the server where MySQLis running.

What did I do wrong or did not do at all on client or
server side?
Plase help me.

__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com

-
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

Fw: ODBC Connection to Linux MySQL

[Christoph Lütjen]

take a look in the user table (database mysql). There should be a row like
this...

HostUserPassword 
localhost  root ...

means that the user root can connect from localhost (the mysql server) only.

replace localhost by % or (better) insert a new row

%newuserpassword...

-

Hi,
I tried to connect to a mysql database running on a
linux server using an odbc connection in windows 98. I
get the following message:

[TCX][MyODBC]Host x.x.x.x is not allowed to connect to
this MySQL server
(#1130)[Microsoft][ODBC Driver Manager] Connection not
open (#0)

The username specified in the data source name is root
and I can ping the server where MySQLis running.

What did I do wrong or did not do at all on client or
server side?
Plase help me.


-
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

connecting to all databases using one odbc connection..PLEASE HELP

[Edward Peloke]

I asked yesterday but got no responses...anyone have any ideas how I can use
one odbc connection but have access to all databases on the MSSQL server???

Thanks,
Eddie

-
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: connecting to all databases using one odbc connection..PLEASE HELP

[Christopher Thompson]

On Tuesday 05 March 2002 11:11 am, Edward Peloke wrote:
 I asked yesterday but got no responses...anyone have any ideas how I can
 use one odbc connection but have access to all databases on the MSSQL
 server???

I have not tried this but have you considered using the use command?  Or even 
perhaps specifying the database name along with the table name?

-
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: connecting to all databases using one odbc connection..PLEASE HELP

[Todd Williamsen]

It won't let you since Windows ODBC only lets you create ONE DSN per
DATABASE

-Original Message-
From: Edward Peloke [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, March 05, 2002 12:11 PM
To: MySql
Subject: connecting to all databases using one odbc connection..PLEASE
HELP


I asked yesterday but got no responses...anyone have any ideas how I can
use
one odbc connection but have access to all databases on the MSSQL
server???

Thanks,
Eddie

-
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

accessing all dbs through one odbc connection..

[Edward Peloke]

I need to have access to all the databases on my server using one ODBC
connection.  Currently, I have to specify the db and only have access to
that one...is there a way around this?  How about SQL Links?

Thanks,
Eddie


-
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

odbc connection problem

[Devore, Jacob]

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

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

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

odbc connection problem

[Devore, Jacob]

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

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

odbc connection problem

[Devore, Jacob]

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

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