Russ, I would unpack the Admin scripts that create DSN's (from inside the CF Admin) and figure out what they are doing differently. There must be an attribute you can use to set the port - or a path to a config file or something.
-Mark -----Original Message----- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Tuesday, August 31, 2010 5:39 PM To: cf-talk Subject: Re: ODBC (microsoft access) DSN's not working thanks for the Idea Brian, sadly no dice. And to the other person who asked, yes the unicode driver works. I also just noticed something new. It is only new DSN's (created via the adminapi) that are not working. Existing MSACCESS DSN's are actually still working, they will verify ok from the cfadmin , I just cannot edit them as I get the error stating the service is not running, So I checked out the neo-datasource.xml to see what is the the difference between an old DSN and a new DSN, and I noticed this. <var name="url"> <string>jdbc:sequelink:msaccess://localhost:20000;serverDatasource=111</stri ng> </var> if I look at the old still working DSN's I see <var name="url"> <string>jdbc:sequelink:msaccess://localhost:19998;serverDatasource=PCK;MaxPo oledStatements=1000</string> </var> So it appears that the CFADMIN is using the wrong port to connect to the ODBC service and to create DSN;s, so if I can find where this port setting is coming from then I think I will be able to fix it. Russ On Tue, Aug 31, 2010 at 3:46 PM, Brian Anderson <br...@hostek.com> wrote: > > > I am having issues with the Microsoft Access DSN's on a cf9 server > > (windows 2000) > > > > Here is the original problem I had after upgrading from CF8 to CF9, > > which as you can see I solved > > > > http://russ.michaels.me.uk/index. > cfm/2010/3/5/Mi> > crosoft-Access-DSNs-no-longer-working-after-upgrading-to-ColdFusion-9 > > > > > > > > > However since upgrading to cf9.0.1 it has stopped working again and I > > cannot figure out why this time, and none of my fellow CFGURU's have > > been able to shed any light either, thus why I am posting here as a > > last resort. > > > > > > > > > The ODBC services are running > > > > The ports in swandm.ini are still correct > > > > Nothing in D:\ColdFusion9\db\slserver54\logging > > > > > > > > > However every site is giving the error > > > > [Macromedia][SequeLink JDBC Driver]TCP/IP error, connection refused. > > > > > > > > > And when editing a dsn in the cfadmin I get > > > > The ColdFusion ODBC Server service is not running or has not been > > installed.. You may also use the "MS Access with Unicode" driver to > > connect to MS Access datasources > > > > > > > > > Anyone got any ideas? > > Russ, > > I'm not sure if this will help, but try restoring the > macromedia_drivers.jar from the CF 9.0 install and then restart ColdFusion > and see if that works.. I had to do that on one server after the CF 9.0.1 > upgrade to get the datasources to work, although the error I got was > different. Thought I'd mention it just in case. > > Brian A > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:336700 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
