hiya,

I have an existing dbConn string in my web.config. Obviously, I want to take advantage of sql server connection pooling: My existing connections had a "provider" setting.

<add name="LocalSqlServer" connectionString="BLAH"
      providerName="System.Data.SqlClient" />

I try to ad d this property to my llblGenPro connString:

<add key="Main.ConnectionString" value="BLAH;  providerName=System.Data.SqlClient " /> 

error: Keyword not supported: 'providername'. << public static SqlConnection CreateConnection(string connectionString) Line 69: { Line 70: return new SqlConnection(connectionString); Line 71: }>>

hmm, how can I get this to be the same as my existing string?

cheers,

yogi

As far as I know connection pooling is used by default. ref: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=370

<add name="LocalSqlServer" connectionString="BLAH" providerName="System.Data.SqlClient" />

That's not a connection string, BLAH sounds like the connection string

providerName is not a valid key for a connectionString.

yes, cheers for that Walaa, you're right.

yogi