Home

Connecting to PostgreSQL no longer works in Excel 2016

%3CLINGO-SUB%20id%3D%22lingo-sub-707573%22%20slang%3D%22en-US%22%3EConnecting%20to%20PostgreSQL%20no%20longer%20works%20in%20Excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-707573%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20have%20previously%20connected%20to%20a%20PostgreSQL%20database%20using%20Excel%202016%20(32%20bit)%20and%20the%20npgsql%20.NET%20connector%20-%20this%20was%20working%20fine%20until%20recently.%20Now%20when%20attempting%20to%20connect%2C%20it%20hangs%20after%20the%20first%20dialog%20(i.e.%20after%20entering%20the%20ip%20address%20and%20database%20name%20and%20clicking%20Next).%20I%20can%20cancel%20to%20return%20to%20the%20workbook%2C%20but%20I%20can't%20connect%20to%20the%20datasource.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-707573%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
PaulTreadaway
New Contributor

Hi,

 

We have previously connected to a PostgreSQL database using Excel 2016 (32 bit) and the npgsql .NET connector - this was working fine until recently. Now when attempting to connect, it hangs after the first dialog (i.e. after entering the ip address and database name and clicking Next). I can cancel to return to the workbook, but I can't connect to the datasource.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies