Hi John, In the function myObj.setMSSQL(....), the values of timeout and interval are specified in seconds ( pl. refer <cf_root>/CFIDE/adminapi/datasource.cfc for APIs), whereas in admin, the interval and timeout values are displayed in mins. Therefore, in your example (20/60) is rounded off to zero.
Thanks, Hareni -----Original Message----- From: John Elkins [mailto:[EMAIL PROTECTED] Sent: 20 October 2007 06:57 To: CF-Talk Subject: Re: Coldfusion 8 Adminapi Datasource problem >Care to show the code? > > >> >Care to show the code? Sure. I used an example from CF8 live docs... which actually has an error: http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=basico nfig_37.html ("setStringParameterAsUnicode" should be "sendStringParametersAsUnicode") myObj.setMSSQL(driver="MSSQLServer", name = "#newdsn#", host = "#databaseServerIP#", port = "1433", database = "#dbname#", username = "#databaseUID#", password = "#databasePWD#", login_timeout = 30, timeout = 20, interval = 7, buffer = 64000, blob_buffer = 64000, sendStringParametersAsUnicode = true, description = "", pooling = true, maxpooledstatements = 1000, enableMaxConnections = false, maxConnections = 0, enable_clob = false, enable_blob = false, disable = false, selectmethod = "direct", storedProc = true, alter = true, grant = false, select = true, update = true, create = true, delete = true, drop = true, revoke = false ); } I am setting Timeout = 20 and Interval = 7. The datasource gets created properly with all the other parameters specified, but these remain 0's. Thanks, John ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291729 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
