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