--
Love Lucee? Become a supporter and be part of the Lucee project today! - http://lucee.org/supporters/become-a-supporter.html
---
You received this message because you are subscribed to a topic in the Google Groups "Lucee" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/lucee/1il7osoO58A/unsubscribe.
To unsubscribe from this group and all its topics, send an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/7922d9ac-7f7b-44be-acd4-bdbc1110c29e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Sid,
Have a look in the source of the Lucee Administrator. There you’ll find the file services.datasource.create.cfm. There it has the following entry:
<cfadmin action="updateDatasource" type="#request.adminType#" password="#session["password"&request.adminType]#"
classname="#driver.getClass()#"
dsn="#driver.getDSN()#"
name="#form.name#"
newName="#form.newName#"
host="#form.host#"
database="#form.database#"
port="#form.port#"
timezone="#form.timezone#"
dbusername="#form.username#"
dbpassword="#form.password#"
connectionLimit="#form.connectionLimit#"
connectionTimeout="#form.connectionTimeout#"
metaCacheTimeout="#form.metaCacheTimeout#"
blob="#getForm('blob',false)#"
clob="#getForm('clob',false)#"
validate="#getForm('validate',false)#"
storage="#getForm('storage',false)#"
allowed_select="#getForm('allowed_select',false)#"
allowed_insert="#getForm('allowed_insert',false)#"
allowed_update="#getForm('allowed_update',false)#"
allowed_delete="#getForm('allowed_delete',false)#"
allowed_alter="#getForm('allowed_alter',false)#"
allowed_drop="#getForm('allowed_drop',false)#"
allowed_revoke="#getForm('allowed_revoke',false)#"
allowed_create="#getForm('allowed_create',false)#"
allowed_grant="#getForm('allowed_grant',false)#"
verify="#verify#"
custom="#custom#"
dbdriver="#dbdriver#"
remoteClients="#request.getRemoteClients()#">
<cfset form.mark="update">
I presume the bold line above is what you are looking for…
Sincerely
Gert Franz
RASIA GmbH
Spittelgasse 7
5103 Moeriken-Wildegg
Switzerland
Email: ge...@rasia.ch
Skype: gert.franz
Phone Switzerland: +41 76 5680 231
--
Love Lucee? Become a supporter and be part of the Lucee project today! - http://lucee.org/supporters/become-a-supporter.html
---
You received this message because you are subscribed to the Google Groups "Lucee" group.
To unsubscribe from this group and stop receiving emails from it, send an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/29f488e2-f933-4be0-ad05-bd02c63fb682%40googlegroups.com.
You received this message because you are subscribed to a topic in the Google Groups "Lucee" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/lucee/1il7osoO58A/unsubscribe.
To unsubscribe from this group and all its topics, send an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/04d401d191bd%240f445d00%242dcd1700%24%40rasia.ch.
For more options, visit https://groups.google.com/d/optout.
<image001.png>
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/CAJ-%2Bs7vMvUSTVUY54wAwL%2BzVwH4sVcuGPDvN4ybxn4g-etHtFA%40mail.gmail.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/2ABD2BCF-224D-4A03-B1D4-1F4C195A4CAB%40rasia.ch.
For more options, visit https://groups.google.com/d/optout.
Hi Sid,
Just tried this:
<cfadmin action="updateDatasource" type="web" password="********"
classname="com.microsoft.sqlserver.jdbc.SQLServerDriver"
dsn="jdbc:sqlserver://{host}:{port}"
name="susi"
newName="susi"
host="localhost"
database="GIAppl"
port="1433"
dbusername="youruser"
dbpassword="********"
storage="true"
>
And it perfectly works as expected…
Sincerely
Gert Franz
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/CAJ-%2Bs7tQ4n_HzzfrNCMUZx0G36%3DmdVeedmYQ1hE7fDgPzLWzWQ%40mail.gmail.com.