world map and errors loading map for VS 2022

Question

Post reply

world map and errors loading map for VS 2022

Jason Wilks

Old Hand

Points: 389
More actions
September 5, 2022 at 8:40 pm

#4084149
[Updated 9/6/22]
What is the easiest way to get a world map into the map gallery so that I can embed into my report? I look at this shape to sql tool, but the download is no longer available.
https://www.sharpgis.net/page/shape2sql
Also, Using Visual Studio 2022. Any map I load from the map gallery (US only maps there), I get an error when previewing the report:
"An attempt was made to load a program with an incorrect format (Exception from HRESULT 0x80070000B)."
I searched through the VS developer forums and didn't find a specific solution, but there are several related issue on this error message and seems like the solution is about getting VS 2022 to run 32-bit enabled. But the posts are so old that the solutions no longer apply.
Anyone out there run into this issue? I posted a topic on the developer forum and will update this thread if I find out anything helpful.
- This topic was modified 2 years, 2 months ago by Jason Wilks.
- This topic was modified 2 years, 2 months ago by Jason Wilks.
- This topic was modified 2 years, 2 months ago by Jason Wilks.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004323 More actions · Answer 1

Why not reach out to the author of that article?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

izhar-azati SSC Veteran Points: 214 More actions · Answer 2

see https://sqljason.com/2012/03/adding-maps-to-ssrs-map-gallery.html

Jeff Moden SSC Guru Points: 1004323 More actions · Answer 3

Jason Wilks wrote:

[Updated 9/6/22]
What is the easiest way to get a world map into the map gallery so that I can embed into my report?
Also, Using Visual Studio 2022. Any map I load from the map gallery (US only maps there), I get an error when previewing the report:
"An attempt was made to load a program with an incorrect format (Exception from HRESULT 0x80070000B)."
I searched through the VS developer forums and didn't find a specific solution, but there are several related issue on this error message and seems like the solution is about getting VS 2022 to run 32-bit enabled. But the posts are so old that the solutions no longer apply.
Anyone out there run into this issue? I posted a topic on the developer forum and will update this thread if I find out anything helpful.

Why did you remove the link to the original article you were referencing? That was actually a helpful link for those searching for the same thing and landing on your question.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jason Wilks Old Hand Points: 389 More actions · Answer 4

Jeff,

oh sorry I mistakenly took that link out when I edited it for the error message. Which makes this thread no longer makes sense. And I should have created a new post for the error. I re-edited and I contacted the author but haven't heard back yet...

Jeff Moden SSC Guru Points: 1004323 More actions · Answer 5

Jason Wilks wrote:

Jeff,
oh sorry I mistakenly took that link out when I edited it for the error message. Which makes this thread no longer makes sense. And I should have created a new post for the error. I re-edited and I contacted the author but haven't heard back yet...

Considering your credentials in your signature line, do you have a blog titled SQLJason?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jason Wilks Old Hand Points: 389 More actions · Answer 6

No, not me. I am an old school developer, working mostly with Oracle in the 90's until 2007 and then retired. And recently decided to switch back to IT after a > 10 year hiatus. My how things changed. So I figured, while beginning the process of resharpening my skills, I should get some certification to back up my plan to return to the workforce.

Jeff Moden SSC Guru Points: 1004323 More actions · Answer 7

Welcome back and good to "meet" you.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

izhar-azati SSC Veteran Points: 214 More actions · Answer 8

Install QGIS and use ogr2ogr utility to load the SHAPE file to SQL server:

ogr2ogr --debug ON -f "MSSQLSpatial" "MSSQL:server=.;database=GovilLoad;trusted_connection=yes" "PARCEL_ALL\PARCEL_ALL.shp" -a_srs "EPSG:2039" -overwrite -unsetFieldWidth -progress --config MSSQLSPATIAL_USE_BCP FALSE

for me the BCP (Bulk Copy) not working!

some version don't import all the length of text fields. (if the text is Hebrew in the DBF).

Jeff Moden SSC Guru Points: 1004323 More actions · Answer 9

izhar-azati wrote:

Install QGIS and use ogr2ogr utility to load the SHAPE file to SQL server:
ogr2ogr --debug ON -f "MSSQLSpatial" "MSSQL:server=.;database=GovilLoad;trusted_connection=yes" "PARCEL_ALL\PARCEL_ALL.shp" -a_srs "EPSG:2039" -overwrite -unsetFieldWidth -progress --config MSSQLSPATIAL_USE_BCP FALSE
for me the BCP (Bulk Copy) not working!
some version don't import all the length of text fields. (if the text is Hebrew in the DBF).

You might want to ask the "Jason" (SQLJason, form what I see in the post) for help on that subject. Apparently, he would know the data better than the rest of us.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)