Up until this week I was using MS Access as my database. However MS Access has started playing up and, after some research, online I have decided to move forward and learn about using MS SQL Server as my database.
Here is the problem I'm having. I used to use an OleDb connection to manipulate the data in my MS Access db using vb.net.
The connection string I used to use for this was as follows:
Dim DataConn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; data source=" & Server.MapPath("App_Data/mydatabase.mdb"))
I used this connection string because my database was stored within my app_data folder in VWD2008.
I now have a MS SQL DB sitting in the app_data folder which mimicks my old Access db.
What connection string do I need to use to connect to this database?
The reason I have my database saved to the app_data folder is because when I launch the website I am going to pay a host to host the website and the database for me. I therefore want to have my db in app_data to keep development simple - my knowledge is limited and moving from nice and straight forward Access to MS SQL Server has scared me a little!
Any help or guidance would be much appreciated! I am not asking for someone to write the string for me, just a little help would be great or some guidance towards some good resources for this.