MS-Access Database 2010 Problem

[biranl]

Hi there,
I had developed my website using ASP .Net 4 using MS-Access 2010. I am using Parallels Plesk panel 9.5.5 for Windows. Unfortunately, database connection string error, error: Ace.oledb.12.0 is not install at your server. So, i referred this link http://www.microsoft.com/en-us/download/details.aspx?id=13255
but this is out of my control.

Please suggest me. what should i do.
Waiting your prompt.

Thank you

 

[davejuk]

I don't know what Ace is but why not use Jet, i.e. "Provider=Microsoft.Jet.OleDb.4.0; Data Source=|DataDirectory|/mydatabase.mdb". This assumes your database (mydatabase.mdb) is in the App_Data folder.

On a seperate note, why not use SQL Server Express?

 

[biranl]

Hi davejuk,
Thanks for reply.
MS-Access 2010 is upgraded to Ace Oledb.
Microsoft.Jet.OleDb.4.0 is a old version below MS-Access 2003.
SQL Server Express is just engine to query for database. I can't create database by Express edition.

 

[davejuk]

OK I see.

To install the Access 2010 database engine, you will need to log into your server via remote desktop. If you don't have RDP access then you can ask your host to install it.

If you don't have RDP access and your host is unwilling to install it then you could always save the MDB file in Access 2007 format and use Jet, as per my previous post.

However I would strongly recommend converting your database to MSSQL. The migration tool built into Access sucks but fortunately Microsoft provide a free stand-alone migration tool: http://www.microsoft.com/sqlserver/en/us/product-info/migration-tool.aspx#Access

 

[biranl]

Thanks again davejuk,
I don't have RDP access and hosting site also not willing.
if i use "Provider=Microsoft.Jet.OleDb.4.0; Data Source=|DataDirectory|/mydatabase.mdb"
may i need to configuration on hosting?

another problem on my hosting site.
i have aspx files on there and default file is defualt.aspx but there is automatically created new default.asp file what is the problem?

 

[davejuk]

You can use any engine as long as it is installed. JET should be installed as standard. Which version of Windows Server are you running? Why don't you just try it? It's not much effort.

If you have another question then you should start another thread. If you don't want one of the default documents then just delete it.

 

[biranl]

I am client. this is my web site, you can try it www.nationalacademyhss.com/contactus.aspx
oledb error.
i had requested long time ago to my hosting site, but they don't care.
actually this Microsoft Access Database Engine 2010 Redistributable is free.
http://www.microsoft.com/en-us/download/details.aspx?id=13255

why my hosting site is not willing about this.

 

[davejuk]

Have you imported the System.Data.OleDb namespace?

 

[biranl]

of course, i did.

 

[davejuk]

of course, i did.

Well that error suggests you have not. I will need your full source to help further.