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

[Andrew DeMerchant]

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

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