Re: Drivers for Access databases under CF 9 SOLVED!

2010-10-01 Thread Claude Schnéegans

  My guess is that you'd previously installed another version of CF (6,
7, 8) and that there's a conflict between whatever that left on your
system

Your guess was right. Not 6, 7 or 8 versions, but I installed first the trial 
version with the J2EE configuration.
For some mysterious reason, when I tried to enter my serial number, it was not 
accepted.
So I re-installed it using the standalone version. I did not know this was a 
completely different installation, I mean in different directories. The second 
installation did not overwrite the first.
The result was that the two ODBC services were running from the J2EE version. 
apparently this is why definition of new datasources failed.
Last night, I de-installed everything, erased some remaining directories and 
re-installed all.
It now works fine.

Thanks to all for your support.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337730
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Drivers for Access databases under CF 9

2010-09-30 Thread Claude Schnéegans

  Furthermore, I've noticed that if I define a new datasource in CF9, I still 
have the same error, but the same datasource gets also defined in CF5 in the 
same operation, and it works fine under CF5!

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337685
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Drivers for Access databases under CF 9

2010-09-30 Thread Dave Watts

  Furthermore, I've noticed that if I define a new datasource in CF9, I still 
 have the same error, but the same datasource gets also
 defined in CF5 in the same operation, and it works fine under CF5!

Do you have CF9 and CF5 installed on the same box? If so, all bets are off.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337686
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Drivers for Access databases under CF 9

2010-09-30 Thread Claude Schnéegans

  Do you have CF9 and CF5 installed on the same box?

Sure, otherwise I could not say that defining a datasource in CF 9 
autimatically defines it in CF 5.
Since CF 6, I've always used both version on my development desktop with no 
problem, they are completely independant products.

I didn't upgrade to MX on my production server until recently because there was 
too many problems with MX, in particular with CFHTTP. But I always developped 
my application under CF 6, 7, 8, 9 and made sure it was still compatible with 
CF 5.

