Board index » delphi » dbExpress Delphi6

marie-laur

Delphi Developer
Tue, 13 Jan 2004 15:53:00 GMT

dbExpress Delphi6

Hi
I've got a problem:
Impossible to connect Delphi6 under Windows 2000 to MySQL under Linux using
dbExpress.

Any suggestions?

Thanks

 
Pim Klingen

Delphi Developer
Tue, 13 Jan 2004 16:06:36 GMT

Re:dbExpress Delphi6


What is the problem exactly?

Did you setup the correct grants (acces rights) on your MySQL database.
(that a problem I encountered)

If you want to grant acces to your windows box do something like:
GRANT ALL on yourdatabase.* TO usern...@192.168.%  IDENTIFIED BY "password"
The username and password will be an account managed by MSSQL...
The 192.168.% the user identified by username/password are granted acces to
yourdatabase from any box
within the domain/subnetmask specified by 192.168.0.0/255.255.0.0
For more info see:
http://www.mysql.com/documentation/mysql/bychapter/manual_toc.html#Co...
n_access

Pim

Quote
"marie-laure" <marie-la...@cimeonline.com> wrote in message

news:3b611d9b_2@dnews...
Quote
> Hi
> I've got a problem:
> Impossible to connect Delphi6 under Windows 2000 to MySQL under Linux
using
> dbExpress.

> Any suggestions?

> Thanks

marie-laur

Delphi Developer
Tue, 13 Jan 2004 16:29:20 GMT

Re:dbExpress Delphi6


I can connect with mysqladmin. I think that I've got a problem with Delphi
6: what do I put in the properties of the component TSQLConnection ? I've
always this error:
error DBX: user/password incorrect. In local server I'm connected to mysql
but with Linux I can't.

"Pim Klingens" <pkling...@sequint.nl> a crit dans le message news:
3b612147_2@dnews...

Quote
> What is the problem exactly?

> Did you setup the correct grants (acces rights) on your MySQL database.
> (that a problem I encountered)

> If you want to grant acces to your windows box do something like:
> GRANT ALL on yourdatabase.* TO usern...@192.168.%  IDENTIFIED BY
"password"
> The username and password will be an account managed by MSSQL...
> The 192.168.% the user identified by username/password are granted acces
to
> yourdatabase from any box
> within the domain/subnetmask specified by 192.168.0.0/255.255.0.0
> For more info see:

http://www.mysql.com/documentation/mysql/bychapter/manual_toc.html#Co...
Quote
> n_access

> Pim

> "marie-laure" <marie-la...@cimeonline.com> wrote in message
> news:3b611d9b_2@dnews...
> > Hi
> > I've got a problem:
> > Impossible to connect Delphi6 under Windows 2000 to MySQL under Linux
> using
> > dbExpress.

> > Any suggestions?

> > Thanks

Pim Klingen

Delphi Developer
Tue, 13 Jan 2004 17:37:13 GMT

Re:dbExpress Delphi6


Oops, copied the grant wrong: it should be:
GRANT ALL ON test.* TO p...@192.168.% IDENTIFIED BY "pim"

Quote
"Pim Klingens" <pkling...@sequint.nl> wrote in message

news:3b61361f_1@dnews...
Quote
> I still think it is caused by a wrong or missing grant and possibly your
> connection settings...

> Here are my connection settings for the connection I make using the
> TSQLConnection component
> (Its the WebSiteNew section from the dbxconnections.ini located in
> C:\Program Files\Common Files\Borland Shared\Dbxpress directory)
> [WebSiteNew]
> DriverName=MYSQL
> BlobSize=-1
> Database=test
> HostName=192.168.50.15
> LocaleCode=0
> Password=pim
> User_Name=pim
> (These are the same as the values you can edit into some TSQLConnection
> properties)

> The hostname is the IP of the LINUX machine running MYSQL
> The grant I used is on MYSQL:
> GRANT ALL ON webtest.* TO p...@192.168.% IDENTIFIED BY "pim"

> The IP of my windows 2000 box is 192.168.50.17

> Hope this helps
> Pim
> "marie-laure" <marie-la...@cimeonline.com> wrote in message
> news:3b612622_1@dnews...
> > I can connect with mysqladmin. I think that I've got a problem with
Delphi
> > 6: what do I put in the properties of the component TSQLConnection ?
I've
> > always this error:
> > error DBX: user/password incorrect. In local server I'm connected to
mysql
> > but with Linux I can't.

> > "Pim Klingens" <pkling...@sequint.nl> a crit dans le message news:
> > 3b612147_2@dnews...
> > > What is the problem exactly?

