Application unable to connect to SQL (OpenInsight Specific)
At 20 MAR 2000 04:14:57AM Kathleen wrote:
I have an application that refuses to connect to my sql database. The database can be connected to any other application except this one. I created a new application and checked across all the programs and datasets, etc and that worked for a week. Then suddenly the connection problems re-occured. The messages I get back vary from 'Too many open connection handles' to 'Sql Server not available' to 'Sql database does not exist'.
Anybody encountered this before?
At 20 MAR 2000 01:04PM Stephen S. Revelation wrote:
Kathleen,
Have you thunked your data sources (see KB Article)? What version of MSSQL Server are you using? If < 7.0, then use the native SQL connection. If 7.0 then use ODBC connectivity.
-Stephen
At 20 MAR 2000 04:22PM dsig@teleport.com wrote:
If you are connecting to SqlServer <7.0 be sure that you are using the 16bit drivers.
dsig@teleport.com onmouseover=window.status=imagine … opinions that seem to scare;return(true)"
David Tod Sigafoos ~ SigSolutions
cell: 503-341-2983
At 22 MAR 2000 04:46AM Tony Marler @ Prosolve Software wrote:
Kathleen
A bit late answering, is this still a problem ?
If this is a random error will either be a networking issue or that you are not closing the connection down correctly. Use SQL Server side tools to check the number of connections open.
If it suddenly stopped then did you add any software to workstatation such as a new ODBC version ?
Tony