As I can see there are still problems with the JDBC drivers.
CFMX adds many interesting new features, but the JAVA platform makes everything 
far more complicated and buggy :-(

So apparently. CF 9 does define the ODBC connection correctly, CF 5 recognizes 
it, but the JDBC driver does not see it.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337687
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Drivers for Access databases under CF 9

2010-09-30 Thread Russ Michaels

As you have multiple versions of CF installed you are going to have multiple
versions of the ODBC service as well, each one will be running on a
different port.
Make sure you do not have a conflict here and that you don’t have the wrong
ODBC service running.
I had this problem with a CF98 upgrade that it put the ODBC service on the
wrong port and CF was still using the CF8 ODBC service.

Russ

-Original Message-
From: Claude Schnéegans schneeg...@internetique.com
[mailto:=?ISO-8859-1?Q?Claude_Schn=E9egans schneeg...@interneti=71?=
=?ISO-8859-1?Q?ue.com=3E?=] 
Sent: 30 September 2010 16:05
To: cf-talk
Subject: Re: Drivers for Access databases under CF 9


  Do you have CF9 and CF5 installed on the same box?

Sure, otherwise I could not say that defining a datasource in CF 9
autimatically defines it in CF 5.
Since CF 6, I've always used both version on my development desktop with no
problem, they are completely independant products.

I didn't upgrade to MX on my production server until recently because there
was too many problems with MX, in particular with CFHTTP. But I always
developped my application under CF 6, 7, 8, 9 and made sure it was still
compatible with CF 5.

As I can see there are still problems with the JDBC drivers.
CFMX adds many interesting new features, but the JAVA platform makes
everything far more complicated and buggy :-(

So apparently. CF 9 does define the ODBC connection correctly, CF 5
recognizes it, but the JDBC driver does not see it.



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337690
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Drivers for Access databases under CF 9

2010-09-30 Thread Russ Michaels

As we explained previously, when you create a DSN, it creates an ODBC
datasource, then a JDBC bridge so that CF9 can use it.
CF5 uses ODBC data sources directly so will of course be able to see any
that exist on the system. So this proves the ODBC side of things is working.
However I am confused as you said previously that the DSN's do not exist on
the system, yet clearly they must do if they show up and work in CF5.

Russ



-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: 30 September 2010 15:46
To: cf-talk
Subject: Re: Drivers for Access databases under CF 9


  Furthermore, I've noticed that if I define a new datasource in CF9, I
still have the same error, but the same datasource gets also
 defined in CF5 in the same operation, and it works fine under CF5!

Do you have CF9 and CF5 installed on the same box? If so, all bets are off.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337691
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Drivers for Access databases under CF 9

2010-09-30 Thread Claude Schnéegans

  CF5 uses ODBC data sources directly so will of course be able to see any
that exist on the system.

CF5 will be able to SEE it so you can create a DSN under CF5, but here, 
creating the DSN under CF9 also creates it in CF5. Kind of weird. But I created 
and deleted these DSN so often, that nothing surprises me anymore.

In fact CF5 need two things in order to have a DSN defined:
- data in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI (this is for the ODBC 
connection)
- data in 
HKEY_LOCAL_MACHINE\SOFTWARE\Allaire\ColdFusion\CurrentVersion\DataSources (this 
is the definition of the CF5 DSN) An ODBC database does not make automatically 
a DSN in CF 5 (or 9)

When I delete a DSN in CF 9, also defined in CF 5, it will delete the first, 
the ODBC part, but not the second. The DSN still disappears from CF5 since 
there is no ODBC connection any more.
But if I create again, the DSN, the CF5 key is still in the system, and the DSN 
will reappear in CF as well.

When I create a brand new DSN under CF 9, It will create the ODBC data in 
registry, but not the data for allaire-CF5, so the DSN should not be created in 
CF 5.

This explains the apparent correlation between CF 5 and CF 9, but not why the 
JDBC bridge does not work in CF 9.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337693
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Drivers for Access databases under CF 9

2010-09-30 Thread Russ Michaels

I think you are still not understanding.
CF5 is not JAVA, it doesn't use JDBC, it uses ODBC.
CF9 doesn't create the DSN in CF5,it creates an ODBC DSN in windows, and
this is what CF5 is picking up.
If you create an ODBC DSN in the windows control panel, then it will also
show up in the CF5 admin.
I know 100% that this is true as this is how we allow customers to create
DSN's for CF through our hosting control panel.

Russ



On Thu, Sep 30, 2010 at 5:20 PM,  wrote:


  CF5 uses ODBC data sources directly so will of course be able to see any
 that exist on the system.

 CF5 will be able to SEE it so you can create a DSN under CF5, but here,
 creating the DSN under CF9 also creates it in CF5. Kind of weird. But I
 created and deleted these DSN so often, that nothing surprises me anymore.

 In fact CF5 need two things in order to have a DSN defined:
 - data in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI (this is for the ODBC
 connection)
 - data in
 HKEY_LOCAL_MACHINE\SOFTWARE\Allaire\ColdFusion\CurrentVersion\DataSources
 (this is the definition of the CF5 DSN) An ODBC database does not make
 automatically a DSN in CF 5 (or 9)

 When I delete a DSN in CF 9, also defined in CF 5, it will delete the
 first, the ODBC part, but not the second. The DSN still disappears from CF5
 since there is no ODBC connection any more.
 But if I create again, the DSN, the CF5 key is still in the system, and the
 DSN will reappear in CF as well.

 When I create a brand new DSN under CF 9, It will create the ODBC data in
 registry, but not the data for allaire-CF5, so the DSN should not be created
 in CF 5.

 This explains the apparent correlation between CF 5 and CF 9, but not why
 the JDBC bridge does not work in CF 9.

 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337694
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Drivers for Access databases under CF 9

2010-09-30 Thread Claude Schnéegans

  As you have multiple versions of CF installed you are going to have multiple
versions of the ODBC service as well,

Really? I can see the  ColdFusion 9 ODBC Server and the ColdFusion 9 ODBC 
Agent in the services but to my knowledge, CF 5 does not use any ODBC service.

 each one will be running on a different port.

Where can you see the port they use?




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337695
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Drivers for Access databases under CF 9

2010-09-30 Thread Claude Schnéegans

  CF5 is not JAVA, it doesn't use JDBC, it uses ODBC.

Of course, I know.

 If you create an ODBC DSN in the windows control panel, then it will also
show up in the CF5 admin.

You're right, I thought you still had to define it in CF 5, but apparently it 
is automatic.

Anyway, this does not tell me why the JDBC bridge is not working under CF 9 :-(



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337696
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Drivers for Access databases under CF 9

2010-09-30 Thread Russ Michaels

no CF5 doesn't, but you stated previously u have CF 5/6/7/8/9 installed.
If this is not true then nevermind, but it is getting very hard to follow
this as your setup seems to change from 1 post to the next.


On Thu, Sep 30, 2010 at 5:39 PM,  wrote:


  As you have multiple versions of CF installed you are going to have
 multiple
 versions of the ODBC service as well,

 Really? I can see the  ColdFusion 9 ODBC Server and the ColdFusion 9
 ODBC Agent in the services but to my knowledge, CF 5 does not use any ODBC
 service.

  each one will be running on a different port.

 Where can you see the port they use?




 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337697
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Drivers for Access databases under CF 9

2010-09-30 Thread Russ Michaels

try this and see if the info here helps with regards to checking the ports.
http://russ.michaels.me.uk/index.cfm/2010/9/22/MSACCESS-DSNs-no-longer-work-after-CF-901-Upgrade

also note the previous post it links to.


On Thu, Sep 30, 2010 at 5:59 PM, Russ Michaels r...@michaels.me.uk wrote:

 no CF5 doesn't, but you stated previously u have CF 5/6/7/8/9 installed.
 If this is not true then nevermind, but it is getting very hard to follow
 this as your setup seems to change from 1 post to the next.



 On Thu, Sep 30, 2010 at 5:39 PM,  wrote:


  As you have multiple versions of CF installed you are going to have
 multiple
 versions of the ODBC service as well,

 Really? I can see the  ColdFusion 9 ODBC Server and the ColdFusion 9
 ODBC Agent in the services but to my knowledge, CF 5 does not use any ODBC
 service.

  each one will be running on a different port.

 Where can you see the port they use?




 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337698
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Drivers for Access databases under CF 9

2010-09-30 Thread Dave Watts

 Anyway, this does not tell me why the JDBC bridge is not working under CF 9 
 :-(

My guess is that you'd previously installed another version of CF (6,
7, 8) and that there's a conflict between whatever that left on your
system and the newest version of SequeLink. You can always try
reinstalling SequeLink, I think. I'd try to remove anything in the
registry related to previous SequeLink installs, then try again. I
don't know offhand how to do this, but there's all sorts of stuff in
the slserver54 directory to play with.

If this sounds like too much trouble (and frankly it would be for me)
you could just save CF's settings, then uninstall CF 9 entirely,
remove any junk from previous CF 6, 7, 8 installs, then reinstall.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337700
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Drivers for Access databases under CF 9

2010-09-30 Thread Claude Schnéegans

  My guess is that you'd previously installed another version of CF (6,
7, 8)

Actually no previous version. But I had to install CF 9 twice, in two different 
configurations.
The first time the installer wont take my registration key.
So I have bothe ColdFusion9 and Jrun4 directories.
The last installation I did created ColdFusion9, and all my datasources are 
defined in C:\ColdFusion9\lib\neo-datasource.xml
IIS is also set to send execution to 
C:\ColdFusion9\runtime\lib\wsconfig\jrun_iis6.dll

On my development desktop, developer version, I only have Jrun4

I can see that my databases are defined in both
C:\ColdFusion9\lib
and C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\cfusion\lib

However, the first was last modified today, the second the 25th sept only, five 
days ago when I started to have problems.
Weird.

Is CF 9 installed under ColdFusion9 supposed to use also C:\JRun4 ?

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337703
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Drivers for Access databases under CF 9

2010-09-30 Thread Dave Watts

 Is CF 9 installed under ColdFusion9 supposed to use also C:\JRun4 ?

No.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337705
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Drivers for Access databases under CF 9

2010-09-30 Thread Russ Michaels

C:\jrun4 is a multi-server install.

I think I'd go with Dave's suggestion, uninstall, delete all files and
folders and start from scratch.

Russ

-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: 30 September 2010 18:44
To: cf-talk
Subject: Re: Drivers for Access databases under CF 9


 Is CF 9 installed under ColdFusion9 supposed to use also C:\JRun4 ?

No.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337706
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Drivers for Access databases under CF 9

2010-09-30 Thread Claude Schnéegans

  u have CF 5/6/7/8/9 installed.

On my development desktop yes, but not on my production server on which I'm 
having the problems.

 as your setup seems to change from 1 post to the next.

No, nothing was changed either on my desktop, nor on my server.
I installed CF9 on my server August 25, and did not change anything ever since, 
except for trying to define new datasources.
When I installed it, I was able to redefine all DSNs which were already there 
for CF 5, no problem.
But now the problem is for new DSN.
Even if I define it first in CF 5 and then in CF 9, I still get the same error.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337707
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Drivers for Access databases under CF 9

2010-09-30 Thread Russ Michaels

try the re-install, if that doesn't work, I can login and take a look for
you if you want.

Russ

On Thu, Sep 30, 2010 at 6:52 PM,  wrote:


  u have CF 5/6/7/8/9 installed.

 On my development desktop yes, but not on my production server on which I'm
 having the problems.

  as your setup seems to change from 1 post to the next.

 No, nothing was changed either on my desktop, nor on my server.
 I installed CF9 on my server August 25, and did not change anything ever
 since, except for trying to define new datasources.
 When I installed it, I was able to redefine all DSNs which were already
 there for CF 5, no problem.
 But now the problem is for new DSN.
 Even if I define it first in CF 5 and then in CF 9, I still get the same
 error.


 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337708
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Drivers for Access databases under CF 9

2010-09-30 Thread Scott Stewart

just to throw this out there, have you compared the Windows
permissions on this DB vs. the ones that work?

On Thu, Sep 30, 2010 at 1:52 PM,   wrote:

  u have CF 5/6/7/8/9 installed.

 On my development desktop yes, but not on my production server on which I'm 
 having the problems.

  as your setup seems to change from 1 post to the next.

 No, nothing was changed either on my desktop, nor on my server.
 I installed CF9 on my server August 25, and did not change anything ever 
 since, except for trying to define new datasources.
 When I installed it, I was able to redefine all DSNs which were already there 
 for CF 5, no problem.
 But now the problem is for new DSN.
 Even if I define it first in CF 5 and then in CF 9, I still get the same 
 error.


 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337709
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Drivers for Access databases under CF 9

2010-09-30 Thread Claude Schnéegans

   Is CF 9 installed under ColdFusion9 supposed to use also C:\JRun4 ?
 No.

OK, so we have the begining of an answer here.
I noticed that I'm having CF 9 ODBC agent and ODBC server running from
C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\cfusion\db\slserver54\bin\

They should use those under C:\ColdFusion9\ like for the application server, 
no ?

It looks like the ODBC services from my prior J2EE installation have been 
maintained.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337712
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Drivers for Access databases under CF 9

2010-09-30 Thread Claude Schnéegans

  C:\jrun4 is a multi-server install.

Yeah, I tried this one first (last July), but it wont accept my serial number, 
so I re-installed the other version last August

 I think I'd go with Dave's suggestion, uninstall, delete all files and
folders and start from scratch.

Yurk...


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337713
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Drivers for Access databases under CF 9

2010-09-29 Thread Dave Watts

 There are two drivers for Access database in CF9 :
 - Microsoft Access
 - Microsoft Access with unicode

 ...

 I suspect the first driver is ODBC, the second is JDBC.

Both are JDBC, in that CF only knows JDBC. The first driver is part of
SequeLink, which is a DataDirect product that acts as a JDBC-ODBC
bridge. The second driver is a JDBC-to-Jet driver and doesn't rely on
anything else - Jet is the native protocol for MS Access. I believe
it's open-source, and probably not supported all that well.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337645
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Drivers for Access databases under CF 9

2010-09-29 Thread Claude Schnéegans

  Both are JDBC, in that CF only knows JDBC. The first driver is part of
SequeLink, which is a DataDirect product that acts as a JDBC-ODBC
bridge. The second driver is a JDBC-to-Jet driver and doesn't rely on
anything else - Jet is the native protocol for MS Access. I believe
it's open-source, and probably not supported all that well.


Ah, I see.
The problem with the first is that the DSN wont be created id an ODBC 
datasource is not already defined in Windows.
Kind of cumbersome.
With CF5, the ODBC database was created automatically.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337646
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Drivers for Access databases under CF 9

2010-09-29 Thread Russ Michaels

thats because cf5 used ODBC datasources as it was written in C++
CF6+ is a java app and thus uses JDBC

On Wed, Sep 29, 2010 at 6:13 PM,  wrote:


  Both are JDBC, in that CF only knows JDBC. The first driver is part of
 SequeLink, which is a DataDirect product that acts as a JDBC-ODBC
 bridge. The second driver is a JDBC-to-Jet driver and doesn't rely on
 anything else - Jet is the native protocol for MS Access. I believe
 it's open-source, and probably not supported all that well.


 Ah, I see.
 The problem with the first is that the DSN wont be created id an ODBC
 datasource is not already defined in Windows.
 Kind of cumbersome.
 With CF5, the ODBC database was created automatically.

 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337649
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Drivers for Access databases under CF 9

2010-09-29 Thread Claude Schnéegans

  thats because cf5 used ODBC datasources as it was written in C++
CF6+ is a java app and thus uses JDBC


Of course, I know that.
When I updated from CF5 to CF9, I was able to redefine all my datasources in 
CF9 with no problem.
but now I have a new I want to add, the ODBC connection is created, but the CF9 
Administrator
replies Connection verification failed for data source: SMTPLogs
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink Server]The 
specified data source is not defined.
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC 
Driver][SequeLink Server]The specified data source is not defined.

