Cannot add new Access datasource

[MikeLF]

hi, I?m using CF 6.1, when I try to add a new Microsoft Access datasource from
the CF admin I get the following error: The ColdFusion MX ODBC Server service
is not running or has not been installed. I looked for this service on my
control panel services applet and could not find it. Any ideas?

[EWUEagle]

Try selecting microsoft access with unicode driver. This works in MX 7 so maybe it will work for you

[MikeLF]

When I select the unicode driver, queries to access databases with linked
tables to SQL Server fail to execute. I get the following error: Cannot
connect to "SQL_Server_datasource_name". I tested the SQL server datasource
and works fine.

That is why I was trying with the standard MSAccess driver to see if it
worked. Too bad I can{t even create a standard Access datasource.

[jorgepino]

you may need to update Microsoft Data Access Components (MDAC)
[url]http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&displaylang=en[/url]

[MikeLF]

It?s a fresh Windows server 2003 installation. I checked MDAC with Microsoft
component checker and it shows MDAC 2.8 sp2 on windows server 2003. CF creates
and checks Access DB datasources OK (when using the unicode driver). The
problem comes when a query tries to access a linked SQL Server table.

I installed Access on the CF machine, opened Access, opened the database,
opened the linked tables with no problem. CF seems to have a problem with
linked tables when using Access.