Change my database connection in visual web developer from access mdb to accdb or sql database
Posted on 2013-01-09
I am working with my companies job request system, which was built for us and i am attempting to upgrade our system to have a login/registration page and a page that shows everyone's submitted jobs.
My first step is to upgrade our database, it was built using an access.mdb database. Running on jet 4.0. I would like to move the database which was just located in the local folder to the app_data folder and i would also like to either upgrade the database to access 2010 or to an sql database...and sql database would be ideal
here is our code
Dim connectionstr As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("order_db.mdb") & ";"
Dim objcn As New Data.OleDb.OleDbConnection(connectionstr)
Dim mySQL As String
Dim objcm As New Data.OleDb.OleDbCommand(mySQL, objcn)
Dim objdr As Data.OleDb.OleDbDataReader
Dim linked As Boolean
if i just change order_db.mdb to order_db.accdb and try to configure the data it gives me the error