We help IT Professionals succeed at work.

Delphi 2009 + MySql

ArgusTrabuko
ArgusTrabuko asked
on
im try to use a simple procedure to insert data in a MySql Table.

im using TSQLConnection, TSQLDataSet, TSQLQuery from Palette dbExpres

But i aways get this message

Any Ideas ?


The Code :

SQLQuery1.Active := False;
SQLQuery1.SQL.Clear;
SQLQuery1.SQL.Add('insert into nome_tabela (login) values ('+''''+edit1.Text+''''+') ');
SQLQuery1.ExecSQL;

i try to search this lib on google but its too much hard to find it...



Thx!
object *****: TSQLConnection
    ConnectionName = '******'
    DriverName = 'MYSQL'
    LibraryName = 'dbexpmss.dll'
    LoginPrompt = False
    Params.Strings = (
      'drivername=MYSQL'
      'blobsize=-1'
      'database=****'
      'hostname=***.***.**.**'
      'localecode=0000'
      'password=******'
      'user_name=*****'
      'compressed=False'
      'encrypted=False'
      'port=3306')
    VendorLib = 'LIBMYSQL.dll'
    Left = 32
    Top = 32
  end

Open in new window

error.jpg
Comment
Watch Question

Senior Software Developer
Commented:

Delphi 2009/DBExpress is simply incompatible with MySQL 5.1 and more. To use dbExpress and MySQL should remain as MySQL 5.0 will work perfectly with libmysql.dll provides

or try another component like MyDAC(Data Access Components for MySQL) .

Author

Commented:
But my Online Host provide MySql 5.1
What can i do ?

i should try other component or a client MySql 5.0 can edit a online database 5.1.30 ?
Top Expert 2010
Commented:
The error ticket is described here: http://qc.embarcadero.com/wc/qcmain.aspx?d=84201

You can:

1. use ADO palette (TADOConnection, TADOQuery, etc. )

OR

2. upgrade to Delphi 2010

Author

Commented:
Thx, i'll try with Zeos lib