Updating Access database witihin ISP restrictions 1

[MdotButler]

I have some shopping cart code which updates a MS Access database using OLEDB as such. I can read the database using the following method, but cannot update anything.

Dim strSQL As String = "INSERT INTO BH (BH_BID) VALUES ('xxx')"
Dim strDSN As String = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & Server.MapPath("App_Data/Orders.mdb")
Dim myConn As New OleDbConnection(strDSN)
Dim myCmd As New OleDbCommand()

myCmd = New OleDbCommand(strSQL, myConn)
myConn.Open()
myCmd.ExecuteNonQuery()
myConn.Close()
myConn = Nothing

In moving this code to a new site and new ISP it fails. After digging around through FAQs I find a blurb indicating this is due to ASP.NET restrictions.

You will not be able to access an Microsoft Access database via ODBC or OLEDB because these procedures still contain the "unmanaged code" as mentioned before.

To work within these restrictions what options do I have? What type of ASP.NET database functionality is left?

 

[Turkbear]

Hi,
Try encrypting your connection strings or , at least, place them in web.config..

See this article:

http://www.guidanceshare.com/wiki/A...elines_-_Configuration_and_Connection_Strings

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[MdotButler]

I normally do use connection strings and do encrypt them, especially if I am using user names and passwords.

Thanx for the suggestion but the question is how to update the Access database with the ISP limitations of not using ODBC or OLEDB methods.

 

[ca8msm]

You will need to add write permissions on the directory that hosts the file for the account that your ASP.NET application is running under.

Mark,

Website Design Darlington
Experts, Information, Ideas & Knowledge
ASP.NET Tips & Tricks

 

[Turkbear]

Hi,
What else does the FAQ say about "unmanaged code" - it refers to a previous mention..

Clearly you can access the database if queries work, so it must be something else...






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[MdotButler]

Although the directory was wrte/update enabled, the actual Access Database had to have the permissions changed as well. Thanx for the help Mark...