DbGeography.FromText - Unable to load DLL 'SqlServerSpatial140.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)

Question

I have tried to copy spatial140 from packages folder "\packages\Microsoft.SqlServer.Types...\nativeBinaries", in Visual Studio build is a success, not found some error.

But when run the project, I got that error.

Jiale Xue - MSFT · Accepted Answer · 2022-01-27T08:55:22.467

1

Try to Change the status of `spatial140.dll` to `Copy if new`and`Content`.

edited Jan 27 '22 at 08:55

answered Jan 27 '22 at 05:30

Jiale Xue - MSFT

3,560
1
6
21

This can't work for me. But I have solved the issues, must copy spatial140.dll to bin folder. – Iqbal Fasyah Jan 27 '22 at 07:18
Sure, thank you. Sorry for late the notice. – Iqbal Fasyah Jan 29 '22 at 12:40

score 0 · Answer 2 · answered Jan 27 '22 at 07:19

0

I know this is bad, but I have solved the issues, must copy spatial140.dll to bin folder.

answered Jan 27 '22 at 07:19

Iqbal Fasyah

85
1
1
8

Instead of posting the same answer as the other person, I suggest you to accept it :) – Elikill58 Jan 27 '22 at 10:07

DbGeography.FromText - Unable to load DLL 'SqlServerSpatial140.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)

2 Answers2

Try to Change the status of spatial140.dll to Copy if newandContent.

Try to Change the status of `spatial140.dll` to `Copy if new`and`Content`.