[Geoserver-users] SQL Server 2008 - Geoserver not working since upgrade to 64-bit

2010-10-26 Thread David Collins
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

Re: [Geoserver-users] SQL Server 2008 - Geoserver not working since upgrade to 64-bit

2010-10-26 Thread Justin Deoliveira
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

Re: [Geoserver-users] SQL Server 2008 - Geoserver not working since upgrade to 64-bit

2010-10-26 Thread David Collins
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