> > > Did you setup the correct grants (acces rights) on your MySQL
database.
> > > (that a problem I encountered)

> > > If you want to grant acces to your windows box do something like:
> > > GRANT ALL on yourdatabase.* TO usern...@192.168.%  IDENTIFIED BY
> > "password"
> > > The username and password will be an account managed by MSSQL...
> > > The 192.168.% the user identified by username/password are granted
acces
> > to
> > > yourdatabase from any box
> > > within the domain/subnetmask specified by 192.168.0.0/255.255.0.0
> > > For more info see:

http://www.mysql.com/documentation/mysql/bychapter/manual_toc.html#Co...

- Show quoted text -

Quote
> > > n_access

> > > Pim

> > > "marie-laure" <marie-la...@cimeonline.com> wrote in message
> > > news:3b611d9b_2@dnews...
> > > > Hi
> > > > I've got a problem:
> > > > Impossible to connect Delphi6 under Windows 2000 to MySQL under
Linux
> > > using
> > > > dbExpress.

> > > > Any suggestions?

> > > > Thanks

Pim Klingen

Delphi Developer
Tue, 13 Jan 2004 17:22:13 GMT

Re:dbExpress Delphi6


I still think it is caused by a wrong or missing grant and possibly your
connection settings...

Here are my connection settings for the connection I make using the
TSQLConnection component
(Its the WebSiteNew section from the dbxconnections.ini located in
C:\Program Files\Common Files\Borland Shared\Dbxpress directory)
[WebSiteNew]
DriverName=MYSQL
BlobSize=-1
Database=test
HostName=192.168.50.15
LocaleCode=0
Password=pim
User_Name=pim
(These are the same as the values you can edit into some TSQLConnection
properties)

The hostname is the IP of the LINUX machine running MYSQL
The grant I used is on MYSQL:
GRANT ALL ON webtest.* TO p...@192.168.% IDENTIFIED BY "pim"

The IP of my windows 2000 box is 192.168.50.17

Hope this helps
Pim

Quote
"marie-laure" <marie-la...@cimeonline.com> wrote in message

news:3b612622_1@dnews...
Quote
> I can connect with mysqladmin. I think that I've got a problem with Delphi
> 6: what do I put in the properties of the component TSQLConnection ? I've
> always this error:
> error DBX: user/password incorrect. In local server I'm connected to mysql
> but with Linux I can't.

> "Pim Klingens" <pkling...@sequint.nl> a crit dans le message news:
> 3b612147_2@dnews...
> > What is the problem exactly?

> > Did you setup the correct grants (acces rights) on your MySQL database.
> > (that a problem I encountered)

> > If you want to grant acces to your windows box do something like:
> > GRANT ALL on yourdatabase.* TO usern...@192.168.%  IDENTIFIED BY
> "password"
> > The username and password will be an account managed by MSSQL...
> > The 192.168.% the user identified by username/password are granted acces
> to
> > yourdatabase from any box
> > within the domain/subnetmask specified by 192.168.0.0/255.255.0.0
> > For more info see:

http://www.mysql.com/documentation/mysql/bychapter/manual_toc.html#Co...

- Show quoted text -

Quote
> > n_access

> > Pim

> > "marie-laure" <marie-la...@cimeonline.com> wrote in message
> > news:3b611d9b_2@dnews...
> > > Hi
> > > I've got a problem:
> > > Impossible to connect Delphi6 under Windows 2000 to MySQL under Linux
> > using
> > > dbExpress.

> > > Any suggestions?

> > > Thanks

Steve Reeve

Delphi Developer
Tue, 13 Jan 2004 23:42:30 GMT

Re:dbExpress Delphi6


In article <3b611d9b_2@dnews>, marie-la...@cimeonline.com says...

Quote
> Hi
> I've got a problem:
> Impossible to connect Delphi6 under Windows 2000 to MySQL under Linux using
> dbExpress.

dbExpress doesn't yet support MySQL 3.23.XX only 3.22.XX this includes
the server and the libMySQL.dll in your Windows directory. If you go back
and read the posts for a few days you'll see tons of posts about it.. One
of them has a link to a site that has the older .dll if you need it.

Steve

Team

Delphi Developer
Wed, 14 Jan 2004 01:27:22 GMT

Re:dbExpress Delphi6


If you are using MySQL 3.23 that is the problem. The current dbExpress
driver only supports 3.22. An update is being worked on.

--
Bill
(TeamB cannot answer questions received via email)

