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

[Sabine Früchtl]

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 
  To: Users and Developers mailing list 
  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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20100524/0ef9baba/attachment.htm