Notices

Great community. Great ideas.

Welcome to ASP/Free, a community dedicated to helping beginners and professionals alike in improving their knowledge of Microsoft's development and administration technologies. Sign up today to gain access to the combined insight of tens of thousands of members.

Thread: ODBC Connection Issue

Results 1 to 5 of 5
Share This Thread →
  1. #1
    AndrewT is offline Contributing User
    Join Date
    Mar 2008
    Posts
    341
    Rep Power
    8

    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?

  2. #2
    markoc's Avatar
    markoc is offline Contributing User
    Join Date
    Nov 2003
    Location
    UK
    Posts
    2,280
    Rep Power
    310

    ODBC Connection Issue

    Hi,

    Microsoft doesnít provide a 64-bit version of the Microsoft OLE DB Provider for Jet, so Iím assuming that you set up the connection using the 32bit version of the ODBC exe?
    Normally found in c:\Windows\SysWOW64\odbcad32.exe, creating a DSN connection.

    'There is a problem with the resource you are looking for, and it cannot be displayed' error message by default is displayed to remote clients, detailed error messages on show on localhost.
    You can elevate the error message to remote users, but this should really only be used on your dev version. Not recommended for production.
    Run the following from an elevated command prompt on the IIS server
    %windir%\system32\inetsrv\appcmd.exe set config -section:system.webServer/httpErrors -errorModeetailed
    Iím assuming your front end is classic asp?
    Something you need to think about is that if your getting more users to connect, MS Access is a single threaded database, so it might be time to think about upgrading to something like MS SQL server.
    Hope this advise helps.

    If so please show your appreciation by adding reputation points (click gauge image on top right of this post and score).

  3. #3
    markoc's Avatar
    markoc is offline Contributing User
    Join Date
    Nov 2003
    Location
    UK
    Posts
    2,280
    Rep Power
    310

    ODBC Connection Issue

    elevated command prompt should read
    Code:
    %windir%\system32\inetsrv\appcmd.exe set config -section:system.webServer/httpErrors -errorMode:Detailed

  4. #4
    q97
    q97 is offline Contributing User
    Join Date
    Apr 2005
    Location
    Brisvegas
    Posts
    439
    Rep Power
    112
    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.

  5. #5
    jakson0100 is offline Permanently Banned
    Join Date
    May 2011
    Posts
    120
    Rep Power
    0
    the odbc connection can not occurs in my system.

Share This Thread →

Become Part of This Conversation

Join NowFor Free!

Similar Threads

  1. ODBC Setup - connection error for MS SQL Server Desktop Engine
    By dt_aiying in forum Microsoft SQL Server
    Replies: 1
    Last Post: May 26th, 2007, 06:46 PM
  2. Code help and clean up!!!
    By purelife in forum ASP Development
    Replies: 2
    Last Post: April 21st, 2007, 10:44 PM
  3. ODBC enable database connection
    By gospel in forum ASP Development
    Replies: 0
    Last Post: August 22nd, 2005, 07:42 PM
  4. RDB With ODBC Connection Recordset Access
    By AnnaChen in forum ASP Development
    Replies: 0
    Last Post: December 1st, 2004, 02:41 PM
  5. Problem with : Database Connection or Parameters ?
    By Elankathir in forum ASP Development
    Replies: 1
    Last Post: July 1st, 2004, 12:08 AM

ASP Free Advertisers and Affiliates