[DBNETLIB]SQL Server does not exist or access denied

  • Hi there,

    I have an application which inserts data from text files onto a number of tables on a non-clustered instance of SQL Server 2005. It generally works for the first 20-30 times but then suddenly halts for a while. Something seems to time out and I receive the message above. If I run the application in debug mode, I can force the program to re-run the SQL statement, and nearly always it does run correctly and the program continues on and either completes the run or else repeats the same performance. All interaction with the database is via stored procedures hence the SQL statements being run use EXEC.

    I've Googled around to see if anyone else has reported this intermittent behaviour, but in every case I've found the application cannot contact SQL Server in the first place, rather than stopping and starting again with exactly the same connection.

    Does anyone have any suggestions as to the cause or how to work around it?

    Thanks a lot

    Robert

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply