CODEWITHSUNDEEP
delphidelphi-7zeos
Wellington Telles Cunha
Wellington Telles Cunha

Reputation: 373

Delphi 7 + Zeos 7.1.4 + libmysql55.dll connect with PostgreSQL move to MySQL

I'm trying to get data from PostgreSQL from another computer and move to MySQL on my local computer.

I got libmysql55.dll from Zeos repository.

I had to create a program to fix a lot of mistakes over database.

One error is happening:

SQL Error: Access denied for user 'xxxx'@'localhost' (using password: YES)

I have information about: database, hostname, user and password.

ZConPropro.HostName := edtProproIP.Text;
ZConPropro.User     := edtUser.Text;
ZConPropro.Password := edtPassword.Text;
ZConPropro.Database := edtDatabase.Text;

The problem is happening when I try to connect:

ZConPropro.Connected := True;

I selected protocol: PostgreSQL and after postgresql9 and nothing is happening.

I would like to know if someone has this problem and there is some parameter to change.

I'm connecting to this database with HeidiSQL without a problem...same user, password, and database.

Upvotes: 0

Views: 1125

Answers (1)

mkysoft
mkysoft

Reputation: 5758

You need postgresql client library libpqXX.dll for connection. libmysql55.dll using for MySQL only. Given error message look like MySQL error message. It is said that user xxxx successfully connected to system but it is not authorized to connect this server from localhost. You need to check mysql.user table for user xxxx host config and/or change it. Don't forget run flush privileges after any change.

Upvotes: 1

Related Questions