It looks like the Administrator is able to define a datasource when the ODBC 
connection was already there, but not for a new datasource.

I was able to define the datasource with no problem on my development desktop.
Now on my production server it wont work. The only difference is that on my 
desktop I have the Developper version, on my server it is the standard version.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337650
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Drivers for Access databases under CF 9

2010-09-29 Thread Dave Watts

 It looks like the Administrator is able to define a datasource when the ODBC 
 connection was already there, but not for a new
 datasource.

 I was able to define the datasource with no problem on my development desktop.
 Now on my production server it wont work. The only difference is that on my 
 desktop I have the Developper version, on my server it
 is the standard version.

CF 9 Standard should be able to do that just fine, so there's probably
something else going on. You could look at the SequeLink logs, which
are not enabled by default - but I'm sure there's some option to
enable them.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337651
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Drivers for Access databases under CF 9

2010-09-29 Thread Claude Schnéegans

   You could look at the SequeLink logs, which
are not enabled by default - but I'm sure there's some option to
enable them.

I'm trying to find where.
I've checked for the occurrence of two datasource names in all files under 
\ColdFusion9, one for a datasource which works, the othe one for the 
problematic one.
I found two files :
- C:\ColdFusion9\lib\neo-datasource.xml and
- C:\ColdFusion9\db\slserver54\admin\DSN

