Postgre Todbcconnector Problem
lazarus / 16-Databases

----------------------------------------------------------------------
joel_santos · 2009-03-04 15:33

Hello..i have a problem connecting to postgreSQL using
TodbcConnector..
connection.Driver := 'Driver={PostgreSQL};Server=172.0.0.1;Port=5432;D
atabase=postgres;Uid=postgres;Pwd=masterkey;';
   connection.Open;     

   i'm using SLED 10.2  thanks...

----------------------------------------------------------------------
Marc · 2009-03-05 10:38

Please don't use a poll for asking questions

----------------------------------------------------------------------
theo · 2009-03-05 11:38

Quote from: joel_santos on March 04, 2009, 04:33:53
pmServer=172.0.0.1;

127.0.0.1 ?

----------------------------------------------------------------------
joel_santos · 2009-03-05 16:15

Well i got it....
with connection do begin
    Driver   := 'psqlODBC';
    UserName := 'postgres';
    Password := 'masterkey';
    Params.Add('SERVER=127.0.0.1');
    Params.Add('PORT=5432');
    Params.Add('DATABASE=postgres');
    Open;
    if Connected = true then
       showmessage('Connected'); 
end;  
            Theo....thanks for the correction......