Can't connect using ODBC

[IPGRuss]

I'm having problems connecting to a Navision database using the ODBC socket in
CFAdmin. I updated the SequeLink like stated in KBe917887 but my version
number of SequeLink comes up as 5.3.001902 and my SQLServer driver comes up as
version 3.2.006918003414004421. I'm running CFMX6 on Windows XP with IIS.
This is from the logging file for SequeLink:

Tue Apr 18 11:17:15 2006:SLX ODBC Socket. Build 0097
Tue Apr 18 11:17:15 2006:Connection request from 127.0.0.1, client application
JDBC
Tue Apr 18 11:17:15 2006:INTRANET2(1 CPU) - Microsoft Windows 2000(5.1-Service
Pack 2 (Build 2600))
Tue Apr 18 11:17:15 2006:The specified data source is not defined.

According to the build number it's the latest.

I can query the ODBC from Excel and Access so I know it's not on the ODBC side.

I know the datasource exists in ODBC for Windows. Any help?

[ksmith]

First, if you are truly run cfmx 6.0 you should start by updating to cfmx6.1
updater1. There are many fixes and enhancements in 6.1.

I believe Navision is really just a specialised mssql server. If that is so,
you really should use a JDBC connection and not ODBC. JDBC is a much better
connection from CFMX than ODBC. The latest macromedia drivers even support
NTauthentication.

You can update to the latest JDBC drivers
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=42dcb10a[/url] You need
to have these JDBC drivers to the latest version of sequellink. You can update
to the latest sequellink [url]http://www.macromedia.com/go/e917887[/url]

The sequellink technote also gives you troubleshooting procedures. You can
also use the windows odbc manager to turn on odbc tracing. With odbc tracing
on, attempt to connect to your navision db. Also test a query. Then review
the trace to see if you can locate the error.