Ah good point--iirc there's actually a jdbc limit but I may be conflating here.
This brings to mind another bug that I think Peter fixed in the admin where passwords with # in them couldn't be used. All that being said it sounds like the actual login / initial handshake works ok but definitely worth at least considering these password related issues. On Feb 15, 2011 6:18 AM, "Jeff Lucido" <[email protected]> wrote: > This is a stretch but how long is the SQL connection password? I ran into an > issue with the new driver in 1.4 (I think) that barfed on a long password or > was it through the administrator? Matt. W. do you remember specifically what > it was? I know it was resolved with 1.5 since the administrator was updated > then. > > -JSLucido > > On Mon, Feb 14, 2011 at 11:50 PM, Elliot <[email protected]> wrote: > >> thanks Matt >> >> I'll mess around with this later, will just use my 1.3 instance for >> the moment until i have more time resolve the issue. >> >> last effort for the moment - tried ODBC (and now get the error in the >> admin) >> >> Could not verify datasource: [Microsoft][ODBC Driver Manager] Invalid >> string or buffer length >> >> if i put the wrong password in i get the right error - so it is >> reaching the server! >> >> Oh well will get back to it later. >> >> >> On Feb 15, 3:52 pm, Matthew Woodward <[email protected]> wrote: >> > 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/ >> > > -- > 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/ -- 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/
