compiler does not like teh word "Provider" in my connectionString

Question

im new to this connecting to databases. i have in my connection string: connectionString = Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:/db1.mdb; i get an error during compilation saying  An unhandled exception of type 'System.ArgumentException' occurred in system.data.dll Additional information: Keyword not supported: 'provider'. anyone know how to get around it ?

kovan · Answer

FYI: any adapter that is related to SQL server (having sql infront of it) does not support Providers

schmintan · Answer

im such a stupid head. i was using SqlDataAdaptop instead of OleDbDataAdaptor. im real sorry for botherin you all..

schmintan · Answer

changed it to this : connectionString =Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\db1.mdb; ; still the same error as i posted earlier.thanks for trying though

Andrzej Wegierski · Answer

Maybe slash instead of backslash in DataSource? See connectionstrings