Re: FN-FORUM: .NET and DB Connection String

date posted 22nd January 2007 19:11

Craig wrote:
> 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
>
>

Craig,

Try moving the connections strings to the web.config file.

--
Cheers,
Gary
http://www.garyshort.org/