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

[Benjamin Ducke]

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.