[mapguide-users] Mapguide 64 bit and ODBC 64

[Gord McKenzie]

I have tried to adjust ODBC settings, definitely not a tracing issue.  Access is my only choice at this moment but I am open to SQL Server as we use it for some other things.  I have not filed any bug reports. I have only managed to cobble together a very basic test.  I'm not personally confident that my test is definitive enough to say for sure that this is a bug.

Interesting that Microsoft is planning on phasing out OLE DB in favour of ODBC for SQL Server.  http://tdwi.org/Articles/2012/03/27/SQL-Server-2012-End-of-Era.aspx?Page=1

Thanks for the feedback.

Gordon McKenzie
GIS Coordinator
[cid:image004.jpg at 01CECEF6.333C2760]
T: 403.269.8887 / 1.800.478.6162
E: Gord.Mckenzie at canam.com    canam.com<http://www.canam.com/>
900, 340 - 12th Avenue SW Calgary, AB T2R 1L5

From: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Andrew DeMerchant
Sent: Tuesday, October 22, 2013 6:21 AM
To: MapGuide Users Mail List
Subject: Re: [mapguide-users] Mapguide 64 bit and ODBC 64

I don't know that that's a solution - it's definitely a workaround though. I'm not sure if you can set OBDC settings/options from MGOS, but if you can, you might try this (in a nutshell, disabling "when to trace"):

http://answers.microsoft.com/en-us/office/forum/office_2010-access/my-solution-to-access-being-slow-with-odbc/a5a6522f-a70f-421e-af1b-48327075e010

I guess the question would be, is this an MGOS problem, or is it an ODBC (MS) problem? If changing the setting above makes the difference, then we've got our answer.


On 13/10/22 9:05 AM, Martin Morrison wrote:
Perhaps the solution may be to use SQL Server, Oracle or MySQL.  Access hasn't been a super big upgrade on Microsoft's plate.

Martin Morrison
Application Engineer
Engineering Design Systems, Inc.
3780 Peters Creek Rd Ext SW
Roanoke, VA  24018
540.345.1410
gis.edsi.com

From: mapguide-users-bounces at lists.osgeo.org<mailto:mapguide-users-bounces at lists.osgeo.org> [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Andrew DeMerchant
Sent: Tuesday, October 22, 2013 7:51 AM
To: MapGuide Users Mail List
Subject: Re: [mapguide-users] Mapguide 64 bit and ODBC 64

I'd been trying to decided if this was the version that I should finally make the x64 switch, but it sounds like it's not, I guess. Here's hoping that someone has the time to delve into this and see if it can be fixed for the next release! Have you filed a bug for this officially?


On 13/10/21 5:30 PM, gom wrote:

It has taken some time to get here but I can say that I was able to install

and configure a 32 bit version of Mapguide 2.51 and the performance of the 3

affected data sources is double or better.  That is to say, using 32 bit

Mapguide and 32 bit Access ODBC driver works more than twice as fast as 64

bit.







--

View this message in context: http://osgeo-org.1560.x6.nabble.com/Mapguide-64-bit-and-ODBC-64-tp5082718p5084884.html

Sent from the MapGuide Users mailing list archive at Nabble.com.

_______________________________________________

mapguide-users mailing list

mapguide-users at lists.osgeo.org<mailto:mapguide-users at lists.osgeo.org>

http://lists.osgeo.org/mailman/listinfo/mapguide-users

--
________________________________
[GEMTEC   Limited]<http://www.gemtec.ca/>

Andrew DeMerchant

tel: 506.453.1025  /  toll-free: 1.877.243.6832
fax: 506.453.9470





_______________________________________________

mapguide-users mailing list

mapguide-users at lists.osgeo.org<mailto:mapguide-users at lists.osgeo.org>

http://lists.osgeo.org/mailman/listinfo/mapguide-users

--
________________________________
[GEMTEC              Limited]<http://www.gemtec.ca/>

Andrew DeMerchant

tel: 506.453.1025  /  toll-free: 1.877.243.6832
fax: 506.453.9470
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapguide-users/attachments/20131022/1a1511db/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 3987 bytes
Desc: image003.png
URL: <http://lists.osgeo.org/pipermail/mapguide-users/attachments/20131022/1a1511db/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.jpg
Type: image/jpeg
Size: 2392 bytes
Desc: image004.jpg
URL: <http://lists.osgeo.org/pipermail/mapguide-users/attachments/20131022/1a1511db/attachment.jpg>