Thank you for that information before I continue I just want to clear one thing up.
I refer to cpanel, which I mean the hosting control panel
i.e. www. blink101.com:8077 - Is that what I should be using for setting up databases & odbc etc I have also seen :8787 refered to but this does not work for my accout.
I am on windows XP home edition, using MS Expression Web, Visual Studio WEb developer 2005 express edition, SQL Server express
I also have SQL Server tools (sql server management studio express, SQL Server configuration manager and surface area manager) - all of which I beleive are not applicable for what I am trying to do because it is your server and I cannot (probably just as well) access it.
Also - before I start again is there any way to reset my account back it's initial state - the reason I ask is that having tried and failed to get the login working I decided to reload my original
website hosting I had been working on. This included a grid view using an access database. Now that I have reloaded my
website hosting the page no longer works & even more strange.....
I have 2 pages
each looking at a different access database
each with an odbc dns set up in the hosting control panel where the name matches exactly (ie. on my pc ACCESSDATASOURCE1 and the dns I set up = ACCESSDATASOURCE1)
.... And each give a different responce
1= It is already opened exclusively by another user, or you need permission to view its data
2= creates popup for server login!!!
Have a look for yourself
www. blink101.com/software_experience.aspx
www. blink101.com/data.aspx