Ms Access and Asp.net

Question

User81789783 posted

Hi to every one ..

 

I have Access database Access 2007 . and i need to connect with ASp.net ..nad i put database in  db folder but it gives errors ... 

if  provide Database1.accdb in connection string (following error)

Unrecognized database format 'C:\Documents and Settings\erum.mirza\My Documents\Visual Studio 2008\Projects\ajax\ajax\db\Database1.accdb'.

if  provide Database1. mdb in connection string (following error)

Could not find file 'C:\Documents and Settings\erum.mirza\My Documents\Visual Studio 2008\Projects\ajax\ajax\db\Database1.mdb'.

 

 

 

 

 

Answer 1

User-1315512054 posted

Hello,

What is your database name?

Regards

Answer 2

User81789783 posted

Database1.accdb or may be ms access call it  Database1.mdb

Answer 3

User-1716253493 posted

try place Database1. mdb in app_data folder

Answer 4

User81789783 posted

the error is

Unrecognized database format 'C:\Documents and Settings\erum.mirza\My Documents\Visual Studio 2008\Projects\ajax\ajax\App_Data\Database1.accdb'.

 

and the piece of code is

    protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                string ConnectString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" + Server.MapPath("App_Data\\Database1.accdb; Persist Security Info=False;");
                OleDbConnection objCon;
                OleDbCommand objCmd;
                DataSet Ds = new DataSet();

                string GetSql = string.Empty;
                GetSql = "(SELECT * FROM Table1)";
                using (objCon = new OleDbConnection(ConnectString))
                {
                    using (objCmd = new OleDbCommand(GetSql, objCon))
                    {
                        OleDbDataAdapter Da = new OleDbDataAdapter(objCmd);
                        Da.Fill(Ds);
                    }
                }



            }
        }

though  i have moved database to folder mentioned by U i.e App_data

 

Answer 5

User-1716253493 posted

string ConnectString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" + Server.MapPath("~/App_Data/Database1.accdb") + "; Persist Security Info=False;");

Answer 6

User81789783 posted

thanks for your reply

 

i have changed connection string as follows but get an error

Unrecognized database format 'C:\Documents and Settings\erum.mirza\My Documents\Visual Studio 2008\Projects\ajax\ajax\App_Data\Database1.accdb'.

let me share line too

string ConnectString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" + Server.MapPath("~/App_Data/Database1.accdb") + "; Persist Security Info=False;" ;

 

Answer 7

User-1716253493 posted

use access 2003 file

If you want use access 2010 use “Microsoft.ACE.OLEDB.12.0” intead Microsoft.Jet.OLEDB.4.0

Download here

http://www.microsoft.com/en-us/download/details.aspx?id=13255

Answer 8

User81789783 posted

you mean there is no connectivity  for 2007 in any way :(

Answer 9

User-1716253493 posted

use Microsoft.ACE.OLEDB.12.0, see my above post

string ConnectString = "PROVIDER=Microsoft.ACE.OLEDB.12.0;DATA SOURCE=" + 
Server.MapPath("~/App_Data/Database1.accdb") + "; Persist Security Info=False;" ;

Answer 10

User81789783 posted

I installed database engine (Compatible one)with same office version and its working fine and shine ...... (cheers :)

 

 

Thanks

Answer 11

User81789783 posted

yes worked ..