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
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
Thanks, Justin.
You asked the right questions - particularly the question about schema. The
problem was that the SQL Server login that I was using had the default
database defined as 'master' - once the default was changed to the database
containing my data, then Geoserver was fine.
As an