Hi, So first thing is that only actual geometric objects can be used with the sql server driver for geotools. It won't support x y columns. Although there was an experimental datastore that did this at one time.
So for that reason I believe only SQL Server 2008 will work. However I believe there is some way to get spatial functionality with 2005? I am far from a sql server expert. As for not specifying the connection this is a known issue. What happens when you don't specify db name for the connection? Do you get any tables at all? ReactiveX wrote: > 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. > -- Justin Deoliveira OpenGeo - http://opengeo.org Enterprise support for open source geospatial. ------------------------------------------------------------------------------ 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
