Here are the settings for one Datasource, I put in some dummy data for datasource name etc.. All my datasources have these same settings.
Data Source Name - "Datasource Name" Database - "Database Name" Server - "0.0.0.0" Port - 1433 Username Password Description Select Method - "Direct" Limit Connections - Not Checked Restrict connections to - Blank Maintain Connections - Checked String Format - Not Checked Timeout (min) - 20 Interval (min) - 7 Disable Connections - Not Checked Login Timeout (sec) - 30 CLOB - Not Checked BLOB - Not Checked Long Text Buffer (chr) - 64000 Blob Buffer(bytes) - 64000 Allowed SQL SELECT Create GRANT INSERT DROP REVOKE UPDATE ALTER Stored Procedures DELETE Ben -----Original Message----- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 3:43 PM To: CF-Talk Subject: Re: CFMX - I've never seen anything so unstable in my life On Monday, Oct 7, 2002, at 12:21 US/Pacific, Ben Densmore wrote: > Here are the answers to your questions. > - OS / patch level - Win2k SP3 > - Database / patch level - SQL Server 7 SP4 > - Is the DB on a separate machine? - Yes > - Which driver are you using specifically? > -macromedia.jdbc.MacromediaDriver > - How often do you see this? - Happens daily about every 2-5 minutes > - Does it seem to be connected to any other network issues? - We've > never had any problems with CF 4.5 > - Are there other errors in the CF logs? - No Hmm, doesn't sound like an unusual setup. That's a very frequent error rate tho'... What is the full data source configuration, including Advanced Settings? Sean A Corfield -- http://www.corfield.org/blog/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.