Why not just avoid the hassles and use a real database? MS SQL, MySQL, Oracle, etc... All of these have free versions that would be far more robust.
Martin Morrison Application Engineer Engineering Design Systems, Inc. 3780 Peters Creek Rd Ext SW Roanoke, VA 24018 540.345.1410 gis.edsi.com -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Von Barth, Peter Sent: Thursday, May 12, 2011 8:21 AM To: MapGuide Users Mail List Subject: SV: [mapguide-users] Re: ODBC Connection Yes I installed the 64-bit version. I had to rollback the 2.2 installation. And before I try it again I need a few clarifications. In your blog you mention that in office 2010 odbc drivers... we have 2007 installed in the office. Does it still apply? Alongside Meastro3 I also have MapGuideStudio 2009 and here it´s possible to chose to connect to (*.mdb) which gives me a connection string like: Driver={Microsoft Access Driver (*.mdb)};Dbq=%MG_DATA_FILE_PATH%ABB_stationer.mdb;Uid=;Pwd=; Or (*.mdb,*.accdb) giving me Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=%MG_DATA_FILE_PATH%ABB_stationer.mdb;Uid=;Pwd=; This didn't work. Do I need to install the 64-bit drivers for Micrsoft Access Databases on my machine where MapGuide is running? Will that help? Or do I need a complete office installation, which I don't have? /Peter -----Ursprungligt meddelande----- Från: [email protected] [mailto:[email protected]] För Jackie Ng Skickat: den 12 maj 2011 12:45 Till: [email protected] Ämne: [mapguide-users] Re: ODBC Connection Did you install the 64-bit version of MapGuide? If so, you have to tweak the connection string (either via the XML Editor, or by the RawConnectionString mode in the ODBC editor) so that it uses the Microsoft Access 2010 ODBC drivers. Maestro can't do this automatically for you because there's no way currently to determine the "bit-ness" of the MapGuide Server it's connecting to. More info on my blog: http://themapguyde.blogspot.com/2010/07/connecting-to-ms-access-databases-with.html As for the Unmanaged sub-editor not working in Maestro 3? Yeah that is a defect which I'll look into. - Jackie -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/ODBC-Connection-tp6355171p6355267.html Sent from the MapGuide Users mailing list archive at Nabble.com. _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
