+ Post New Thread
Results 1 to 6 of 6
Windows Server 2008 R2 Thread, School booking system on Server 2008 R2 in Technical; We are currently using the Devizes School Booking system which has been a great piece of software on 2003 but ...
  1. #1
    timbo343's Avatar
    Join Date
    Dec 2005
    Location
    Leeds/York area, North Yorkshire
    Posts
    3,096
    Thank Post
    314
    Thanked 296 Times in 206 Posts
    Rep Power
    122

    School booking system on Server 2008 R2

    We are currently using the Devizes School Booking system which has been a great piece of software on 2003 but the only trouble is now, we are planning on moving over to Server 2008 R2 over the summer and I am having massive problems with accessing the database.

    I have checked the permissions on the "databases" folder, they are all ok and made sure the settings in the asp files are correct.

    I have narrowed it down to the ODBC driver not having the correct drivers in for the *.mdb file where the databases are stored, but i cannot, for the life of me get the 32 bit ODBC drivers to work on the 64 bit ODBC drivers.

    The 64 bit drivers are located in System32\odbcad32.exe and the 32 bit drivers are located in SysWOW64\odbcad32.exe.

    Can anyone help me out on this issue? A lot of the web suggestions say

    "run C:\WINDOWS\SysWOW64\odbcad32.exe

    this should bring the odbc Data source administrator (see if you have the 32 bit drivers listed for Microsoft access )
    if you see it, set up your DSN ..."

    but how do I set up a DSN?

    Thanks

    Tim
    Last edited by timbo343; 5th March 2010 at 11:12 AM.

  2. #2

    Join Date
    Feb 2008
    Location
    Wiltshire
    Posts
    897
    Thank Post
    282
    Thanked 140 Times in 113 Posts
    Blog Entries
    28
    Rep Power
    42
    I'm in the same boat, trying to get it working on 2008 64Bit also.

    Have you changed the Application Pool to 32bit? This should kick in the 32Bit JET Drivers... Well thats what all the documentation says but I still can't get it to access the database either!

    Let us know if you have any success.

    Pete

  3. #3
    timbo343's Avatar
    Join Date
    Dec 2005
    Location
    Leeds/York area, North Yorkshire
    Posts
    3,096
    Thank Post
    314
    Thanked 296 Times in 206 Posts
    Rep Power
    122
    I saw your post over the weekend and thought i should let you know that i have managed to get to the database but am now having a problem with the authentication. With regards to the booking system instruction guide, follow the instructions up to moving database files.

    Once you have moved the active folder to wwwroot, Run IIS and right click on the Active web folder >>Convert to application >> Then in the new window, click the Select button and select Classic .net AppPool from the drop down list. Click ok, and set the connect as user. I have just used the admin account for now. Once you have set the account, test it.

    Now in IIS you have something called Application Pool from the left menu, above sites. Click Application Pools and then right click the Classic .net AppPool >> select set Application Pool Defaults >> under the general section you will see Enable 32bit applications, set this to true and click ok.

    Now click Active from default web site and select ASP. In here find enable parent paths and set it to true and save the settings.

    Thats how i got the database to run and like i said, im just trying to get the authentication to work, but not having much luck.

    Hope this helps

    Tim

  4. 3 Thanks to timbo343:

    FragglePete (14th April 2010), joe90bass (28th July 2011), tazz (29th July 2010)

  5. #4

    Join Date
    Feb 2008
    Location
    Wiltshire
    Posts
    897
    Thank Post
    282
    Thanked 140 Times in 113 Posts
    Blog Entries
    28
    Rep Power
    42
    Thanks for the info, tried the above but still no joy.

    I'll take another closer look later; bloody annoying.

    Pete

  6. #5
    timbo343's Avatar
    Join Date
    Dec 2005
    Location
    Leeds/York area, North Yorkshire
    Posts
    3,096
    Thank Post
    314
    Thanked 296 Times in 206 Posts
    Rep Power
    122
    Yeah, tell me about it. Hmmm, i dont understand why yours is failing. Ive just managed to get it working on another install of 2008 R2.

  7. #6

    Join Date
    Jan 2014
    Location
    Rossendale
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    To install AD integration on 2008 r2 server manager - roles - IIS - add roles - under security add windows authentication. Launch IIS click on website - chose authentication - enable windows authentication disable Anonymous authentication. Try logging in all should work fine.

SHARE:
+ Post New Thread

Similar Threads

  1. Devizes Booking System server 2008
    By mtdmitchell in forum Network and Classroom Management
    Replies: 6
    Last Post: 15th February 2011, 09:27 AM
  2. Installing Devizes booking system on server 2008?
    By reggiep in forum How do you do....it?
    Replies: 11
    Last Post: 9th April 2010, 08:56 AM
  3. Devizes School Online Booking System
    By plock in forum Network and Classroom Management
    Replies: 33
    Last Post: 9th September 2009, 10:09 AM
  4. System drive space for server 2008 VM
    By cookie_monster in forum Windows Server 2008
    Replies: 12
    Last Post: 15th July 2009, 08:37 AM
  5. Schools without IT Booking system
    By Outpost in forum Network and Classroom Management
    Replies: 14
    Last Post: 5th May 2009, 09:57 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •