SQL Server ODBC DSN dissapearing.

[chrismul]

Hi there,

One part of my site uses a PHP based Forum (phpBB) This is running on SQL server 2000 and therefore has to access the database using the ODBC DSN supplied by DASP. This has been working fine for a few months but lately I am experiencing a strange problem.

Since my site is not yet live i sometimes do not access Forums and thereforethe Database via ODBC for a few days. When I tryI get an error generated from PHP saying that the ODBC data source name (DSN) does not exist, a few minutes later, miraculously, everything is OK again.

It seems that DASP are deleteing the ODBCS DSNs when they are not used for a while, can anyone tell me what the reason or what the timing for this is.

Hopefully, once I have gone live I will receive enough hits to not experience this problem, but if I do, it looks very unprofessional and could cost me business.

Could anyone please advise me.

Thanks a million.

[bruce]

I can ensure you that we do not delete your DSN unless you cancel the database.

Error message can sometimes be misleading. I would create a simple page to test when the error happens again to see if it is related to the application itself.

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

[chrismul]

Thanks for the reply,

Good to hear - I will put a test ODBC connection page together some time over the weekend and test.

Perhaps a full stack trace from .NET or ASP will help. The PHP page definitely says DSN not found and start working shortly afterwards so may be a timeout issue.

Will post my findings.

Thanks.