Last post Jul 07, 2011 09:08 PM by Decker Dong - MSFT
Jul 02, 2011 11:13 AM|Silverlight.Shailendra|LINK
I developed my first web site in my local language[Marathi]. I used Ms-Access database for it ContactUs.aspx page if I click on the button i got an error message. It is working fine on my machine. But when I uploaded on the server.. I got an
Please fill the above form and hit on the button:
My ConnectionString :
<add name="SPDBConStr" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|SPDB.mdb;" providerName="System.Data.OleDb"/>
Is this ConnectionString right? I also refered many web sites like
www.connectionstring.com. They mentioned to write UserId and Password. I didn't create any UserName and Password for database. So can I write my FTP's UserName and Password? Please tell me the solution. i'm getting different error messages everytime.
please help to solve this problem
Jul 02, 2011 11:17 AM|smirnov|LINK
I got an error.
I got an error.
and the error is?
Usually mdb required an access rights to create new files in the directory where mdb file is located. You should check permissions on that directory.
Jul 02, 2011 11:20 AM|princeG|LINK
It might the reason database version
Jul 02, 2011 11:20 AM|Silverlight.Shailendra|LINK
Sorry I forgot to enter:
the error is
Unrecognized database format 'E:\CustomerData\webspaces\webspace_00114701\wwwroot\lagnamantra.com\App_Data\SPDB.mdb'.
please fill the form you can see this error
Jul 02, 2011 11:21 AM|Silverlight.Shailendra|LINK
But my Ms-Access database version is .mdb and I used OLEDB for it
Jul 02, 2011 11:22 AM|smirnov|LINK
Please check this
Jul 02, 2011 11:30 AM|Silverlight.Shailendra|LINK
My host has asp.net 3.5 and Ms-Office 2007 support. I also have same configuration. And my D/D extension is mdb. not .accdb... then why it is not working?
Jul 03, 2011 12:00 PM|smirnov|LINK
Well, the error says that the Jet database driver version on your server does not understand the format. My bet is that if you Save As in format of Access 200-2003 all will be well.
Jul 03, 2011 02:23 PM|Silverlight.Shailendra|LINK
The format is Microsoft Office 2002-2003 format. I also replace the Database address whichever shown on the error page... but nope!!! still it has an error
Jul 04, 2011 10:44 PM|Decker Dong - MSFT|LINK
I think you can make sure that your 'E:\CustomerData\webspaces\webspace_00114701\wwwroot\lagnamantra.com\App_Data\" is a deploying path on your server, So please make sure that you've really have a db inside with a full-authentication or authorization to
access the db.
And what's more——If you cannot solve your problem, just copy the db into the same place where the pages locate and just use:
Jul 07, 2011 09:40 AM|Silverlight.Shailendra|LINK
I don't want to do that, But bcoz of urgency I did it. Quickly I create a new database in MySQL make tables and published it. Right now it is working fine. The address whichever you gave me; after that new error genrated "Unrecognizrd Database Format"
Do you know where to specify the server name in ConnectionString for Ms-access. Bcoz we just wrote Provider=............
Thanks for timely help
Jul 07, 2011 09:08 PM|Decker Dong - MSFT|LINK
Hello Silverlight Shailen：）
You can try to use——
Data Source=|DataDirectory|\SPDB.mdb (Add a "\" at the back of |DataDirectory|).