Error connecting to PostgreSQL
Posted: Thu 15 May 2014 18:52
Hi,
I have the following problem connecting to PostgreSQL
Conn.DriverName := 'DevartPostgreSQL';
Conn.GetDriverFunc := 'getSQLDriverPostgreSQL';
Conn.LibraryName := 'dbexppgsql.dll';
Conn.LoginPrompt := False;
Conn.VendorLib := 'not used';
Conn.Params.Clear;
Conn.Params.Add('DriverName=DevartPostgreSQL');
Conn.Params.Add('HostName=' + hostNameR.Text);
Conn.Params.Add('DataBase=' + dbNameR.Text);
Conn.Params.Add('User_name=' + userNameR.Text);
Conn.Params.Add('Password=' + passwordR.Text);
Conn.Params.Add('Server Port=' + portR.Text);
Conn.Params.Add('BlobSize=-1');
Conn.Params.Add('FetchAll=True');
Conn.Params.Add('LongStrings=True');
Conn.Params.Add('DetectParamTypes=True');
Conn.Open;
The following error occurs: SQL Server Error: Invalid value for parameter "cliente_encoding": "Win1252"
----------
follow my settings
Postgres version: 9.3
Driver Devart: latest version
Delphi 7
show client_encoding = WIN1252
show server_encoding = UTF8
database accessed: ENCODING = 'LATIN1'
Conn.Params.Add ('client_encoding = LATIN1'); Does not work????
*** Portuguese to English via google translator
I have the following problem connecting to PostgreSQL
Conn.DriverName := 'DevartPostgreSQL';
Conn.GetDriverFunc := 'getSQLDriverPostgreSQL';
Conn.LibraryName := 'dbexppgsql.dll';
Conn.LoginPrompt := False;
Conn.VendorLib := 'not used';
Conn.Params.Clear;
Conn.Params.Add('DriverName=DevartPostgreSQL');
Conn.Params.Add('HostName=' + hostNameR.Text);
Conn.Params.Add('DataBase=' + dbNameR.Text);
Conn.Params.Add('User_name=' + userNameR.Text);
Conn.Params.Add('Password=' + passwordR.Text);
Conn.Params.Add('Server Port=' + portR.Text);
Conn.Params.Add('BlobSize=-1');
Conn.Params.Add('FetchAll=True');
Conn.Params.Add('LongStrings=True');
Conn.Params.Add('DetectParamTypes=True');
Conn.Open;
The following error occurs: SQL Server Error: Invalid value for parameter "cliente_encoding": "Win1252"
----------
follow my settings
Postgres version: 9.3
Driver Devart: latest version
Delphi 7
show client_encoding = WIN1252
show server_encoding = UTF8
database accessed: ENCODING = 'LATIN1'
Conn.Params.Add ('client_encoding = LATIN1'); Does not work????
*** Portuguese to English via google translator