ODBC Connection Problems CFMX 7

[sdsinc_pmascari]

We are at the beginning stages of upgrading our servers from ColdFusion 5 to
CFMX 7. We are running Windows 2000 and IIS with all patches and Service Packs
installed. Our database is MySQL. In CF5, to connect to MySQL, we simply
create the DSNs on Windows and CF detected them, listed them in CFAdmin, and
used them without a problem. After upgrading the system, all the MySQL
connections were converted to ODBC Socket Drivers. My understanding was this
meant it was simply 'connected' to the Windows ODBC list and would use the
appropriate drivers. However, we can not get CFMX 7 to connect using this
driver. The error we receive is: Connection verification failed for data
source: db-test java.sql.SQLException: [Macromedia][SequeLink JDBC
Driver]TCP/IP error, connection refused. The root cause was that:
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver]TCP/IP error,
connection refused. We have verified all passwords are correct and we can
still connect through the Windows control panel. For now, all ports are open
until we get this fixed. If we delete the datasource from CFAdmin and re-enter
it using the built-in CF MySQL driver, the connection will then work with no
problem. However, I'd like to figure out why the ODBC Socket driver does not
work. Lastly, we also have several application that read user uploaded Excel
files. The way we did this was set up Windows datasources for these files. In
CF 5 it was treated as any other datasource and things were good. Now, it also
has the ODBC Socket driver and we can no longer connect. Nothing we've tried
can get us connected to these Excel files. The error we get is the same as we
get for the MySQL connections, above. Any ideas?

[gclausen]

There are two Windows Services that need to be running and functioning properly
for the CFADMIN ODBC Socket driver to work, they are "ColdFusion MX 7 ODBC
Agent" and "ColdFusion MX 7 ODBC Server".

Try...
restarting the Services
creating your own CFADMIN datasource and pointing it at the ODBC DSN
uninstalling then reinstalling the two Services,
[url]http://www.macromedia.com/go/tn_19135[/url] (written for CFMX 6.1 but will work for
7.0 as well)

[sdsinc_pmascari]

I deleted the datasources and re-entered them, this time as ODBC Connectors
again rather than MySQL, and that seemed to work. Apparently the conversion
when upgrading from CF 5 simply doesn't work properly. That leads to a new
question: I'm now faced with deleting and re-entering dozens of datasources on
several servers. Is there a script that can do this or a way to back up
CFAdmin settings and import them to another machine?