Connection string problems with DLL/Delphi 2006

[Andrew Tucker]

Hi, I have a large intraweb application which is trying to connect to a mysql database. When running in Intraweb standalone mode it connects fine using the connection string below. However when I use the DLL on a local host ISAPI web server, I get an error saying 'datasource name not found and no default driver specified'
I've tried changing initial catalog= to database= but it still doesn't work. I've also tried a variety of other connection strings but none appear to work.

Provider=MSDASQL.1;Password=albacore;Persist Security Info=True;User ID=root;Data Source=DanceDirector;Mode=ReadWrite;Initial Catalog=uniquefitness

The datasource DanceDirector is set up in ODBC on my machine.

Any help much appreciated - MySQL 5.1 Connector ODBC and Delphi 2006.

Regards,
Andy Tucker.