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
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?