OT: Using DSN with CF7?

Report · Apr 02, 2007

I have someone telling me that I cannot do this. Is that correct?

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.dreamweavermx-templates.com - Template Triage!
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
==================

Report · Apr 02, 2007

That would be with CF7 and MySQL....

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.dreamweavermx-templates.com - Template Triage!
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
==================

"Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote in message
news:eursfg$b21$1@forums.macromedia.com...
>I have someone telling me that I cannot do this. Is that correct?
>
> --
> Murray --- ICQ 71997575
> Adobe Community Expert
> (If you *MUST* email me, don't LAUGH when you do so!)
> ==================
> http://www.dreamweavermx-templates.com - Template Triage!
> http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
> http://www.dwfaq.com - DW FAQs, Tutorials & Resources
> http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
> ==================
>
>
>

Report · Apr 02, 2007

Murray,

No you can't use it, you need a datasource defined in the CF Admin.

"Deprecated the connectString, dbName, dbServer, provider, providerDSN, and sql attributes, and all values of the dbtype attribute
except query. They do not work, and might cause an error, in releases later than ColdFusion 5."

http://livedocs.adobe.com/coldfusion/7/htmldocs/00000316.htm#1102316

--
Ken Ford
Adobe Community Expert
Fordwebs, LLC
http://www.fordwebs.com

"Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote in message news:eurtdu$c50$1@forums.macromedia.com...
> That would be with CF7 and MySQL....
>
> --
> Murray --- ICQ 71997575
> Adobe Community Expert
> (If you *MUST* email me, don't LAUGH when you do so!)
> ==================
> http://www.dreamweavermx-templates.com - Template Triage!
> http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
> http://www.dwfaq.com - DW FAQs, Tutorials & Resources
> http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
> ==================
>
>
> "Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote in message news:eursfg$b21$1@forums.macromedia.com...
>>I have someone telling me that I cannot do this. Is that correct?
>>
>> --
>> Murray --- ICQ 71997575
>> Adobe Community Expert
>> (If you *MUST* email me, don't LAUGH when you do so!)
>> ==================
>> http://www.dreamweavermx-templates.com - Template Triage!
>> http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
>> http://www.dwfaq.com - DW FAQs, Tutorials & Resources
>> http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
>> ==================
>>
>>
>>
>
>

Report · Apr 02, 2007

Isn't that a DSN?

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.dreamweavermx-templates.com - Template Triage!
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
==================

"Ken Ford - *ACE*" <newsgroups@fordwebs.com> wrote in message
news:euruie$dgp$1@forums.macromedia.com...
> Murray,
>
> No you can't use it, you need a datasource defined in the CF Admin.
>
> "Deprecated the connectString, dbName, dbServer, provider, providerDSN,
> and sql attributes, and all values of the dbtype attribute except query.
> They do not work, and might cause an error, in releases later than
> ColdFusion 5."
>
> http://livedocs.adobe.com/coldfusion/7/htmldocs/00000316.htm#1102316
>
> --
> Ken Ford
> Adobe Community Expert
> Fordwebs, LLC
> http://www.fordwebs.com
>
>
> "Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote in message
> news:eurtdu$c50$1@forums.macromedia.com...
>> That would be with CF7 and MySQL....
>>
>> --
>> Murray --- ICQ 71997575
>> Adobe Community Expert
>> (If you *MUST* email me, don't LAUGH when you do so!)
>> ==================
>> http://www.dreamweavermx-templates.com - Template Triage!
>> http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
>> http://www.dwfaq.com - DW FAQs, Tutorials & Resources
>> http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
>> ==================
>>
>>
>> "Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote in message
>> news:eursfg$b21$1@forums.macromedia.com...
>>>I have someone telling me that I cannot do this. Is that correct?
>>>
>>> --
>>> Murray --- ICQ 71997575
>>> Adobe Community Expert
>>> (If you *MUST* email me, don't LAUGH when you do so!)
>>> ==================
>>> http://www.dreamweavermx-templates.com - Template Triage!
>>> http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
>>> http://www.dwfaq.com - DW FAQs, Tutorials & Resources
>>> http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
>>> ==================
>>>
>>>
>>>
>>
>>
>

Report · Apr 02, 2007

Murray

Yes it is. Basically with CF you only use DSN's to connect to databases.

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote in message
news:eurumq$don$1@forums.macromedia.com...
> Isn't that a DSN?
>
> --
> Murray --- ICQ 71997575
> Adobe Community Expert
> (If you *MUST* email me, don't LAUGH when you do so!)
> ==================
> http://www.dreamweavermx-templates.com - Template Triage!
> http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
> http://www.dwfaq.com - DW FAQs, Tutorials & Resources
> http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
> ==================
>
>
> "Ken Ford - *ACE*" <newsgroups@fordwebs.com> wrote in message
> news:euruie$dgp$1@forums.macromedia.com...
>> Murray,
>>
>> No you can't use it, you need a datasource defined in the CF Admin.
>>
>> "Deprecated the connectString, dbName, dbServer, provider, providerDSN,
>> and sql attributes, and all values of the dbtype attribute except query.
>> They do not work, and might cause an error, in releases later than
>> ColdFusion 5."
>>
>> http://livedocs.adobe.com/coldfusion/7/htmldocs/00000316.htm#1102316
>>
>> --
>> Ken Ford
>> Adobe Community Expert
>> Fordwebs, LLC
>> http://www.fordwebs.com
>>
>>
>> "Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote in message
>> news:eurtdu$c50$1@forums.macromedia.com...
>>> That would be with CF7 and MySQL....
>>>
>>> --
>>> Murray --- ICQ 71997575
>>> Adobe Community Expert
>>> (If you *MUST* email me, don't LAUGH when you do so!)
>>> ==================
>>> http://www.dreamweavermx-templates.com - Template Triage!
>>> http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
>>> http://www.dwfaq.com - DW FAQs, Tutorials & Resources
>>> http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
>>> ==================
>>>
>>>
>>> "Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote in message
>>> news:eursfg$b21$1@forums.macromedia.com...
>>>>I have someone telling me that I cannot do this. Is that correct?
>>>>
>>>> --
>>>> Murray --- ICQ 71997575
>>>> Adobe Community Expert
>>>> (If you *MUST* email me, don't LAUGH when you do so!)
>>>> ==================
>>>> http://www.dreamweavermx-templates.com - Template Triage!
>>>> http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
>>>> http://www.dwfaq.com - DW FAQs, Tutorials & Resources
>>>> http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
>>>> ==================
>>>>
>>>>
>>>>
>>>
>>>
>>
>
>

Report · Apr 02, 2007

The question is specific to CF7. I'm being told that you cannot use a DSN
with CF7, and I'm trying to get an answer here! 8)

So - is your response applicable to CF7 as well as CF in general?

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.dreamweavermx-templates.com - Template Triage!
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
==================

"Paul Whitham AdobeCommunityExpert" <design@valleybiz.net> wrote in message
news:eus0hi$ftk$1@forums.macromedia.com...
> Murray
>
> Yes it is. Basically with CF you only use DSN's to connect to databases.
>
> --
> Paul Whitham
> Certified Dreamweaver MX2004 Professional
> Adobe Community Expert - Dreamweaver
>
> Valleybiz Internet Design
> www.valleybiz.net
>
> "Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote in message
> news:eurumq$don$1@forums.macromedia.com...
>> Isn't that a DSN?
>>
>> --
>> Murray --- ICQ 71997575
>> Adobe Community Expert
>> (If you *MUST* email me, don't LAUGH when you do so!)
>> ==================
>> http://www.dreamweavermx-templates.com - Template Triage!
>> http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
>> http://www.dwfaq.com - DW FAQs, Tutorials & Resources
>> http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
>> ==================
>>
>>
>> "Ken Ford - *ACE*" <newsgroups@fordwebs.com> wrote in message
>> news:euruie$dgp$1@forums.macromedia.com...
>>> Murray,
>>>
>>> No you can't use it, you need a datasource defined in the CF Admin.
>>>
>>> "Deprecated the connectString, dbName, dbServer, provider, providerDSN,
>>> and sql attributes, and all values of the dbtype attribute except query.
>>> They do not work, and might cause an error, in releases later than
>>> ColdFusion 5."
>>>
>>> http://livedocs.adobe.com/coldfusion/7/htmldocs/00000316.htm#1102316
>>>
>>> --
>>> Ken Ford
>>> Adobe Community Expert
>>> Fordwebs, LLC
>>> http://www.fordwebs.com
>>>
>>>
>>> "Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote in message
>>> news:eurtdu$c50$1@forums.macromedia.com...
>>>> That would be with CF7 and MySQL....
>>>>
>>>> --
>>>> Murray --- ICQ 71997575
>>>> Adobe Community Expert
>>>> (If you *MUST* email me, don't LAUGH when you do so!)
>>>> ==================
>>>> http://www.dreamweavermx-templates.com - Template Triage!
>>>> http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
>>>> http://www.dwfaq.com - DW FAQs, Tutorials & Resources
>>>> http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
>>>> ==================
>>>>
>>>>
>>>> "Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote in message
>>>> news:eursfg$b21$1@forums.macromedia.com...
>>>>>I have someone telling me that I cannot do this. Is that correct?
>>>>>
>>>>> --
>>>>> Murray --- ICQ 71997575
>>>>> Adobe Community Expert
>>>>> (If you *MUST* email me, don't LAUGH when you do so!)
>>>>> ==================
>>>>> http://www.dreamweavermx-templates.com - Template Triage!
>>>>> http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
>>>>> http://www.dwfaq.com - DW FAQs, Tutorials & Resources
>>>>> http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
>>>>> ==================
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>
>>
>
>

Report · Apr 02, 2007

"Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote in message
news:eus14p$gl8$1@forums.macromedia.com...
> The question is specific to CF7. I'm being told that you cannot use a DSN
> with CF7, and I'm trying to get an answer here! 8)

It really depends on what do you mean as "DSN" :-))

Up to CF 5, a system DSN (most likely ODBC) was automatically available to
the CF Server as well. Since with version 6 CF moved to Java, database
connectivity is now handled by JDBC and in order to have a "datasource", you
have to explicity create it inside CF's Admin, either manually or using CF
Admin's API.

Does it answer your question? Please let me know if you need additional
clarifications

--
----------------------------
Massimo Foti, web-programmer for hire
Tools for ColdFusion and Dreamweaver developers:
http://www.massimocorner.com
----------------------------

Report · Apr 02, 2007

Thank you, Massimo. Suppose you do not have access to the CF Admin, and the
host is telling you that a) you must use a DSN-less connection, because b)
they have tried to bring up a DSN using the CF Admin, and were not
successful. What would you do?

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.dreamweavermx-templates.com - Template Triage!
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
==================

"Massimo Foti" <massimo@massimocorner.com> wrote in message
news:eus2rp$ill$1@forums.macromedia.com...
> "Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote in message
> news:eus14p$gl8$1@forums.macromedia.com...
>> The question is specific to CF7. I'm being told that you cannot use a
>> DSN with CF7, and I'm trying to get an answer here! 8)
>
> It really depends on what do you mean as "DSN" :-))
>
> Up to CF 5, a system DSN (most likely ODBC) was automatically available to
> the CF Server as well. Since with version 6 CF moved to Java, database
> connectivity is now handled by JDBC and in order to have a "datasource",
> you have to explicity create it inside CF's Admin, either manually or
> using CF Admin's API.
>
> Does it answer your question? Please let me know if you need additional
> clarifications
>
> --
> ----------------------------
> Massimo Foti, web-programmer for hire
> Tools for ColdFusion and Dreamweaver developers:
> http://www.massimocorner.com
> ----------------------------
>
>

Report · Apr 02, 2007

Change hosts!

That is a basic function of the CF Admin.

--
Ken Ford
Adobe Community Expert
Fordwebs, LLC
http://www.fordwebs.com

"Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote in message news:eus40q$jvc$1@forums.macromedia.com...
> Thank you, Massimo. Suppose you do not have access to the CF Admin, and the
> host is telling you that a) you must use a DSN-less connection, because b)
> they have tried to bring up a DSN using the CF Admin, and were not
> successful. What would you do?
>
> --
> Murray --- ICQ 71997575
> Adobe Community Expert
> (If you *MUST* email me, don't LAUGH when you do so!)
> ==================
> http://www.dreamweavermx-templates.com - Template Triage!
> http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
> http://www.dwfaq.com - DW FAQs, Tutorials & Resources
> http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
> ==================
>

Report · Apr 02, 2007

Yes, I think so. If the host says that they tried and weren't able to make
it work, and that as a result I will need to use a DSN-less connection,
rendering the request.dsn variables unusable, then it's a bad sign....

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.dreamweavermx-templates.com - Template Triage!
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
==================

"Ken Ford - *ACE*" <newsgroups@fordwebs.com> wrote in message
news:eus4a1$k8i$1@forums.macromedia.com...
> Change hosts!
>
> That is a basic function of the CF Admin.
>
> --
> Ken Ford
> Adobe Community Expert
> Fordwebs, LLC
> http://www.fordwebs.com
>
>
> "Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote in message
> news:eus40q$jvc$1@forums.macromedia.com...
>> Thank you, Massimo. Suppose you do not have access to the CF Admin, and
>> the host is telling you that a) you must use a DSN-less connection,
>> because b) they have tried to bring up a DSN using the CF Admin, and were
>> not successful. What would you do?
>>
>> --
>> Murray --- ICQ 71997575
>> Adobe Community Expert
>> (If you *MUST* email me, don't LAUGH when you do so!)
>> ==================
>> http://www.dreamweavermx-templates.com - Template Triage!
>> http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
>> http://www.dwfaq.com - DW FAQs, Tutorials & Resources
>> http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
>> ==================
>>
>

Report · Apr 02, 2007

"Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote in message
news:eus40q$jvc$1@forums.macromedia.com...
> Thank you, Massimo. Suppose you do not have access to the CF Admin, and
> the host is telling you that a) you must use a DSN-less connection,
> because b) they have tried to bring up a DSN using the CF Admin, and were
> not successful. What would you do?

I am with Ken, run away from that host :-)

