[mapguide-users] Access database - Studio 2007 preview

[Andrew DeMerchant]

I'm not sure why I didn't try that on my own, but it worked! I wonder 
why it didn't work from my server though? In the end (for me), it 
doesn't matter much, since my server will ultimatly have mapguide and 
the database both. Thanks Juan!

Andrew


Butler, Juan P wrote:

> Can you move the db locally and test it out?
>
>  
>
> FYI:  My database is local on my PC with Studio and Server.
>
>  
>
> - Juan
>
>  
>
> ------------------------------------------------------------------------
>
> *From:* Andrew DeMerchant [mailto:andrew.demerchant at gemtec.ca]
> *Sent:* Friday, April 21, 2006 4:01 PM
> *To:* users at mapguide.osgeo.org
> *Subject:* Re: [mapguide-users] Access database - Studio 2007 preview
>
>  
>
> The database is not local....but is on a mapped network drive (so it 
> has a fixed drive letter). The DSN is on my own development PC (which, 
> like I said, is working fine for my other webpages), as is MapGuide 
> and Studio. I also have about 4 other Autodesk products installed on 
> my pc (Land Desktop 2004, Raster Design 2004, Civil Design 2004, and 
> Survey 2004).
> In the end (once I finish the development) everything will end up on 
> the same server, and it will not have any other Autodesk apps installed.
>
> Andrew
>
> Jason Birch wrote:
>
> Are your Access database, the DSN, and the MapGuide Service all on the 
> same computer?  Is Studio on the same computer as the MapGuide Service?
>
>  
>
> Do you have any other Autodesk applications loaded on either the 
> client or the server?
>
>  
>
> Jason
>
>  
>
> ------------------------------------------------------------------------
>
> *From:* Andrew DeMerchant [mailto:andrew.demerchant at gemtec.ca]
> *Sent:* Friday, April 21, 2006 12:45
> *To:* users at mapguide.osgeo.org <mailto:users at mapguide.osgeo.org>
> *Subject:* Re: [mapguide-users] Access database - Studio 2007 preview
>
> Ok, I've got the one from myfeedback installed now....still the same 
> problem. Which suggests that there's something else going on here. My 
> datasource works fine, because I'm using it in other vbscript 
> webpages. There's got to be something that I'm missing here.....could 
> it have anything to do with Studio needing some special ntfs permissions?
>
> Andrew
>
> Butler, Juan P wrote:
>
> Access 2000.    
>
> Did you download it from the myfeedback site?  If not, try downloading 
> it from there.  
>
> - Juan
>
> ------------------------------------------------------------------------
>
> *From:* Andrew DeMerchant [mailto:andrew.demerchant at gemtec.ca]
> *Sent:* Friday, April 21, 2006 12:36 PM
> *To:* users at mapguide.osgeo.org <mailto:users at mapguide.osgeo.org>
> *Subject:* Re: [mapguide-users] Access database - Studio 2007 preview
>
> Sounds like the same version I'm using....what type of database was yours?
>
> Andrew
>
> Butler, Juan P wrote:
>
>
> I'm using version 1.0.0.16802.   Mapguide Studio 2007.
>
> I downloaded it from the http://myfeedback.autodesk.com/ site.  
>
> - Juan
>
> ------------------------------------------------------------------------
> size=2 width="100%" align=center tabindex=-1>
>
> *From:* Andy Morsell [mailto:amorsell at spatialgis.com]
> *Sent:* Friday, April 21, 2006 12:25 PM
> *To:* users at mapguide.osgeo.org <mailto:users at mapguide.osgeo.org>
> *Subject:* RE: [mapguide-users] Access database - Studio 2007 preview
>
> That was me using the Studio beta version rather than preview.  Juan, 
> I know you got this working, are you using the preview version of 
> Studio downloaded from the public web site?
>
> Andy Morsell, P.E.
> Spatial Integrators, Inc.
> http://www.SpatialGIS.com  
>
> ------------------------------------------------------------------------
>
> *From:* Andrew DeMerchant [mailto:andrew.demerchant at gemtec.ca]
> *Sent:* Friday, April 21, 2006 9:20 AM
> *To:* users at mapguide.osgeo.org <mailto:users at mapguide.osgeo.org>
> *Subject:* Re: [mapguide-users] Access database - Studio 2007 preview
>
> I'm referring to one that I posted about maybe a week ago.....I can't 
> get any ODBC datasource to actually work in Studio....I see the 
> datasources fine, but never see a list of table / fields, and when I 
> test my connection, it fails. The concensus seemed to be that it was 
> the Studio Preview, because someone else did the exact same steps, and 
> it worked....the only difference was our Studio versions (his was the 
> full).
>
> Andrew
>
> Butler, Juan P wrote:
>
>
>
> Andrew,
>
> Which ODBC problem are you referring to?   The two issues that I 
> brought up yesterday were the highlighting of a selection doesn't work 
> on a joined layer and the refresh issue.   Are these what you are 
> referring to?  
>
> - Juan
>
> ------------------------------------------------------------------------
>
> *From:* Andrew DeMerchant [mailto:andrew.demerchant at gemtec.ca]
> *Sent:* Friday, April 21, 2006 9:45 AM
> *To:* users at mapguide.osgeo.org <mailto:users at mapguide.osgeo.org>
> *Subject:* [mapguide-users] Access database - Studio 2007 preview
>
> I'm using Studio 2007 (preview) v1.0.0.16802.....Is the ODBC problem 
> to do with this version of Studio, or the OSGeo FDO Provider for ODBC? 
> I've got a project that I need to get done in 1 month, and am trying 
> to figure out if it's going to happen or not. With my current setup, I 
> can't get any of my Access ODBC datasources to work....no one has 
> suggested a workaround as of yet, so I'm starting to think that it's 
> just not going to happen. Does the solution have to come from Autodesk 
> (a new Studio version), or OSGeo (a new Provider? I would tend to 
> think that Autodesk would be slower than OSGeo, so that's why I'm 
> wondering.....Thanks.
>
> Andrew
>
> -- 
>
> 	
>
> *Andrew DeMerchant*
> *Computer Technologist*
> ph.506-453-1025
> fax 506-453-9470
>
> /GEMTEC Limited <http://www.gemtec.ca>
> /191 Doak Road
> Fredericton, NB, Canada
> E3C 2E6
>
> -- 
>
> 	
>
> *Andrew DeMerchant*
> *Computer Technologist*
> ph.506-453-1025
> fax 506-453-9470
>
> /GEMTEC Limited <http://www.gemtec.ca>
> /191 Doak Road
> Fredericton, NB, Canada
> E3C 2E6
>
> -- 
>
> 	
>
> *Andrew DeMerchant*
> *Computer Technologist*
> ph.506-453-1025
> fax 506-453-9470
>
> /GEMTEC Limited <http://www.gemtec.ca>
> /191 Doak Road
> Fredericton, NB, Canada
> E3C 2E6
>
>  
>
> -- 
>
> 	
>
> *Andrew DeMerchant*
> *Computer Technologist*
> ph.506-453-1025
> fax 506-453-9470
>
> /GEMTEC Limited <http://www.gemtec.ca>
> /191 Doak Road
> Fredericton, NB, Canada
> E3C 2E6
>
>  
>
> -- 
>
> 	
>
> *Andrew DeMerchant*
> *Computer Technologist*
> ph.506-453-1025
> fax 506-453-9470
>
> /GEMTEC Limited <http://www.gemtec.ca>
> /191 Doak Road
> Fredericton, NB, Canada
> E3C 2E6
>
>  
>

-- 
	*Andrew DeMerchant*
*Computer Technologist*
ph.506-453-1025
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