[Macromedia][SequeLink JDBC Driver]TCP/IP error, connection refused.

[ECSWebAdmin]

We've gotten this error randomly on all 24 of our CF installations.
It's trying to make a socket call to an ODBC Instance to a FoxPro
freetable directoy.

Any ideas as to the root cause?

Error Executing Database Query.

[Macromedia][SequeLink JDBC Driver]TCP/IP error, connection refused.

The error occurred in D:\Docwf\Navigation\qry_RptsbyStatusDate.cfm:
line 51 Called from D:\Docwf\Navigation\fbx_Switch.cfm: line 27 Called
from D:\Docwf\Navigation\fbx_Switch.cfm: line 17 Called from
D:\Docwf\Navigation\fbx_Switch.cfm: line 1 Called from
D:\Docwf\fbx_fusebox30_CF50.cfm: line 241 Called from
D:\Docwf\fbx_fusebox30_CF50.cfm: line 1 Called from
D:\Docwf\fbx_fusebox30_CF50.cfm: line 1 Called from D:\Docwf\index.cfm:
line 37 Called from D:\Docwf\Navigation\qry_RptsbyStatusDate.cfm: line
51 Called from D:\Docwf\Navigation\fbx_Switch.cfm: line 27 Called from
D:\Docwf\Navigation\fbx_Switch.cfm: line 17 Called from
D:\Docwf\Navigation\fbx_Switch.cfm: line 1 Called from
D:\Docwf\fbx_fusebox30_CF50.cfm: line 241 Called from
D:\Docwf\fbx_fusebox30_CF50.cfm: line 1 Called from
D:\Docwf\fbx_fusebox30_CF50.cfm: line 1 Called from D:\Docwf\index.cfm:
line 37

49 : FROM reports
50 : WHERE DTOS(date_cast)+project+set_letter BETWEEN
'#DateFormat(mintestDT,"yyyymmdd")#'
51 : AND '#DateFormat(DateAdd('d',1,now()),"yyyymmdd")#'
52 : Order by maxtestdat
53 : </cfquery>


--------------------------------------------------------------------------------


SQL
SELECT distinct key as CWHKEY, date_cast as maxtestdat, apk_repid FROM
reports WHERE DTOS(date_cast)+project+set_letter BETWEEN '20050725' AND
'20050729' Order by maxtestdat

DATASOURCE
DocWF_VFP
Please try the following:

[Peter Tilbrook]

FoxPro is pretty old now. Perhaps you need updated drivers? Macromedia
themselves would be the best ppl to contact. Not knocking FoxPro but it
is quite old - and with SQL Server, Oracle, MySQL et al...

What version of CF are you running? MX7 supports a wide array of
database servers and OS's - with Merrimack (the updater) adding even
more. And then there is CF8 (aka Scorpio)...

Post by ECSWebAdmin
We've gotten this error randomly on all 24 of our CF installations.
It's trying to make a socket call to an ODBC Instance to a FoxPro
freetable directoy.
Any ideas as to the root cause?
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver]TCP/IP error, connection refused.
line 51 Called from D:\Docwf\Navigation\fbx_Switch.cfm: line 27 Called
from D:\Docwf\Navigation\fbx_Switch.cfm: line 17 Called from
D:\Docwf\Navigation\fbx_Switch.cfm: line 1 Called from
D:\Docwf\fbx_fusebox30_CF50.cfm: line 241 Called from
D:\Docwf\fbx_fusebox30_CF50.cfm: line 1 Called from
line 37 Called from D:\Docwf\Navigation\qry_RptsbyStatusDate.cfm: line
51 Called from D:\Docwf\Navigation\fbx_Switch.cfm: line 27 Called from
D:\Docwf\Navigation\fbx_Switch.cfm: line 17 Called from
D:\Docwf\Navigation\fbx_Switch.cfm: line 1 Called from
D:\Docwf\fbx_fusebox30_CF50.cfm: line 241 Called from
D:\Docwf\fbx_fusebox30_CF50.cfm: line 1 Called from
line 37
49 : FROM reports
50 : WHERE DTOS(date_cast)+project+set_letter BETWEEN
'#DateFormat(mintestDT,"yyyymmdd")#'
51 : AND '#DateFormat(DateAdd('d',1,now()),"yyyymmdd")#'
52 : Order by maxtestdat
53 : </cfquery>
--------------------------------------------------------------------------------
SQL
SELECT distinct key as CWHKEY, date_cast as maxtestdat, apk_repid FROM
reports WHERE DTOS(date_cast)+project+set_letter BETWEEN '20050725' AND
'20050729' Order by maxtestdat
DATASOURCE
DocWF_VFP