Hi there. I've been assigned to research the possibility of using GeoServer with our existing data (latitude and longitude coordinates) using our SQL Server 2005 database.
However, I've only been able to go as far as the install and configuring a DataStore, which isn't working too well. I downloaded the Microsoft JDBC driver 1.2 AND 2.0, however neither of them seem to work. Whenever I define the database name in the DataStore setup, I get a "Unable to obtain connection" error. If I leave it blank, it works fine - but then I obviously can't see any tables to set up things like FeatureTypes. If I look at the GeoServer console, it says: "SqlServerException: The port number 1433/<DB NAME> is not valid" I have the latest stable version of GeoServer, and as I mentioned the 2 versions of the JDBC SQL driver. Can anyone please help me? This is really frustrating. -- View this message in context: http://www.nabble.com/SQL-Server-2005---I%27m-seriously-missing-something.-tp25887970p25887970.html Sent from the GeoServer - Dev mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ Geoserver-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-devel
