Thanks, Hareni. That was the problem. I should have paid more attention to the api values. It worked perfectly.
Thanks also Ray for responding to my question. Regards, John >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 > > >>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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291767 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
