OOPS! My bad...
Why are you using ODBC?? Go into the Administrator, go to Datasources, and in the dropdown click SQLOLEDB. Then configure your datasource with the same settings you would in the OS Control Panel... IP (generally most reliable), username, password... those are all you should *need*... but if you click "Show Advanced Settings" it'll give you more options. I recommend against changing any of the advanced settings unless you absolutely need to. However, using the ODBC Administrator is pre-CF5, for one thing... and a whole lot more work, for another... and it puts your CFMX instance (which has a FULL JDBC implementation) at the mercy of the OS. The built-in drivers will be more reliable, faster, and a lOT easier to configure. Go for it! Try something new! J On 4/25/05, Mike Kear <[EMAIL PROTECTED]> wrote: > Thanks Sean and Jared, but that reference is about CFMX7 drivers for MySQL4.1. > > My question was about MS SQLServer2000, which I've been using since it > was released happily with WinXPPro, and now doesnt seem to want to > behave the same way it did under the non-JRUN version of CFMX7. > > I'm not sure how this answer relates. It's about a change in the MySQL > authentication mechanism. Does it also apply to MS SQLServer2000? > > > Cheers > Mike Kear > Windsor, NSW, Australia -- --------------- ------------------------------------- Buy SQLSurveyor! http://www.web-relevant.com/sqlsurveyor Never make your developers open Enterprise Manager again. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204230 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
