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

Thu Apr 10 18:07:27 EDT 2008

That's cool - just looking for some rough idea. Thanks - That program is 
getting really really close to doing everything that Autodesk's does 
(only better and faster). The only other thing it needs to do is to let 
you add tools and customize the toolbars etc in a weblayout, then it'll 
be a perfect replacement.

Andrew

Kenneth, GEOGRAF A/S wrote:
> 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
>>   
> ------------------------------------------------------------------------
>
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>   