AutoCAD Map 3D General Discussion

AutoCAD Map 3D General Discussion

Reply
Distinguished Contributor
106 Posts
4 Kudos
Registered: ‎09-25-2007
Post 1 of 7
Accepted Solution

Map 2012 SP1 - SQL Server Connection

538 Views, 6 Replies
11-25-2011 09:27 AM

Since installing SP1for 2012 I've noticed a significant degradation in performance when connecting to non-spatial SQL Server tables using the FDO OBDC connection. Simply connecting to the database now takes several (20-30?) minutes during which time Map is totally unresponsive, and i can forget about trying to do a join to one of the tables once the connection is made. I tried it yesterday, letting it go for a few hours before finally forcing Map shut at the end of the day.

I'm trying to get a sense of whether or not it is something broken with Map in general, or if it is more likely related to either my installation or changes in the DBs to which I'm connecting. So, has anyone else noticed anyting similar since installing the service pack?

I had better follow up on myself.

This morning I put the SP1 version of the aforementioned dll's back into my FDO folder and tried all of this again, only this time the SQL connection and join went fine. So I'm going to close out this thread by saying I think there were other issues at play causing problems with the databases I was trying to connect to, and the service pack files are fine.

 

Thanks for your responses everyone.

Valued Mentor
434 Posts
74 Kudos
Registered: ‎10-10-2003
Post 2 of 7

Re: Map 2012 SP1 - SQL Server Connection

11-26-2011 01:47 PM in reply to: Gary_Braun

Yes, I have noticed this for all FDO ODBC (mostly SQL Server).

 

I create a new database and create views to the original data so that Map does not need to enumerate all the non-used tables in the rest of the database.

 

Active Contributor
48 Posts
1 Kudo
Registered: ‎03-02-2011
Post 3 of 7

Re: Map 2012 SP1 - SQL Server Connection

11-29-2011 01:04 AM in reply to: Gary_Braun

That's quite serius issue - I think. I haven't updated it yet and I'm not goint to yet :smileytongue:

 

Distinguished Contributor
106 Posts
4 Kudos
Registered: ‎09-25-2007
Post 4 of 7

Re: Map 2012 SP1 - SQL Server Connection

11-29-2011 09:03 AM in reply to: Gary_Braun

This morning I went through my ...\Map3D2012\bin\FDO folder to see which files were updated by the service pack. I focused on what I thought were the five most likely culprits for the specific problem I was having, backed them up then replaced them with the original version of the files that were first shipped with Map 2012.

 

I then was able to connect to my SQL Server non-spatial database in about a minute, and was able to do a join between my SDF feature and my SQL Server table afterwards in about 10-seconds. I can't say this is definitive proof that Autodesk has botched one or all of these files in the service pack, but it has made a remarkable difference in my case.

 

The files I replaced are:

ODBCOverrides.dll

ODBCProvider.dll

RdbmsOverrides.dll

SqlServerOverrides.dll

SqlServerProvider.dll

 

Am I the only one experiencing this then?

Valued Mentor
434 Posts
74 Kudos
Registered: ‎10-10-2003
Post 5 of 7

Re: Map 2012 SP1 - SQL Server Connection

11-29-2011 09:37 AM in reply to: Gary_Braun

Hi,

the DLLs that are tied to the SQL Server Spatial Connection (FDO 3.6):

 

OSGeo.FDO.Providers.Rdbms.Overrides.dll
OSGeo.FDO.Providers.SQLServerSpatial.Overrides.dll
RdbmsMsg.dll
RdbmsOverrides.dll
SQLServerSpatialOverrides.dll
SQLServerSpatialProvider.dll
SmMessage.dll

 

You may also consider getting them from fdo.osgeo.org as well.  

 

gordon

 

 

ps. You could always grab them from FDOToolbox from Jackie's build: 

http://code.google.com/p/fdotoolbox/source/browse/trunk/Thirdparty/Fdo_x64/

 

ps.  Also, SQL Server Provider is a bit of a pain compared to the Oracle Provider - it needs a schema filter for non-native or non SQL Server F_* tables

 

 

Active Contributor
48 Posts
1 Kudo
Registered: ‎03-02-2011
Post 6 of 7

Re: Map 2012 SP1 - SQL Server Connection

11-29-2011 04:09 PM in reply to: gluckett

O Boze! ....... That's way beyond me!

 

Map 2012 without SP1 doesn't sound that bad after all :smileywink:

I think I may wait for SP2 :smileyhappy:

Distinguished Contributor
106 Posts
4 Kudos
Registered: ‎09-25-2007
Post 7 of 7

Re: Map 2012 SP1 - SQL Server Connection

12-02-2011 08:40 AM in reply to: Gary_Braun

I had better follow up on myself.

This morning I put the SP1 version of the aforementioned dll's back into my FDO folder and tried all of this again, only this time the SQL connection and join went fine. So I'm going to close out this thread by saying I think there were other issues at play causing problems with the databases I was trying to connect to, and the service pack files are fine.

 

Thanks for your responses everyone.

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Are you interested in helping shape the future of the Autodesk Community? To participate in this brief usability study, please click here. Your time and input is greatly appreciated!