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:
Scott A. Stewart,
Web Application Developer
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 300
Chantilly, VA 20151
Phone: (703) 995-1737
Fax: (703) 834-5527
"Many thousands of years ago, a blue faced Pict stepped on a bloated sheep
carcass... and thus the Pipes were born"
.... the Scottish Rogues
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.9.6/59 - Release Date: 07/27/2005
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213236
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