Both contains exactly the same type of data regarding the two Datasources.
And I don't see any difference in the two ODBC connections either.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337652
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Drivers for Access databases under CF 9

2010-09-29 Thread Dave Watts

  You could look at the SequeLink logs, which
  are not enabled by default - but I'm sure there's some option to
  enable them.

 I'm trying to find where.
 I've checked for the occurrence of two datasource names in all files under 
 \ColdFusion9, one for a datasource which works, the
 othe one for the problematic one.
 I found two files :
 - C:\ColdFusion9\lib\neo-datasource.xml and
 - C:\ColdFusion9\db\slserver54\admin\DSN

 Both contains exactly the same type of data regarding the two Datasources.
 And I don't see any difference in the two ODBC connections either.

SequeLink should have its own logging options. But again, this isn't
enabled by default, so there won't be anything to see until you figure
out how to enable SequeLink logging, then examine those log files.
There is a SequeLink PDF in the slserver54 directory, but i haven't
read it.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337653
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Drivers for Access databases under CF 9

2010-09-29 Thread Claude Schnéegans

Ok, according to this page : http://kb2.adobe.com/cps/186/tn_18644.html
ColdFusion MX ODBC Agent errors are typically logged to the Windows Event Log
So I went into the Windows Event Log and I found this indeed :

 The description for Event ID ( 0 ) in Source ( ColdFusion 9 ODBC Server ) 
