July 13th, 2011, 05:10 AM
ODBC Connection Issue
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?
July 27th, 2011, 04:41 PM
July 27th, 2011, 04:44 PM
ODBC Connection Issue
elevated command prompt should read
%windir%\system32\inetsrv\appcmd.exe set config -section:system.webServer/httpErrors -errorMode:Detailed
August 22nd, 2011, 09:59 PM
Most likely reason is that you need to set NTFS permissions on the folder where the database is located to include the IIS_USR... account or any user account you are using for IIS access permissions, to have modify permissions as it will need to read, modify and create files in that directory, namely the database itself and perhaps even the database lock file.
January 13th, 2012, 04:56 AM
the odbc connection can not occurs in my system.