Hi Steve,
4.5!?! I guess you have to use ODBC with 4.5 to access a mySQL database? It's been a while since I had to deal with 4.5 so I'm not sure...
Double check the name of the ODBC datasource is the same as the one you're putting into CF? Maybe it isn't the same as the mySQL database it is linking to, which maybe your putting into CF? (I've done it, it's worth checking...)
You might try the different account approach. I'm not sure about access to ODBC but it can certainly cause issues accessing network drives (not that they're related) so maybe it would fix it.
Sorry I can't be more help. An upgrade to CF6 would make your life easier, but if you're just servicing a mail server the cost of the enterprise version is a bit much...
HTH,
Brett B)
Steve Garrett wrote:
All, this has me scratching my head, am wondering if any of you have run across this.
We are in the process of moving IMS to a different machine and in doing so we are also moving an old version of CF (4.5 ENT) to that machine as well. We've also installed MySQL, along with the MySQL v3.51 ODBC driver.
In Control Panel -> datasources we have set up a datasource that points to a database within MySQL. We can test from this panel and all appears fine. We can log into MySQL under this username, create tables etc.
However, in CF Administrator we have a problem in that when we try to verify the datasource we get the (Attached) error.
Anyone shed some light? Does CF have to be running under a special account with MySQL?
Thanks in advance!
Steve
==^======================================================= This list server is Powered by iMS "The Swiss Army Knife of Mail Servers" -------------------------------------------------------------------------------------- This list is provided as a free service. Although we will try to address issues in a timely manner, support via this list is not guaranteed. If you require expedited support then a support contract is required. Support may be purchased from http://www.coolfusion.com/commerce. Details regarding support options may be reviewed at: http://www.coolfusion.com/SupportOptions.cfm -------------------------------------------------------------------------------------- To leave this list please complete the form at http://www.coolfusion.com/Support/ Need an iMS Developer license? Sign up for a free license here: http://www.coolfusion.com/Developers/ List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/ Note: You are subscribed as [EMAIL PROTECTED] ==^=======================================================
