DbProvider GetFactory exception with system.data.sqlclient

[Guest]

I received an exception when I tried to use provider name
"system.data.sqlclient" to create a db factory.

DbProviderFactory dbFactory =
DbProviderFactories.GetFactory("system.data.sqlclient");

The exception message is:-
"Unable to find the requested .Net Framework Data Provider. It may not be
installed."

I have SQL Server 2005 and Visual Studio 2005 installed on my system.
Can someone tell me what did I do wrong or miss?

Thanks

 

[Cor Ligthert [MVP]]

LK,

I was not able to do it using that overloaded version with the string.
Should go however I could not find documentation. In the way as it is done
in this sample on our website it works.

http://www.vb-tips.com/default.aspx?ID=8c3dc2d7-1232-4dd1-817e-22eaaebb2723

I hope this helps,

Cor

 

[W.G. Ryan - MVP]

use "System.Data.SqlClient" instead of the lower cased spelling. It' case
sensitive. Change the casing and you should be fine. If not let me know.

Bill