1 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
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 pas
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 conne
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 t
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 t
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
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 mys
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" Descriptio
;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
7;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 instal
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
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
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
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 verbindung
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 T
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 passwor
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 t
Hi,
Hi,
vin [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 usin
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: Que
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
--
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
m
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 t
%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
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
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
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?
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
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
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 loo
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
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
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
34 matches
Mail list logo
