[Gvsig_english] problems with odbc-connection to MS Access-Database

[Johannes Valenta]

Hi,

in addition to Ben's suggestion I found out that you do not have to set your
table name in brackets like you used to do with 1.1.2. [$$ tablename].
Just write it into the dialogue without any extras.

Best,

Johannes

2010/2/9 Benjamin Ducke <benjamin.ducke at oxfordarch.co.uk>

> Hi Sabine,
>
> this is a bug in the DBMS interface GUI (will file a bug ticket
> with the developers about this shortly). ODBC connections do not
> require a host name or port. All of that information is managed
> by the system's ODBC driver. You should just be able to enter
> any bogus values into the "servername" and "port" fields.
>
> If it still does not work, then the problem lies somewhere else.
> Perhaps a character encoding or data type that the gvSIG ODBC
> driver does not support.
>
> Cheers,
>
> Ben
>
> ----- Original Message -----
> From: "Sabine Früchtl" <s.fruechtl at gmx.de>
> To: "gvsig internacional" <gvsig_internacional at listserv.gva.es>
> Sent: Tuesday, February 9, 2010 2:24:49 PM GMT +01:00 Amsterdam / Berlin /
> Bern / Rome / Stockholm / Vienna
> Subject: [Gvsig_english] problems with odbc-connection to MS
> Access-Database
>
>
>
>
>
> Dear list,
>
>
>
> I was trying to get some connection to my MS Access Database in gvSIG 1.9
> via odbc on my local notebook (Windows Vista). I have done this some time
> ago on my old Windows XP-Notebook, using gv SIG 1.1.2 and it was working.
>
> My first problem is now, that in gvSIG 1.9 I have to fill in a servername
> and port (this was not necessary in gvSIG 1.1.2). Johannes told me, that
> someone told him last week, the servername in such cases is localhost (or
> something equal, he didn’t remember it at all) and the port would be 80 or
> 8080. I’ve tried several combinations but I can’t get this tool running (see
> enclosed error message)! I’ve tried it with gvSIG 1.1.2 as well, but it
> doesn’t work. Is it possible, that this is another Vista-bug? Maybe someone
> has some idea to solve this problem?
>
> By the way, I’ve tried some connection to MS Excel-tables via odbc too. It
> is working perfectly, so in the worst case I have to export my tables and
> queries to Excel, but more comfortable would be the way via odbc/Access.
>
>
>
> Thank you, best regards,
>
>
>
> Sabine
>
>
>
>
>
>
>
> Illegal group reference
> java.lang.IllegalArgumentException: Illegal group reference
> java.util.reg ex.Matcher.appendReplacement(Unknown Source)
> java.util.regex.Matcher.replaceAll(Unknown Source)
> java.lang.String.replaceAll(Unknown Source)
> org.gvsig.exceptions.BaseException.format(BaseException.java:70)
> org.gvsig.exceptions.BaseException.toString(BaseException.java:285)
> java.lang.String.valueOf(Unknown Source)
> java.io.PrintStream.print(Unknown Source)
> java.io.PrintStream.println(Unknown Source)
> java.lang.Throwable.printStackTrace(Unknown Source)
> java.lang.Throwable.printStackTrace(Unknown Source)
>
> com.iver.cit.gvsig.project.documents.table.ProjectTableFactory.createFromGUI(ProjectTableFactory.java:212)
>
> com.iver.cit.gvsig.project.documents.gui.ProjectWindow.createDocument(ProjectWindow.java:297)
>
> com.iver.cit.gvsig.project.documents.gui.ProjectWindow.newProjectDocument(ProjectWindow.java:320)
>
> com.iver.cit.gvsig.project.documents.gui.ProjectWindow.access$400(ProjectWindow.java:90)
>
> com.iver.cit.gvsig.project.documents.gui.ProjectWindow$4.actionPerformed(ProjectWindow.java:691)
> javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
> javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
> javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
> javax.swing.DefaultButtonModel.setPressed(Unknown Source)
> javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
> java.awt.Component.processMouseEvent(Unknown Source)
> javax.swing.JComponent.processMouseEvent(Unknown Source)
> java.awt.Component.processEvent(Unknown Source)
> java.awt.Container.processEvent(Unknown Source)
> java.awt.Component.dispatchEventImpl(Unknown Source)
> java.awt.Container.dispatchEventImpl(Unknown Source)
> java.awt.Component.dispatchEvent(Unknown Source)
> java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
> java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
> java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
> java.awt.Container.dispatchEventImpl(Unknown Source)
> java.awt.Window.dispatchEventImpl(Unknown Source)
> java.awt.Component.dispatchEvent(Unknown Source)
> java.awt.EventQueue.dispatchEvent(Unknown Source)
> com.iver.andami.ui.AndamiEventQueue.dispatchEvent(AndamiEventQueue.java:58)
> java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
> java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
> java.awt.EventDispatchThread.pumpEvents(Unknown Source)
> java.awt.EventDispatchThread.pumpEvents(Unknown Source)
> java.awt.EventDispatchThread.run(Unknown Source)
>
>
> _______________________________________________
> Gvsig_internacional mailing list
> Gvsig_internacional at listserv.gva.es
> http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
>
>
> ------
> Files attached to this email may be in ISO 26300 format (OASIS Open
> Document Format). If you have difficulty opening them, please visit
> http://iso26300.info for more information.
>
> _______________________________________________
> Gvsig_internacional mailing list
> Gvsig_internacional at listserv.gva.es
> http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20100524/ebdde971/attachment.htm