ODBC on Server 2008

I’ve mentioned before (somewhere on here I think) that I have a background in (amongst other things) what I believe is now called “classic” ASP development – my career took me in a direction away from web development and I didn’t really spend a lot of time keeping my hand in, so now in 2009/10 when the need for a bit of webdev comes back around I’ve picked up where I left off.

I will, in the fullness of time, ease myself into ASP.NET but I still believe, strongly, that classic ASP has it’s place – and without wanting to blow my own trumpet I have been able to hand code 100s or possibly 1000s of pounds worth of dynamic features on our web platforms, with much more to come.

My old brain being what it is I really struggle to recall the stuff I’ve learned over the years so I do have to force myself to learn parrot-fashion or better yet, take copious notes!

So back to the present, I now have a 2008 Server test/dev box at home to tinker about with and this weekend, while fighting cold/flu I figured I’d get it setup.

Hang on, where’s the Access ODBC options?

In the good old classic ASP days the company I worked for produced feature-rich websites (I don’t think we called them applications back then!) that provided the customer administrative sections backed by databases connected via ODBC, hosting providers charged less for this option than something like MySQL databases. (And we could add multiple tables into the single file)

So I’m sat here in my paracetamol/flu weakened state flapping about wondering why on my 2008 box I can’t find the old Access ODBC drivers.

It’s the brave new 64 bit world!  If you look in the administrative tools folder (of control panel) you’ll see the Data Sources (ODBC) option, but open it up and from the System DSN tab the only driver you’ll appear to be able to use is SQL Server.

However, if you create a shortcut to;

C:\Windows\SysWOW64\odbcad32.exe

And open it up, you’ll find that the good old list of ODBC drivers are back.

The reason for this….

This is because the 64-bit version of ODBC Data Source Administrator only lists 64-bit version of drivers. To view 32-bit version of ODBC Driver, you can use the C:\Windows\SysWOW64\odbcad32.exe instead.

Time to get to some classic ASP!

http://forums.iis.net/t/1146917.aspx

Leave a Comment

THE PERSONAL BLOG OF CORNWALL-BASED COMPANY DIRECTOR // CHRIS RICKARD