cannot be found. The local computer may not have the necessary registry 
information or message DLL files to display messages from a remote computer. 
You may be able to use the /AUXSOURCE= flag to retrieve this description; see 
Help and Support for details. The following information is part of the event: 
ColdFusion 9 ODBC ser...@localhost,ErrorCode=3059,ErrorMessage=The specified 
data source is not defined.,ClientHost=127.0.0.1,Session=20375. 

Now if somebody is able to explain what the heck this means, I'd be very 
grateful.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337654
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Drivers for Access databases under CF 9

2010-09-29 Thread Russ Michaels

It sounds as though you are just expecting CF to somehow automatically
pickup windows ODBC data sources.
This wont happen.
It only worked when you upgraded form CF5 because you were upgrading
ColdFusion, so it knew about the data sources in the cfadmin and migrated.
You need to add the datasources via the coldfusion administrator, this
creates an ODBC DSN and then creates a JDBC bridge to connect to it.
Sorry if I misunderstood, if you have done this already then read on.

If you look in C:\ColdFusion9\lib\neo-datasource.xml you will find all the
DSN's defined in here. Check all the connection properties of the working
DSN's and compare them to the non working DSN's and see if there is anything
different.

If you then look in C:\ColdFusion9\db\slserver54\cfg\swandm.ini
You will find all the dsn's defined in here as well for the jdbc connector

