Hi,<br><br>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].<br>Just write it into the dialogue without any extras.<br><br>
Best,<br><br>Johannes<br><br><div class="gmail_quote">2010/2/9 Benjamin Ducke <span dir="ltr"><<a href="mailto:benjamin.ducke@oxfordarch.co.uk">benjamin.ducke@oxfordarch.co.uk</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi Sabine,<br>
<br>
this is a bug in the DBMS interface GUI (will file a bug ticket<br>
with the developers about this shortly). ODBC connections do not<br>
require a host name or port. All of that information is managed<br>
by the system's ODBC driver. You should just be able to enter<br>
any bogus values into the "servername" and "port" fields.<br>
<br>
If it still does not work, then the problem lies somewhere else.<br>
Perhaps a character encoding or data type that the gvSIG ODBC<br>
driver does not support.<br>
<br>
Cheers,<br>
<br>
Ben<br>
<div class="im"><br>
----- Original Message -----<br>
From: "Sabine Früchtl" <<a href="mailto:s.fruechtl@gmx.de">s.fruechtl@gmx.de</a>><br>
To: "gvsig internacional" <<a href="mailto:gvsig_internacional@listserv.gva.es">gvsig_internacional@listserv.gva.es</a>><br>
Sent: Tuesday, February 9, 2010 2:24:49 PM GMT +01:00 Amsterdam / Berlin / Bern / Rome / Stockholm / Vienna<br>
Subject: [Gvsig_english] problems with odbc-connection to MS Access-Database<br>
<br>
<br>
<br>
<br>
<br>
Dear list,<br>
<br>
<br>
<br>
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.<br>
<br>
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?<br>
<br>
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.<br>
<br>
<br>
<br>
Thank you, best regards,<br>
<br>
<br>
<br>
Sabine<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
Illegal group reference<br>
java.lang.IllegalArgumentException: Illegal group reference<br>
</div>java.util.reg ex.Matcher.appendReplacement(Unknown Source)<br>
<div><div></div><div class="h5">java.util.regex.Matcher.replaceAll(Unknown Source)<br>
java.lang.String.replaceAll(Unknown Source)<br>
org.gvsig.exceptions.BaseException.format(BaseException.java:70)<br>
org.gvsig.exceptions.BaseException.toString(BaseException.java:285)<br>
java.lang.String.valueOf(Unknown Source)<br>
java.io.PrintStream.print(Unknown Source)<br>
java.io.PrintStream.println(Unknown Source)<br>
java.lang.Throwable.printStackTrace(Unknown Source)<br>
java.lang.Throwable.printStackTrace(Unknown Source)<br>
com.iver.cit.gvsig.project.documents.table.ProjectTableFactory.createFromGUI(ProjectTableFactory.java:212)<br>
com.iver.cit.gvsig.project.documents.gui.ProjectWindow.createDocument(ProjectWindow.java:297)<br>
com.iver.cit.gvsig.project.documents.gui.ProjectWindow.newProjectDocument(ProjectWindow.java:320)<br>
com.iver.cit.gvsig.project.documents.gui.ProjectWindow.access$400(ProjectWindow.java:90)<br>
com.iver.cit.gvsig.project.documents.gui.ProjectWindow$4.actionPerformed(ProjectWindow.java:691)<br>
javax.swing.AbstractButton.fireActionPerformed(Unknown Source)<br>
javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)<br>
javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)<br>
javax.swing.DefaultButtonModel.setPressed(Unknown Source)<br>
javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)<br>
java.awt.Component.processMouseEvent(Unknown Source)<br>
javax.swing.JComponent.processMouseEvent(Unknown Source)<br>
java.awt.Component.processEvent(Unknown Source)<br>
java.awt.Container.processEvent(Unknown Source)<br>
java.awt.Component.dispatchEventImpl(Unknown Source)<br>
java.awt.Container.dispatchEventImpl(Unknown Source)<br>
java.awt.Component.dispatchEvent(Unknown Source)<br>
java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)<br>
java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)<br>
java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)<br>
java.awt.Container.dispatchEventImpl(Unknown Source)<br>
java.awt.Window.dispatchEventImpl(Unknown Source)<br>
java.awt.Component.dispatchEvent(Unknown Source)<br>
java.awt.EventQueue.dispatchEvent(Unknown Source)<br>
com.iver.andami.ui.AndamiEventQueue.dispatchEvent(AndamiEventQueue.java:58)<br>
java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)<br>
java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)<br>
java.awt.EventDispatchThread.pumpEvents(Unknown Source)<br>
java.awt.EventDispatchThread.pumpEvents(Unknown Source)<br>
java.awt.EventDispatchThread.run(Unknown Source)<br>
<br>
<br>
</div></div><div><div></div><div class="h5">_______________________________________________<br>
Gvsig_internacional mailing list<br>
<a href="mailto:Gvsig_internacional@listserv.gva.es">Gvsig_internacional@listserv.gva.es</a><br>
<a href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional" target="_blank">http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</a><br>
<br>
<br>
------<br>
Files attached to this email may be in ISO 26300 format (OASIS Open Document Format). If you have difficulty opening them, please visit <a href="http://iso26300.info" target="_blank">http://iso26300.info</a> for more information.<br>
<br>
_______________________________________________<br>
Gvsig_internacional mailing list<br>
<a href="mailto:Gvsig_internacional@listserv.gva.es">Gvsig_internacional@listserv.gva.es</a><br>
<a href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional" target="_blank">http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</a><br>
</div></div></blockquote></div><br>