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.

Reply via email to