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

[Kenneth, GEOGRAF A/S]

I have added the column stuff to MapStudio OS, but I have not yet built 
a new release.
If you have access to a Visual Studio 2003 (or newer) it should be no 
problem to build one yourself.
I am currently building an browser for unmanged resources, and I will 
release it after that.

Regards, Kenneth, GEOGRAF A/S



Andrew DeMerchant skrev:
> 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
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>   
-------------- next part --------------
Skipped content of type multipart/related