[Gvsig_english] problems with odbc-connection to MSAccess-Database

Johannes Valenta spatialjoe at googlemail.com
Mon May 24 17:36:30 CEST 2010


Ohh! I did not know this.
Of course the syntax with "$" Sabine provided is correct, mine is wrong.


Best,

Johannes

Am 24. Mai 2010 17:07 schrieb Sabine Früchtl <s.fruechtl at gmx.de>:

>  Hi,
>
> additional I want to remark, that in case of a connection to some *excel*-sheet
> you can use both versions:
> "[table1$]" or simple "table1".
> In case of connection to an access-database only the second version is
> working. Weird!
>
> Best wishes,
> Sabine
>
>
> ----- Original Message -----
> *From:* Johannes Valenta <spatialjoe at googlemail.com>
> *To:* Users and Developers mailing list<gvsig_internacional at listserv.gva.es>
> *Sent:* Monday, May 24, 2010 3:32 PM
> *Subject:* Re: [Gvsig_english] problems with odbc-connection to
> MSAccess-Database
>
> 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
>>
>
>  ------------------------------
>
> _______________________________________________
> Gvsig_internacional mailing list
> Gvsig_internacional at listserv.gva.es
> http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
>
>
> _______________________________________________
> 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/daf11ee4/attachment.htm 


More information about the Gvsig_internacional mailing list