[mapguide-users] ODBC connection problems...

[Campbell, Keith A]

Greg,
 
this format has worked for me:-
 
driver={Microsoft Access driver
(*.mdb)};dbq=%MG_DATA_FILE_PATH%MyDatabase.mdb
 
This assumes the database has been uploaded to the repository
 
Keith

________________________________

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



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.



This message has been scanned for viruses by MailControl
<http://bluepages.wsatkins.co.uk/?4318150> 



This email and any attached files are confidential and copyright protected. If you are not the addressee, any dissemination of this communication is strictly prohibited. Unless otherwise expressly agreed in writing, nothing stated in this communication shall be legally binding.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20061024/1f5854b5/attachment.html