This is a multi-part message in MIME format. --------------FA9C9820985FC6186AB33304 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I am running CF on an NT4 web server and Sybase SQL Anywhere on another NT4 server. The web server uses Sybase's dbclient and an ODBC datasource to communicate with the SQL server. It appears that after a period of database inactivity (the exact length of time I don't know, but I believe it's at least an hour), the client connection closes and I get the error below. If I relaod the page, the connection is re-established and the error goes away. I also get this error after the SQL server is stopped and then restarted, the first user will get this error. This happens with all CF web sites, simultaneously, that are using the same datasource. Does anyone know how I can stop this from happening? The error message:...... Error Diagnostic Information ODBC Error Code = 08003 (Connection not open) [Sybase][ODBC Driver]Connection not open: not connected to SQL database SQL = "SELECT li_sub_cat."category", li_sub_cat."sub_cat" FROM "AFM"."li_sub_cat" li_sub_cat WHERE li_sub_cat."category" = 'Cherry' ORDER BY li_sub_cat."category" ASC, li_sub_cat."sub_cat" ASC" Data Source = "IWCOM" Ron Eberhard --------------FA9C9820985FC6186AB33304 Content-Type: text/x-vcard; charset=us-ascii; name="ron.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Ronald Eberhard Content-Disposition: attachment; filename="ron.vcf" begin:vcard n:Eberhard;Ron tel;work:516-997-5580 x-mozilla-html:TRUE url:http://www.iwcom.com org:Internet Worldwide Communications, Inc. adr:;;194 Lewis Ave.;Westbury;NY;11590-2106; version:2.1 email;internet:[EMAIL PROTECTED] title:President note;quoted-printable:Secondary Weekday Phone: 212-537-1213 - =0D=0ASpecializing in dynamic, interactive, business web sites using databases x-mozilla-cpt:;-26864 fn:IWCOM.COM - Ron Eberhard end:vcard --------------FA9C9820985FC6186AB33304-- ------------------------------------------------------------------------------ Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
