ODBC Socket ERROR

[ewl2]

I have a a sql 6.5 that i connect to using odbc sockets on CF 7. It worked
fine on my dev machine, but when i installed cf 7 on my production box and
created the data source I got the following error:

Connection verification failed for data source: 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.

My research on this problem all deals with the mX 7 odbc services not running.
Both services are running....

ANY Ideas??

[Sarge]

Have you verified the connection using the MS Data Source Administrator? Can
you telnet to port 1433 on the SQL Server box? Is the SQL Server box listening
on port 1433 (or whatever port you have SQL Server bound to)?

[ewl2]

Yes, the datasource verifies ok, in the windows odbc admin screen. We actually had cf MX 6 on the machine previously and had no problems connecting using the socket.

[er1]

The ports for the ODBC socket services have been changed in MX 7 from 19997 and
19998 to 19995 and 19996.
However, in my experience, existing ODBC socket datasources and even the
default port for new ODBC socket datasources do NOT get updated when you
upgrade from 6.x to 7.x. You have to do that manually. You can change both of
these in cfusion\lib\neo-query.xml.

Does that help?

[IMHO it would be a great help if MM could include this info in the release
notes and KB tn_18800, etc.]

[ewl2]

That worked..........

Thank you so much, i was at my wits end trying to figure that out. Since
the releases were so similar, we copied the neo-query.xml so we didn't have to
recreate all our datasources.... oops

Macromedia, please put this in a technote, as it is almost impossible to
diagnose this problem

thanks for your help