dll loading error (randomly)

[marcomezzanotte]

Hi, we're randomly experiencing the following error:

Unable to load DLL 'PgCPP.DLL.9.x.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E) - at Npgsql.BulkCopy.Native.Versions.PQ9xNativeApi.openRemoteConn(Char hostaddr, Int32 port, Char dbname, Char user, Char password) at Enerj.CDV.Data.DataManagerBase1.InsertBulk(DataTable DT_Tabella)
at Enerj.CDV.Data.DataManager.IndicizzaDocumentInstance(List1 ListID, Int64 IDInstance) at Enerj.CDV.ControlsService.Manager.StartProcess()

The library is used in a Windows Service and the error shows after deploy and installation, while everything works fine in Visual Studio. On the server where we deploy the service, we've installed the Visual C++ Redistributable.

We hope you can give us a hint or a solution for this problem.

Thank you.

[uzbekdev1]

Hi!
Okay I'll tomorrow look it

[uzbekdev1]

which version your PG ? 9.5 or 9.4?
Need to update from C:\Program Files\PostgreSQL\9.5 folder lib & dll's

[marcomezzanotte]

Sorry but I don't understand.

When I download the Nuget package, a folder named lipqdll with the following structure is downloaded and what I do is to copy the whole folder structure and contents to the service deployed root folder.

Am I wrong?
What am I supposed to do exactly?

[nonoantog]

I have the same problem. My postgres instance is on linux server.

[nicusorserban]

How we can get past this error?
I've tried to compile the .DLL but it gives me countless errors ...

[screig]

Same issue, note im running under Net Core

[uzbekdev1]

Ok, looking today.End of this week I pushed a new version.

[Steven-FlexTechs]

I have the exact same error. I am using PG 9.5. It all works fine for my unit test project.

I get the Unable to load DLL 'PgCPP.DLL.9.x.dll': The specified module could not be found. error for my MVC web project. Same computer, same database.

I tried adding the lipqDLL folder to the bin folder which worked for my Unit Test project. Did not work still.

I wish the error said the expected directory too so I know where to put the dlls: Unable to load DLL 'C:/Project Folder/bin/PgCPP.DLL.9.x.dll': The specified module could not be found.

[uzbekdev1]

Hi! Thank you for your replying. Last 2 week I have many works because I don't have nay time. This week I can be looked.

…

On Wed, May 31, 2017 at 3:30 AM, Steven-FlexTechs ***@***.***> wrote: I have the exact same error. I am using PG 9.5. It all works fine for my unit test project. I get the Unable to load DLL 'PgCPP.DLL.9.x.dll': The specified module could not be found. error for my MVC web project. Same computer, same database. I tried adding the lipqDLL folder to the bin folder which worked for my Unit Test project. Did not work still. I wish the error said the expected directory too so I know where to put the dlls: Unable to load DLL 'C:/Project Folder/bin/PgCPP.DLL.9.x.dll': The specified module could not be found. — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#1 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AEUjL-CvexTXjqQqrLgpVZ1Th9A201Hnks5r_JiJgaJpZM4IaPo1> .

[officer-rosmarino]

Same problem here, but for me it doesn't work even on Visual Studio.

[screig]

I fixed it, I will make a pull request today to merge

I also then want to go on and use costura to embedded the C++ dlls in the Net assembly

[officer-rosmarino]

@screig waiting for it, thanks

[screig]

Ok I have reworked the code base quite a bit

forked version

The C++ projects had hard-coded links to specific installed versions of Postgres. I have made all the C++ projects use relative paths. I also went and tried to go and find the required references, namely the lib and include files for the following versions:

• 9.x x86
• 9.x x64
• 8.x x86
• 8.x x64 (this one I could not find)

I included this data in the code base (bar 8.x x64). I rebuilt the C++ projects which regenerated the missing dlls and copied them over to the C# folder.

[officer-rosmarino]

@screig could you please point out where you did the changes?

[screig]

sorry it is still uploading...

[uzbekdev1]

Thank you!

[screig]

Ok its in

[screig]

If anybody can find the x64 version of the postgres binaries I can add them in

[uzbekdev1]

thanks🤗

…

On Wed, May 31, 2017 at 4:39 PM, Sean ***@***.***> wrote: If anybody can fix the x64 version of the postgres binaries I can add them in — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#1 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AEUjL9tAzOGh6CmxQutsZuwXD0WgL57Nks5r_VFwgaJpZM4IaPo1> .