Migrate Firebird Delphi 7 Application to Postgresql

Asked

Viewed 356 times

0

I am trying to migrate an application that was developed in Delphi 7 and that uses the database Firebird to save your information, to the database postgresql, from this, I have already been able to make the connection of postgresql with Delphi with the help of Zeoslib, however this application uses many particularities of dbExpress that Zeoslib does not have, so for this reason I will try to make the connection of Postgresql with ODBC, so that I can thus through dbExpress perform this connection with this application. The doubt is as follows, it is possible through the ODBC to realize that in Delphi 7, if yes as it would be possible to do this, I tried this way however this giving error when I try to connect with the ODBC created:

inserir a descrição da imagem aqui

inserir a descrição da imagem aqui

So when I get to this part of setting up it doesn’t allow to do anything, just save, then after saving when I try to open the same it is already with a password, which because it wasn’t I who set it up, I have no idea what it is, if you have any idea...

postgresql delphi-7 odbc migration

1 answer

2


Have you tried using the ODBC Postgresql driver itself ?

Product psqlODBC Description psqlODBC is the Official Postgresql ODBC Driver.

Licence Open source Publisher Postgresql Global Development Group

You can lower it in: www.postgresql.org

The setup is very quiet in case you try to do and give some error please post so I can try to help you.

  • How can I run an SQL command with Pgdac? For example with Sqlconnection the command is like this: SQLConnection.Execute('UPDATE NEXTID SET PROXIMOCODIGO = '+inttostr(sdsNextIDPROXIMOCODIGO.AsInteger+1)+
 ' WHERE TABELA = '''+TableName +'''', nil);

Browser other questions tagged postgresql delphi-7 odbc migration

You are not signed in. Login or sign up in order to post.