Steve,
Have you installed CF Ent. 4.5 updates and hotfixes from Macromedia ?
Link:
http://www.macromedia.com/support/coldfusion/updates/5/updates_5.html#Enterprise
Regards to all,
David A. Goldfield
PS I moved to Atlanta, Ga. and got a 1 month job that just finished. Am now looking for work. Anyone knows of anything, call me, 404-914-4772 Cell.
----- Original Message ----- From: "Steve Garrett" <[EMAIL PROTECTED]>
To: "inFusion Support List" <[EMAIL PROTECTED]>
Sent: Thursday, October 14, 2004 12:42 PM
Subject: Re: [iMS] IMS, MYSQL and an older version of ColdFusion
Yeah, I know it is old. We actually have the 5x CDs but have been happy with the 4.5 version that is mostly servicing email/IMS. We have occasional use of FusionMail that requires outside access so that is why we decided not to use BlueDragon for this (Translation: minimal $$$). This must be something simple, we will keep poking and proding.
The weird part is that CF sees the actual datasource. We've tried creating a different datasource, with a different name, but the same error happens.
Steve
At 09:15 AM 10/14/2004, Brett Payne-Rhodes wrote: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] ==^=======================================================
