[mapguide-users] ODBC problems....MGOS 2.0

[Andrew DeMerchant]

Ah! I had to change the MG Server service to run on the correct 
account.....though, I DID (prior to that) try (and fail) to enter the 
correct credentials right in the provider settings. anyway, that did 
it.....now on to the next problem:

How the heck am I supposed to actually _make_ a new ODBC connection?? In 
Autodesk Studio, I can at least now see my tables, and select which 
fields to use as the geometry fields (not so in MapStudioOS) - but when 
I try to save it, I get the following:



I'd do it in MapStudioOS, but there doesn't seem to be a place to pick 
my x and y columns...And we all know that WebStudio's not so useful for 
this either....This "upgrade" to 2.0 sure is starting to feel like a bad 
idea.

Andrew


Dave Wilson wrote:
>
> The database connections are compatible and should work. Reasons why 
> they might not work:
>
>  
>
> When using connection strings the ODBC driver name is different 
> between the machines or does not match the string. The DSN names are 
> not the same or do not exist.
>
>  
>
> Are the databases local to the server? If not did you change your MG 
> server process to use an account with network access?
>
>  
>
> Regards,
>
> Dave
>
>  
>
> *From:* mapguide-users-bounces at lists.osgeo.org 
> [mailto:mapguide-users-bounces at lists.osgeo.org] *On Behalf Of *Andrew 
> DeMerchant
> *Sent:* Thursday, April 10, 2008 8:44 AM
> *To:* MapGuide Users Mail List
> *Subject:* [mapguide-users] ODBC problems....MGOS 2.0
>
>  
>
> I'm trying to start to migrate to MGOS 2.0 (from 1.0.2)....I've got a 
> test machine running MGOS 2.0 right now, and am testing out just 
> moving my packages from my production server to my test server. Not 
> surprisingly, any dataconnections I had set up on my production server 
> stop working on my dev server - I assume because they were made using 
> FDO 3.1, while MGOS 2 uses FDO 3.2 (it'd be awfully nice if the FDO 
> people would make things backwards compatible). Anyway, I fully 
> expected those to break (along with my Raster layers).
>
> I've hit a wall in trying to get them (my ODBC datasources) set up 
> again. I've tried in Autodesk Studio, I've tried in MapStudioOS - 
> neither are working. They both give me an error that is the same - "An 
> exception occurred in FDO component. RDBMS: No current open 
> database."....I've tried custom connection strings and DSN (which is 
> my preferred method). Same result for both. I did successfully connect 
> to an SQL server I have onsite, but that's not where my data is. That 
> suggests to me the the problem may be with my database format - which 
> is Jet (MS Access). What the solution here? If all else fails, is it 
> an option for me to install FDO3.1 with MGOS2?
>
> Andrew
>
> -- 
>
> 	
>
> *Andrew DeMerchant*
> *Computer Technologist*
> ph.1-877-2GEMTEC x.163
> fax 506-453-9470
>
> /GEMTEC Limited <http://www.gemtec.ca>
> /191 Doak Road
> Fredericton, NB, Canada
> E3C 2E6
>
>  
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>   

-- 
	*Andrew DeMerchant*
*Computer Technologist*
ph.1-877-2GEMTEC x.163
fax 506-453-9470

/GEMTEC Limited <http://www.gemtec.ca>
/191 Doak Road
Fredericton, NB, Canada
E3C 2E6

-------------- next part --------------
Skipped content of type multipart/related