DSN-less aren't possible anymore with CF 6+, it's a feature not available in
JDBC.

Maybe, since they have very little understanding of CF, they left the CF
Admin API accessible to you so, in theory, you could try creating the
datasource on the fly using a script. But that's looks overkilling to me...

--
----------------------------
Massimo Foti, web-programmer for hire
Tools for ColdFusion and Dreamweaver developers:
http://www.massimocorner.com
----------------------------

Report · Apr 03, 2007

Thanks, guys....

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.dreamweavermx-templates.com - Template Triage!
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
==================

"Massimo Foti" <massimo@massimocorner.com> wrote in message
news:eusbik$sde$1@forums.macromedia.com...
> "Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote in message
> news:eus40q$jvc$1@forums.macromedia.com...
>> Thank you, Massimo. Suppose you do not have access to the CF Admin, and
>> the host is telling you that a) you must use a DSN-less connection,
>> because b) they have tried to bring up a DSN using the CF Admin, and were
>> not successful. What would you do?
>
> I am with Ken, run away from that host :-)
>
> DSN-less aren't possible anymore with CF 6+, it's a feature not available
> in JDBC.
>
> Maybe, since they have very little understanding of CF, they left the CF
> Admin API accessible to you so, in theory, you could try creating the
> datasource on the fly using a script. But that's looks overkilling to
> me...
>
> --
> ----------------------------
> Massimo Foti, web-programmer for hire
> Tools for ColdFusion and Dreamweaver developers:
> http://www.massimocorner.com
> ----------------------------
>
>