Re: Hope this is the correct forum... Question on connection issue

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Andrew (amueller_at_ins3.com)
Date: 01/19/05 

Date: Wed, 19 Jan 2005 08:03:59 -0600

On this process, I am using a VB control. So, ASP shouldn't affect me at
all.

I can say that if I reset SQL Server, I have to re-run everything in Query
Analyzer before the program will run properly.

I set the CommandTimeout = 0 and the program 'may' eventually finish the
queries, but doesn't occur every time. Running QA works every time for some
reason. However, since this is a remote site, that isn't an optimal
solution.

Any other ideas??

Thanks!

Andrew
(PS - Sorry about naming my user wrong. That is fixed.)
"Anthony Thomas" <ALThomas@kc.rr.com> wrote in message
news:e6hWgte$EHA.1264@TK2MSFTNGP12.phx.gbl...
> They were probably all dead connections...connections that received
> unhandled errors; so, the ASP server quit using them.
>
> If you hadn't already reset, I would have asked you to look at the
lastBatch
> attribute for these spids in sysprocesses and see how long it had been
since
> their last executions.
>
> Oh, well. Better luck next time.
>
> Sincerely,
>
>
> Anthony Thomas
>
>
> --
>
> "msnews.microsoft.com" <amueller@ins3.com> wrote in message
> news:OXJVTOa$EHA.1396@tk2msftngp13.phx.gbl...
> Hello,
>
> Our database had been running great for over a year now... Due to hard
> drive limitations, about a week ago many of the connections could not
access
> the database. There are about 30 connections and about 25 could no longer
> connect. In researching the problem, I found that there was 25MB left on
> the hard drive and the database was set up for 100MB increments
> automatically.
>
> I decided that we should move the database to another drive (new drive
> array) to increase space as we need many years worth of online data
storage.
>
> The move did not result in connections to this database re-connecting
> properly.
>
> However, I noticed that if I run the same stored procedures in Query
> Analyzer..... and then run the application.... Each machine will connect.
> The application uses ADO through some VB6 ActiveX controls to connect to
the
> SQL Server.
>
> There must be some underlying reason for this. Any ideas?
>
> Thanks!
>
> Andrew
>
>

Relevant Pages

  • Re: Are Frontpage passwords secure?
    ... These access a sql server ... > database which has credit cards. ... How does your asp get the credentials for presentation to SQL?? ... If you are using the DB for credit card info, ...
    (microsoft.public.security)
  • RE: ASP Help Needed
    ... Derive the difference, again, using datediff() ... dont touch the database (best practice - if you did a PORPER analisys ... > I need some help with the ASP. ... > I am using MS SQL server 2000 as database ...
    (microsoft.public.inetserver.asp.components)
  • Problem in Synchronization PocketPC with SQL Server
    ... my Pocket PC with a database in a PC. ... In my Pocket PC i have SQLCE 2.0. ... PC is running SQL SERVER 2000 and IIS. ... "..ASP ERROR " and the ...
    (microsoft.public.sqlserver.ce)
  • Re: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
    ... > say SELECT * FROM problemdb, but when I try to use INSERT, I get the error ... > from ASP page, not when I do it with windows scripting host. ... > So I explicitely connect to the database I want to. ... > The SQL server is in the same server as the IIS where I run the pages. ...
    (microsoft.public.inetserver.asp.db)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)