November 12, 2010 at 9:11 am
I'm trying to learn more about the geospatial types in SQL Server 2008. I found an application called Shape2SQL from SharpGIS (http://www.sharpgis.net/page/SQL-Server-2008-Spatial-Tools.aspx). I also found some sample shape files from VDS Technologies (http://www.vdstech.com/map_data.htm). So far so good. I'm attempting to use the application to upload the data. The application doesn't show any errors but the tables it should create do not exist. If I take the sql in the trace and run it, it works.
I checked the other databases just to make sure they didn't get create there and there were none. I pulled up profiler and ran a trace and I can see the statement where the table gets created and the inserts to load the data. There are a few errors like error 6522 and error 12013.
Can someone recommend some other options in the trace I can use to trap why it's not actually creating those objects?
J.D.
EDIT: Let me also add that this is an exercise in troubleshooting so I looking for what I can do to help me find the root of the problem. The SQL Server is running on a VM using Amazon's EC2 platform. Very cool stuff BTW;)
November 12, 2010 at 9:52 am
Figured it out! The application was sending a begin trans but not commit. I changed some parameters in the application and it worked. So somewhere in the app there appears to be a bug.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply