On Mon, Feb 14, 2011 at 8:22 PM, Elliot <[email protected]> wrote:
> All listed instances on the same machine (where SQL Server is running) > - each bound to a different listening port (so they can function at > the same time). > OK, but I was asking if the working instance of OpenBD and the non-working instance of OpenBD are running on the exact same Vista machine with the exact same settings (firewall, AV software, etc. etc.) since if that isn't the same it might indicate why one can connect and another can't. Have you tried telneting from the box in question to port 1433 on the SQL Server? If the datasource verifies chances are there aren't any connectivity issues but I always go back to basics to troubleshoot. I never used named instances on SQL Server, and IIRC there was a SQL Server driver update between OpenBD 1.3 and 1.4, so maybe there's some difference in how named instances are addressed? Have you tried using the "Other" datasource type and using the appropriate JDBC URL to connect to the SQL Server instance as an experiment to see if that works? I've also seen cases where if you created the datasource and then edit it later, if there are open connections the datasource doesn't get updated until you restart OpenBD. Have you tried creating a brand new from scratch datasource? (Maybe that's where you started, just another thing that came to mind.) > > Are there any other cahanges to the jetty/openbd config required (i > changed the port from 8888, to 8884). The admin runs and identifies > correct instance. > There shouldn't be any changes *required* to the ready2run version to get this working, no. Unfortunately I don't really have an easy way to test named instances in SQL Server but if it comes to that I can fire up a Windows VM, install SQL Server, replicate your setup, and see where I get. -- Matthew Woodward [email protected] http://blog.mattwoodward.com identi.ca / Twitter: @mpwoodward Please do not send me proprietary file formats such as Word, PowerPoint, etc. as attachments. http://www.gnu.org/philosophy/no-word-attachments.html -- tag/function ref: http://www.openbluedragon.org/manual/ mailing list - http://groups.google.com/group/openbd?hl=en Get to Texas in Feb for OpenCFSummit http://www.opencfsummit.org/
