Interesting... I have never heard of such an issue but then again I have
never worked with sql server on 64 bit.
So the connection succeeds but it does not send back the right tables? What
tables are getting returned? Are they in a specific schema?
I wonder if perhaps its a bug in the jdbc driver itself. We actually use an
older version of it. Can you try upgrading the jdbc driver to version 3 (if
you are using java 5) or version 4 (if you are using java 6).
You can upgrade the driver by removing the old one from WEB-INF/lib and
copying over the new one.
Let me know if that works or you have any problems upgrading the driver.
-Justin
On Tue, Oct 26, 2010 at 5:21 PM, David Collins <david.8.coll...@gmail.com>wrote:
> Hello.
>
> I am using Geoserver 2.0.1 with the corresponding SQL Server 2.0.1 module.
>
> Since our IT dept upgraded SQL Server 2008 from 32-bit to 64-bit, Geoserver
> no longer connects properly.
> All the connection parameters are unchanged from the 32-bit version - I am
> using a number of other client products and have not had to change any
> settings with them.
> Even the port number of the SQL instance has not changed.
>
> When I try to create a new layer, using the defined SQL Server store, the
> Geoserver web page only shows the following tables ..
>
> spt_fallback_db Publish
> spt_fallback_dev Publish
> spt_fallback_usg Publish
> spt_monitor Publish
> spt_values Publish
>
> Is there a version of Geoserver and the SQL Server module that works with
> 64-bit SQL Server 2008 ?
>
> Regards,
> David Collins
>
>
>
> ------------------------------------------------------------------------------
> Nokia and AT&T present the 2010 Calling All Innovators-North America
> contest
> Create new apps & games for the Nokia N8 for consumers in U.S. and Canada
> $10 million total in prizes - $4M cash, 500 devices, nearly $6M in
> marketing
> Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
> http://p.sf.net/sfu/nokia-dev2dev
> _______________________________________________
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
------------------------------------------------------------------------------
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
http://p.sf.net/sfu/nokia-dev2dev
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
