FN-FORUM: .NET and DB Connection String

date posted 22nd January 2007 18:55

Hi All,

A client has an annoying problem that I'd like a bit of advice on if poss.

It's a .NET V1.1 VB site using MS Access as it's back end (soon to be
changed to MySQL). The DB Connection strings are set as application
variables in the Global.asax file on application start. This is done
because the same code runs on various dev, test and live machines so the
paths to the database vary by machine. However, the issue is that every now
and then we get a load of "Connection String Not Initialised" errors. Now
I'm wondering if that's what you get when the ADO Connection Pool gets fully
used and can't service any more connections to the Access DB. And would
this be likely cured after switching to MySQL?

Any comments would be appreciated.

Regards,

Craig