I am trying to set up my first online VB website with a connected MS Access database so please be patient with me- I'm still a newbie!
I have the website all set up and it's running brilliantly online, however I cannot get the database to connect :( I contacted the hosting company to ask them for help and they directed me to this:
I believe you need to consult this matter with your current provider. Or please read their knowledgebase. Please make sure you have created your db via your CP.
Eithne
Member
26 Points
33 Posts
Connecting MS Access DB to online VB website
Jan 21, 2013 09:30 AM|LINK
Hi everyone :)
I am trying to set up my first online VB website with a connected MS Access database so please be patient with me- I'm still a newbie!
I have the website all set up and it's running brilliantly online, however I cannot get the database to connect :( I contacted the hosting company to ask them for help and they directed me to this:
http://msdn.microsoft.com/en-us/library/ms178371(v=vs.100).aspx
and told me to set up the database on the HELM control panel.
I am so very confused. I can access the HELM panel and see the database, but I have no idea how to edit it or connect them. It tells me this:
"Connection Information: Please contact your administrator for this information".
I've been working on this for a while now, but seem to be going around in circles.
Can someone please point me in the right direction?
dotnetnerd
Contributor
2368 Points
538 Posts
Re: Connecting MS Access DB to online VB website
Jan 22, 2013 02:28 AM|LINK
Hi Eithne,
I believe you need to consult this matter with your current provider. Or please read their knowledgebase. Please make sure you have created your db via your CP.
Windows ASP.NET Hosting | Reseller Hosting | Cloud Hosting
hans_v
All-Star
35986 Points
6550 Posts
Re: Connecting MS Access DB to online VB website
Jan 22, 2013 06:34 AM|LINK
http://www.mikesdotnetting.com/Article/78/AccessDataSource-SqlDataSource-and-connecting-to-Access-databases-in-ASP.NET
http://www.mikesdotnetting.com/Article/26/Parameter-Queries-in-ASP.NET-with-MS-Access
But instead of Access, perhaps a better choice is to use SQL Server Compact
http://erikej.blogspot.nl/2011/01/sql-server-compact-40-released.html
hans_v
All-Star
35986 Points
6550 Posts
Re: Connecting MS Access DB to online VB website
Jan 22, 2013 06:35 AM|LINK
Why?