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

Thu Apr 10 16:16:54 EDT 2008

I'm hoping it will be complete within the next week, but it's not a 
promise :)

Regards, Kenneth, GEOGRAF A/S


Andrew DeMerchant skrev:
> I don't have access to that - so I'll wait. How long till you release 
> that? I know that's a tough question, but are we talking days, weeks 
> or months?
>
> Andrew
>
>
> Kenneth, GEOGRAF A/S wrote:
>> 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
>>>   
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> 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