Unknown connection option in connection string: provider.

[Jose Betances]

I set up SQL Server in Computer A, and running a c# application from
computer B. When I attempt to create an SqlConnection object an error
is raised. The message is "Unknown connection option in connection
string: provider." The connection string is standard and do not think
it's the problem because I am using the connection string created by a
Data Connection object I created using Visual Studio .Net. Can anyone
help, Thank you...

 

[Eliyahu Goldin]

If you are creating an SqlConnection, option "Provider" is neither needed
nor supported. It is used for OleDbConnection.

HTH,

Eliyahu

 

[Ignacio Machin]

Hi Jose,

Take a look at
http://www.able-consulting.com/dotnet/adonet/Data_Providers.htm here you
will find several examples of connection strings to differents DB, as you
can see the Provider is not needed, in fact the provider is known already,
it's MSSQL .

Hope this help,