each dsn is defined like this

[DataSource_5]
Type=6
DataSourceLogonMethod=OSIntegrated
DataSourceProviderTypesFile=C:\ColdFusion9\db\slserver54\bin\swsoc.ini
ServiceName=ColdFusion 9 ODBC Server
DataSourceName=mydsn
DataSourceSOCODBCConnStr=dsn=mydsn
DataSourceFetchTimeStampAsString=0

make sure they are defined here, comparing the working ones against broken
ones and see if there is any glaring difference.
trol pane
If all is good, then you should check that the actual ODBC DSN is working,
you can do this from administrative tools/Data Sources ODBC
find the DSN and then simply test it to make sure it works. If not, then its
a windows ODBC problem. Try re-creating the ODBC DSN directly in windows
instead of with CF and see if that helps.

Russ

On Wed, Sep 29, 2010 at 9:29 PM,  wrote:


 Ok, according to this page : http://kb2.adobe.com/cps/186/tn_18644.html
 ColdFusion MX ODBC Agent errors are typically logged to the Windows Event
 Log
 So I went into the Windows Event Log and I found this indeed :

  The description for Event ID ( 0 ) in Source ( ColdFusion 9 ODBC Server )
 cannot be found. The local computer may not have the necessary registry
 information or message DLL files to display messages from a remote computer.
 You may be able to use the /AUXSOURCE= flag to retrieve this description;
 see Help and Support for details. The following information is part of the
 event: ColdFusion 9 ODBC ser...@localhost,ErrorCode=3059,ErrorMessage=The
 specified data source is not defined.,ClientHost=127.0.0.1,Session=20375. 

 Now if somebody is able to explain what the heck this means, I'd be very
 grateful.

 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337659
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Drivers for Access databases under CF 9

2010-09-29 Thread Dave Watts

 It sounds as though you are just expecting CF to somehow automatically
 pickup windows ODBC data sources.

I get the impression that he's trying to create new Access datasources
from the CF Administrator without having existing ODBC datasources
pointing to those Access databases. That should work fine.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337662
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Drivers for Access databases under CF 9

2010-09-29 Thread Claude Schnéegans

  I get the impression that he's trying to create new Access datasources
from the CF Administrator without having existing ODBC datasources
pointing to those Access databases. That should work fine.


Exactly.
First, CF 9 installation does not import automatically CF 5 databases. I had to 
redefined all of them.
The only thing is that when one gives the name of the Datasource, the ODBC 
connection is recognized
and the correct path for the database file is automatically set.

I just tried to define the new database first in CF 5, then in CF 9. It 
recognize the ODBC connection like for all others, but still gives the same 
error. Under CF5, the DSN works fine.
The only thing special about this database is that it has views defined, but I 
don't thing this matters, the driver cannot even connect to it.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337663
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Drivers for Access databases under CF 9

2010-09-29 Thread Claude Schnéegans

  If you look in C:\ColdFusion9\lib\neo-datasource.xml you will find all the
DSN's defined in here. Check all the connection properties of the working
DSN's and compare them to the non working DSN's and see if there is anything
different.

I've already done this, and everything about the new DSN is identical to all 
others, except for the name and the datasource path.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337664
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Drivers for Access databases under CF 9

2010-09-29 Thread Russ Michaels

how about the rest  of things I suggested, there was more?

On Wed, Sep 29, 2010 at 10:38 PM,  wrote:


  If you look in C:\ColdFusion9\lib\neo-datasource.xml you will find all
 the
 DSN's defined in here. Check all the connection properties of the working
 DSN's and compare them to the non working DSN's and see if there is
 anything
 different.

 I've already done this, and everything about the new DSN is identical to
 all others, except for the name and the datasource path.

 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337665
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Drivers for Access databases under CF 9

2010-09-29 Thread Claude Schnéegans

  how about the rest  of things I suggested, there was more?

Regarding the [DataSource_n] records, I have only 4 of them in here, about 
datasource I don't even have in my system.
I think these are example datasources used for the documentation which I didn't 
install on my production server.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337666
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Drivers for Access databases under CF 9

2010-09-29 Thread Russ Michaels

well then there is your problem, if the datasources don't exist on your
system, then that is why you are getting an error saying they do not exist.


On Thu, Sep 30, 2010 at 12:23 AM,  wrote:


  how about the rest  of things I suggested, there was more?

 Regarding the [DataSource_n] records, I have only 4 of them in here, about
 datasource I don't even have in my system.
 I think these are example datasources used for the documentation which I
 didn't install on my production server.


 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337668
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Drivers for Access databases under CF 9

2010-09-29 Thread Claude Schnéegans

  well then there is your problem, if the datasources don't exist

Then this is certainly not crucial, as I have about 25 other databases, most of 
them using the same Access driver, none of them is registered in this file, and 
all of them work perfectly.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337676
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Drivers for Access databases under CF 9

2010-09-29 Thread Scott Slone

Claude,
Can you create a new data source using an existing Access file? if so the issue 
may be the version of Access or a missing component that you have on desktop 
but not on server. 

Sent from my iPhone

On Sep 29, 2010, at 6:27 PM, Claude 
Schnéegansschneegans@internetiq.intermedia.net wrote:

 
 well then there is your problem, if the datasources don't exist
 
 Then this is certainly not crucial, as I have about 25 other databases, most 
 of them using the same Access driver, none of them is registered in this 
 file, and all of them work perfectly.
 
 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337677
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Drivers for Access databases under CF 9

2010-09-29 Thread Claude Schnéegans

  Can you create a new data source using an existing Access file?

Actually no. I already have 25 datasources, all with the same driver, all 
created with the same Access version, all work fine, but no new datasource is 
recognized.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337678
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Drivers for Access databases under CF 9

2010-09-29 Thread Claude Schnéegans

  ... I even tried this:
- delete an old datasource which worked.
- redefine it, no problem, still works.
- made a copy of the same file in another directory, create a new datasource on 
it... doesn't work :-(

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337679
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm