Ohh! I did not know this. <br>Of course the syntax with "$" Sabine provided is correct, mine is wrong.<br><br><br>Best,<br><br>Johannes<br><br><div class="gmail_quote">Am 24. Mai 2010 17:07 schrieb Sabine Früchtl <span dir="ltr"><<a href="mailto:s.fruechtl@gmx.de">s.fruechtl@gmx.de</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;">
<div bgcolor="#ffffff">
<div>Hi,</div>
<div> </div>
<div>additional I want to remark, that in case of a connection to some
<b>excel</b>-sheet you can use both versions:</div>
<div>"[table1$]" or simple "table1".</div>
<div>In case of connection to an access-database only the second version is
working. Weird!</div>
<div> </div>
<div>Best wishes,</div>
<div>Sabine</div><font color="#888888">
<div> </div>
</font><blockquote style="border-left: 2px solid rgb(0, 0, 0); padding-left: 5px; padding-right: 0px; margin-left: 5px; margin-right: 0px;"><div><div></div><div class="h5">
<div style="font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;">----- Original Message ----- </div>
<div style="background: rgb(228, 228, 228) none repeat scroll 0% 0%; font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous;">
<b>From:</b>
<a title="spatialjoe@googlemail.com" href="mailto:spatialjoe@googlemail.com" target="_blank">Johannes Valenta</a> </div>
<div style="font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"><b>To:</b> <a title="gvsig_internacional@listserv.gva.es" href="mailto:gvsig_internacional@listserv.gva.es" target="_blank">Users and Developers mailing
list</a> </div>
<div style="font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"><b>Sent:</b> Monday, May 24, 2010 3:32 PM</div>
<div style="font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"><b>Subject:</b> Re: [Gvsig_english] problems
with odbc-connection to MSAccess-Database</div>
<div><br></div>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" target="_blank">benjamin.ducke@oxfordarch.co.uk</a>></span><br>
<blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">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><br>----- Original Message -----<br>From: "Sabine Früchtl"
<<a href="mailto:s.fruechtl@gmx.de" target="_blank">s.fruechtl@gmx.de</a>><br>To:
"gvsig internacional" <<a href="mailto:gvsig_internacional@listserv.gva.es" target="_blank">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>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>_______________________________________________<br>Gvsig_internacional
mailing list<br><a href="mailto:Gvsig_internacional@listserv.gva.es" target="_blank">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" target="_blank">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>
</div></div><p>
</p><hr><div class="im">
<p></p>_______________________________________________<br>Gvsig_internacional
mailing
list<br><a href="mailto:Gvsig_internacional@listserv.gva.es" target="_blank">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></blockquote></div>
<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>
<br></blockquote></div><br>