ODBC connection problems...

Joel Carranza jec at gatekeeper.com
Mon Oct 23 18:56:24 EDT 2006


Has anyone had any success with connecting to Oracle using the latest version
of the ODBC FDO ? 

Joel Carranza
Gatekeeper Systems


ctallman wrote:
> 
> 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.
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/ODBC-connection-problems...-tf2495307.html#a6963906
Sent from the OSGeo MapGuide mailing list archive at Nabble.com.





More information about the Mapguide-users mailing list