LeoSof

Delphi Developer
Mon, 02 Feb 2004 18:43:02 GMT

Re:dbExpress Delphi6


Ok, your sound is good!

But, please let me know, where can i find  a  download location for 3.22.*?
I want to work on my standalone notebook w/o a linux server!
Can you give my link?

Leo

"Bill Todd (TeamB)" <bill.nos...@dbginc.com> wrote in message
news:3b61a47e_2@dnews...

Quote
> If you are using MySQL 3.23 that is the problem. The current dbExpress
> driver only supports 3.22. An update is being worked on.

> --
> Bill
> (TeamB cannot answer questions received via email)

Team

Delphi Developer
Tue, 03 Feb 2004 00:48:40 GMT

Re:dbExpress Delphi6


I am not sure where to download MySQL 3.22. You might try doing a search
with Google.

--
Bill
(TeamB cannot answer questions received via email)

Ruud Bijvan

Delphi Developer
Tue, 03 Feb 2004 20:51:36 GMT

Re:dbExpress Delphi6


http://www.mysql.com/downloads/mysql-3.22.html

--
Ruud Bijvank - Consultant
www.sequint.nl

"Bill Todd (TeamB)" <bill.nos...@dbginc.com> wrote in message
news:3b7bf997_2@dnews...

Quote
> I am not sure where to download MySQL 3.22. You might try doing a search
> with Google.

> --
> Bill
> (TeamB cannot answer questions received via email)

idonotkno

Delphi Developer
Thu, 04 Mar 2004 16:30:37 GMT

Re:dbExpress Delphi6


Quote
"Ruud Bijvank" <Ruud.Bijv...@xs4all.nl> wrote in message

news:3b7d11dc_2@dnews...

Quote
> http://www.mysql.com/downloads/mysql-3.22.html

That Link is Dead!  So where do we get it from now!
Dave Nottag

Delphi Developer
Thu, 04 Mar 2004 20:08:08 GMT

Re:dbExpress Delphi6


Quote
"idonotknow" wrote:
> > http://www.mysql.com/downloads/mysql-3.22.html

> That Link is Dead!  So where do we get it from now!

http://www.mysql.com/downloads/mysql-old.html

--
Dave Nottage

idonotkno

Delphi Developer
Fri, 05 Mar 2004 07:10:09 GMT

Re:dbExpress Delphi6


Quote
"Dave Nottage" <d...@removethis.b3.com.au> wrote in message

news:3ba4969d_1@dnews...

Quote

> http://www.mysql.com/downloads/mysql-old.html

Where is the Win32 distribution in that list?  Do I have to compile the
binaries from the source(if it is even supported)?
Dave Nottag

Delphi Developer
Fri, 05 Mar 2004 08:57:06 GMT

Re:dbExpress Delphi6


Quote
"idonotknow" wrote:
> > http://www.mysql.com/downloads/mysql-old.html

> Where is the Win32 distribution in that list?  Do I have to compile the
> binaries from the source(if it is even supported)?

It took me all of one minute to find that link from the one you posted.

I'm sure if there is a distribution, it wouldnt take much longer to find.
Alternatively you could contact the makers of MySQL. This is a Delphi
newsgroup, not a MySQL newsgroup.

--
Dave Nottage

idonotkno

Delphi Developer
Fri, 05 Mar 2004 14:02:49 GMT

Re:dbExpress Delphi6


Thanks Dave...But I already knew about that page before you posted it...Did
you notice that is said "Here you can download older, no longer supported
releases of MySQL..."

Quote
> Alternatively you could contact the makers of MySQL. This is a Delphi
> newsgroup, not a MySQL newsgroup.

Also, I am trying to use MySQL with Delphi 6/dbExpress so my inquiry IS
VALID...
Go to page: [1] [2]

Other Threads

1. delphi6 + dbexpress + mysql?

2. Interbase6, Delphi6, dbexpress and computed colums

3. Problem with Delphi6 + dbExpress + Oracle 7

4. MYSQL +DELPHI6 + DBEXPRESS = PROBLEM...

5. PROBLEM: Stored Procedure returning result set in Delphi6/dbExpress/Oracle 8.1.7

6. Problems with dbexpress&mysql&delphi6 on clients computers

7. How to migrate from Delphi6-interbase to Delphi6-Sql Server 7

8. How to migrate from Delphi6-interbase to Delphi6-Sql Server 7

9. Delphi6 Enterprise over Delphi6 Professional

10. dbExpress is very slooooooooooooowly ( Question for dbExpress developers)