[mapguide-users] ODBC connection problems...

Knight, Gregory Gregory.Knight.bra at cityofboston.gov
Mon Oct 23 15:37:19 EDT 2006


OK, Ive fuddled and duddled and I think Ive met with 'some' success...
I think the data source has been loaded into the MG repository, because
'Download' is available as an option from the Connection page in Studio
now... However, Show Tables doesn't return anything, and Test connection
results in "No current open database."

 

This is kind of discouraging to say the least.

 

________________________________

From: Chris Tallman [mailto:ctallman at innomap.com] 
Sent: Monday, October 23, 2006 1:53 PM
To: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] ODBC connection problems...

 

I've run into this just about every time I try and connect to a data
base.  Its takes some fiddling to get it to work right.  

 

I believe this is what I usually do.

 

Save and close the connection once you have the connection string
entered.

 

Open it back up, sometimes at this point it works.  Other times I have
to do this again and it works.  I have no explanation why but it does.

 

Hope this helps and maybe someone can offer some advice on what is going
on here.

 

Chris

 

 

________________________________

From: Knight, Gregory [mailto:Gregory.Knight.bra at cityofboston.gov] 
Sent: Monday, October 23, 2006 1:42 PM
To: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] ODBC connection problems...

Same result - quotes or no quotes.  


Greg

 

________________________________

From: Andy Morsell [mailto:amorsell at spatialgis.com] 
Sent: Monday, October 23, 2006 1:12 PM
To: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] ODBC connection problems...

 

Your first connection string looks correct (assuming there's no typo in
the file name and path).  If you remove the quotes from around it in
Studio, does that help?

Andy 

________________________________

From: Knight, Gregory [mailto:Gregory.Knight.bra at cityofboston.gov] 
Sent: Monday, October 23, 2006 9:52 AM
To: users at mapguide.osgeo.org
Subject: [mapguide-users] ODBC connection problems...

 

I am having some problems configuring an ODBC data source to a Microsoft
access database with MG Studio.

 

If I use a connection strings, 

 

"Driver={Microsoft Access Driver
(*.mdb)};Dbq=C:\WorkSpace\GISdata\BRA\gdb\bra.mdb;Uid=Admin;Pwd=;"

 

or 

 

"Driver={Microsoft Access Driver
(*.mdb)};Dbq=C:\WorkSpace\GISdata\BRA\gdb\bra.mdb"

 

I get FDO Exception: No current open database.


If I use a DSN, 

I get FDO Exception: FDOSM_18_CONFIG_W_METASCHEMA

 

I am using MGOS 1.0.1.

 

Am I doing something incorrectly here?  

 

Advice appreciated.  

 

Greg Knight

 

 

________________________________

 


The substance of this message, including any attachments, may be
confidential, legally
privileged and/or exempt from disclosure pursuant to Massachusetts
law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and
delete the material from any computer.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20061023/30c53f86/attachment.html


More information about the Mapguide-users mailing list