Connection String Errors HELP!!

Question

I am trying to connect to my Access database via Dreamweaver, asp.net c#. I go to OLE connection, Build, In the Data link Properties, I choose Microsoft Jet 4.0 OLE DB Provider, I click next, it then takes me to the connection tab where it says, Specify the following to connect to Access data 1. Select or enter a database name:. I then browse to my database on my C:. When I test connection, It's successfull! I hit o.k. and it takes me back to the OLE DB Connection window, I input a Connection name, connection1,when I test there, it gives me this error…. Format of the initialization string does not conform to the OLE DB specification. HELP. I've been stuck on this for hours

Am I even in the right spot? Should I be doing something different?

Mahesh Joshi · Answer

I think you are using a default connection string generated by the system. Here I am giving you an example of simple connection string format for connecting Access Database try this I am sure it will work fine. Here is a string [Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\db1.mdb]