begginer with db connections-Collection of common programming errors

Hello,

I’m a beginner and would like to experiment with connection and command objects.

Unfortunately, in my code, I can’t resolve a problem with the connection string:

SqlConnection conn = new SqlConnection(                 “Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;Data Source=’c:\\Northwind.sdf'”

                );

At runtime I get an exception message ‘keyword “provider” not supported ‘. If I delete that part, I get “The server was not found or was not accessible. ” I have really tried everything I could find on forums related to sql ce connection strings, and I’m getting really frustrated. Any help would be appreciated!

Thanks,

Viktor