> I updated a machine from Windows 2000 to Windows 2003 > (server) and then ran the install for CF MX7. I think it did > a side by side install with MX6. > > The web site, an intranet, is now running from MX7, except it > seems to be using the MX6 data sources for MS Access databases. > > All the data sources are listed in the MX7 data source > configuration pages. > If I stop the MX6 ODBC services and restart MX7 (MX6 is > stopped) I get errors on the pages that are trying to draw > from these access databases. > > So I'm wondering, has anybody else seen this? I recreated > one of the data sources in the database administrator and > then stopped the MX 6 services and it verified OK. Is there > a program or script to migrate the Data source settings? If > this is a FAQ I must be using the wrong keywords.
I don't usually run into this, as I avoid using Access, but I don't think you can have the ODBC services for both CFMX 6 and CFMX 7 installed. However, there's no reason why CFMX 7 can't use the CFMX 6 ODBC services. You might also try using the Access w/Unicode driver, which uses OLEDB instead of ODBC and thus doesn't depend on the ODBC services. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243650 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
