Re: Coldfusion 8 Adminapi Datasource problem
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
>/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
Re: Coldfusion 8 Adminapi Datasource problem
This sounds like a bug in the admin then. If the back end supports < 60 seconds, the admin should support it as well, right? On 10/22/07, Hareni Venkatramanan <[EMAIL PROTECTED]> wrote: > Hi John, > > In the function myObj.setMSSQL(), the values of timeout and interval > are specified in seconds ( pl. refer > /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 > -- === Raymond Camden, Camden Media Email: [EMAIL PROTECTED] Blog : www.coldfusionjedi.com AOL IM : cfjedimaster Keep up to date with the community: http://www.coldfusionbloggers.org ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291739 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Coldfusion 8 Adminapi Datasource problem
Hi John,
In the function myObj.setMSSQL(), the values of timeout and interval
are specified in seconds ( pl. refer
/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
Re: Coldfusion 8 Adminapi Datasource problem
Hmm, I was hoping I'd see something simple. I'd suggest logging a bug report (www.adobe.com/go/wish). Sorry I couldn't help. On 10/19/07, John Elkins <[EMAIL PROTECTED]> wrote: > >Care to show the code? > > > > > >> > > >Care to show the code? > -- === Raymond Camden, Camden Media Email: [EMAIL PROTECTED] Blog : www.coldfusionjedi.com AOL IM : cfjedimaster Keep up to date with the community: http://www.coldfusionbloggers.org ~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291668 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion 8 Adminapi Datasource problem
>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=basiconfig_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 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291644
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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=basiconfig_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
~|
Enterprise web applications, build robust, secure
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291645
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion 8 Adminapi Datasource problem
Care to show the code? On 10/19/07, John Elkins <[EMAIL PROTECTED]> wrote: > Hello all, > > I was wondering if anyone has been experiencing an issue with the Coldfusion > 8 datasource api. I have been able to successfully create a datasource, but > two of the paramaters I am passing back are not being set... those are > Timeout & Interval. I am specifying values for them, but when I go to check > the datasource in the administrator they alway have a value of 0. > > Any thoughts as to why this might be occurring? > > 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:291613 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
