I have had a application running on a shared server pretty much faultlessly for several years. It uses an ODBC connection which hooks in to a MS Access 2003 database at the backend. I like it this way rather that SQL, it's easy to install and maintain and the number of users on the app is small so it works great.
However I am now trying to set it up on a dedciated server as I am looking to roll the app out to a numner of other users, all of whom will run the app seperatly linked through their own domains, but all hosted on my server.
I am having real trouble setting up the ODBC connections though. I have purchased the server through a compnay called 1&1 and they told me it would all be possible but I am beginning to think not.
The server is running Windows Server R8 and when I went to setup the ODBC connections initially there was no MS Access connector available and my server admin guy had to manually install the drivers.
Still even after doing this, and apparently being able to make the necessary connection I am still getting an error when trying to access a page on which a connection to the DB is required. The error is of course of no help at all - it just says 'There is a problem with the resource you are looking for, and it cannot be displayed'
Is anyone aware of any issues with making ODBC connections with Windows sefver R8 or could it be that there is a problem with the server itself?