how to write connection string in web.config file for ms-Access OleDb proiver

jignesh kadvani

below is my connection string in web.config file..

i am accessing my connection string in my .aspx page as below:

OleDbConnection con = new
OleDbConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
and i am gatting following error when i run the application
Could not find installable ISAM.

Server Error in '/' Application.

Could not find installable ISAM.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Could not find installable ISAM.

Source Error:

Line 30:             OleDbDataAdapter adpt = new OleDbDataAdapter("select * from WordMst", con);
Line 31:             DataSet ds = new DataSet();
Line 32:             adpt.Fill(ds);
Line 33:             gvWord.DataSource = ds;
Line 34:             gvWord.DataBind();

can anybody give me solution... is it driver problem..?

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sam Hobbs15y ago
I suggest creating a new thread instead of "hijacking" an old thread. On reason why it is better to create a new thread is that people that hijack an old thread usually think they don't have to provide as much information, but if you don't get a relevant answer here, then try creating a new thread and in it provide more information.
0
Suthish Nair15y ago
couple of things

1. as per Jones said you need a space between Data and Source. Data Source=

2. Make sure the driver (MDAC) driver installed on your system/server.

0
karthick karthick15y ago
i am writing connection string in webconfig

0
Jones Jay18y ago

connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source = C:\myweb\App_Data\ASPNetDB.mdb"

you were getting error because your wrote "DataSource" instead of "Data Source" , notice the space between the word "Data & Source"

0
jignesh kadvani18y ago
i access that site but it didn't give proper solution can you give steps to do . that..
0
Mamta M18y ago
Yes, this is a driver problem. Check the following site for the solution:

http://support.microsoft.com/kb/209805/en-us

Hope this helps.

-Mamta
0