[mapguide-users] ODBC problem...SOLUTION

[Andrew DeMerchant]

Got it working!!

It seems as though the FDO's tolerance to field names with spaces has 
gone down since the first release. In the FDO that came with 1.0.0 and 
1.0.1, it didn't like spaces in table names...but if you renamed your 
tables, it worked fine, even if you had field names with spaces in that 
table. Now the problem seems to have spread. My table had some spaces in 
other fields (not anything used for the plotting though)....as soon as I 
changed the spaces to "_", it worked fine....I must say also, that it IS 
much faster than those older versions, so kudos.....but please fix it to 
work with all possible table / field names. It's a simple matter of 
always enclosing all tables and field references with "[" and "]". 
Please please please add that for the next release. It would save a lot 
of headaches for people....Again though, nice work with the drastic 
speed increase!


Andrew



Willem Schwarte wrote:
>
> I also have problems with ODBC, but I have different versions of 
> studio on a couple of machines, and on one version I don't get the 
> problems. There it works fine, when on the other version my tables 
> can't be read...
>
>  
>
> Willem
>
>  
>
>  
>
> ------------------------------------------------------------------------
>
> *Van:* Greg Boone [mailto:greg.boone at autodesk.com]
> *Verzonden:* donderdag 9 november 2006 23:04
> *Aan:* users at mapguide.osgeo.org
> *Onderwerp:* RE: [mapguide-users] ODBC problem...
>
>  
>
> Andrew,
>
>  
>
> Do any of your table/column names include any "special" characters. 
> There is a known bug in the provider where characters other than Latin 
> alphanumeric and underscore '_' cause schema read failures inside the 
> ODBC provider.
>
>  
>
> Greg    
>
>  
>
> ------------------------------------------------------------------------
>
> *From:* Andrew DeMerchant [mailto:andrew.demerchant at gemtec.ca]
> *Sent:* Thursday, November 09, 2006 4:00 PM
> *To:* users at mapguide.osgeo.org
> *Subject:* Re: [mapguide-users] ODBC problem...
>
>  
>
> Anyone have any thoughts on this problem of mine? Or am I stuck 
> waiting for yet another release?
>
>
> Andrew
>
>
>
> Andrew DeMerchant wrote:
>
> Access.
>
>
> Andrew
>
>
> Butler, Juan P wrote:
>
> Which database are you using?  Oracle, Access, SQL, etc?
>
>  
>
> Juan Butler - Senior Programmer/Analyst
> GIS Applications
> Pinellas County Information Systems
> jpbutler at pinellascounty.org <mailto:jpbutler at pinellascounty.org>
>
>  
>
> Please note: All mail sent to and from Pinellas County Government is 
> subject to the Public Records Law of Florida.
>
>  
>
>  
>
> ------------------------------------------------------------------------
>
> *From:* Andrew DeMerchant [mailto:andrew.demerchant at gemtec.ca]
> *Sent:* Tuesday, November 07, 2006 2:21 PM
> *To:* users at mapguide.osgeo.org <mailto:users at mapguide.osgeo.org>
> *Subject:* [mapguide-users] ODBC problem...
>
>  
>
> Ok, so I decided to give the ODBC FDO another chance...to see if it's 
> any faster / better now than it was back in v1.0....It does seems to 
> be a bit better, only I can't seem to get it to work completely.
>
> I can see the list of my tables...I can pick my geometry fields, etc. 
> But I can't seem to get it to actually work. Either it's not reading 
> my X and Y columns, or else it's reading them, but discarding the data 
> for some reason....When I preview my layer, I see nothing. I've tried 
> everything that I can think of...I've tried changing the field type 
> (double, single, integer), I've tried various coord systems, I even 
> tried deleting all records in my table that have empty X / Y 
> fields.......Anyone have a solution? I've looked at the FDO docs, but 
> don't see anything that can help me.
>
> 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
>
>  
>
>  
>
> -- 
>
> 	
>
> *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
>
>  
>
> -- 
>
> 	
>
> *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
>
>  
>

-- 
	*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