Hi!
I've been searching the archives and found a lot of good stuff on setting
up Coldfusion with Mysql.. but for some reason I still the get the
following error:
"The connection to the data source failed. Check the following to resolve
this problem:
Are the data source settings configured properly?
Did you provide valid security information in the data source settings ?
For some databases the ColdFusion Server may need to be logged
in under a special NT account rather than the default System Account. Use
the Windows NT Services Control Panel to change the account the ColdFusion
Server service is using. "
So I am running the latest versions of Mysql and Coldfusion on Linux
2.2.16. I am accessing the MySQL database with a Merant MySQL driver..
which Coldfusion reccomends (not using MyODBC). I am able to connect to
the test database that mysql comes with using Coldfusion. I created
another database which I can connect to using the mysql commands.. but
with coldfusion it gives me the above error. I set permissions using GRANT
for a specific user.. with a 'Y' for all fields. I also have set a
password... and I am using it. I tried creating symlinks such that the
database may be accessed in all caps or all lower case.
So.. is there something that I am missing or that I can check to help
diagnose this problem. Could I cut and paste the db or user tables?
Any help is appreciated as I have been struggling with this for a long
time now. I had used MyODBC before and couldnt even verify the test
database.
Thanks,
Tanya
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
