Page 1 of 1

PostgreSQL - WSAGetLastError return 10054($2746)

Posted: Tue 09 Oct 2012 15:55
by eduardomendes
Hi,

when trying connect to the PostgreSQL server occurs error.

-------------------------------------------------------------------------------------------------------------------
Cannot connect to database. Socket error on read. WSAGetLastError return 10054($2746).
-------------------------------------------------------------------------------------------------------------------
Call Stack Information:
-------------------------------------------------------------------------------------------------------------------
|Address |Module |Unit |Class |Procedure/Method |Line |
-------------------------------------------------------------------------------------------------------------------
|Running Thread: ID=14868; Priority=0; Class=; [Main] |
|-----------------------------------------------------------------------------------------------------------------|
|0026C5C8|unidac70.bpl |Uni.pas |TUniConnection |DoConnect | |
|02D196E0|pgprovider70.bpl |Pgclassesuni.pas |TPgSQLConnection |ProcessInternalException | |
|75C7E50D|KERNELBASE.dll | | |VirtualQueryEx | |
|7757012E|ntdll.dll | | |KiUserExceptionDispatcher| |
|400065B4|rtl70.bpl |System.pas | |_RaiseExcept | |
|02D0994F|pgprovider70.bpl |Pgsqlnetuni.pas |TPgSQLNet |VioRead | |
|02D0991C|pgprovider70.bpl |Pgsqlnetuni.pas |TPgSQLNet |SetVio | |
|02D09A23|pgprovider70.bpl |Pgsqlnetuni.pas |TPgSQLNet |UpdateReadBuffer | |
|02D09A00|pgprovider70.bpl |Pgsqlnetuni.pas |TPgSQLNet |UpdateReadBuffer | |
|02D09A3F|pgprovider70.bpl |Pgsqlnetuni.pas |TPgSQLNet |CheckReadBuffer | |
|02D09A30|pgprovider70.bpl |Pgsqlnetuni.pas |TPgSQLNet |CheckReadBuffer | |
|02D09D1D|pgprovider70.bpl |Pgsqlnetuni.pas |TPgSQLNet |ReadByte | |
|02D09D18|pgprovider70.bpl |Pgsqlnetuni.pas |TPgSQLNet |ReadByte | |
|02D09FF5|pgprovider70.bpl |Pgsqlnetuni.pas |TPgSQLNet |ReadChar | |
|02D09FF0|pgprovider70.bpl |Pgsqlnetuni.pas |TPgSQLNet |ReadChar | |
|02D06BE0|pgprovider70.bpl |Pgsqlprotocoluni.pas |TPgSQLProtocol |ProcessMessageQueue | |
|02D059F8|pgprovider70.bpl |Pgsqlprotocoluni.pas |TPgSQLProtocol |Connect | |
|02D18E54|pgprovider70.bpl |Pgclassesuni.pas |TPgSQLConnection |ReturnToPool | |
|02D19129|pgprovider70.bpl |Pgclassesuni.pas |TPgSQLConnection |Connect | |
|02A9FED9|dac70.bpl |Dbaccess.pas |TCustomDAConnection |DoConnect | |
|02A9FE18|dac70.bpl |Dbaccess.pas |TCustomDAConnection |DoConnect | |
|0026C5B4|unidac70.bpl |Uni.pas |TUniConnection |DoConnect | |
|0026C584|unidac70.bpl |Uni.pas |TUniConnection |DoConnect | |
-------------------------------------------------------------------------------------------------------------------

How can I fix this problem?

Thanks.

Re: PostgreSQL - WSAGetLastError return 10054($2746)

Posted: Fri 12 Oct 2012 11:28
by ZEuS
Unfortunatelly, we can not reproduce the problem.
Please, specify the exact version of UniDAC and PostgreSQL you are using.
Also, please try the following approaches in order to avoid the error:
- if you have a firewall on you computer, try to temporarily disable the firewall and check if the problem persists;
- try to connect to the server using the different version of the PostgreSQL protocol (change the ProtocolVersion option in the TUniConnection.SpecificOptions property).