Data Access Layer error when checking ConnectionState

[tango1948]

Hi
I have a data access layer where the connection is either sql server or oracle depending on the provider specified in the web.config, when I check the ConnectionState of the connection not being used I get:
Object reference not set to an instance of an object.

How can I check on an unopened connection without getting this error?

Thanks for any help

David

 

[bborissov]

This is question to your FrontEnd forum, not for SQL Server one.

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP