Re: Drivers for Access databases under CF 9 SOLVED!
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
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
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
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
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 dont 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
... 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
