Hi marco In the administration page of coldfusion, usually something like: http://domainName/CFIDE/administrator/index.cfm?target=/CFIDE/administrator/welcome.cfm go to your data sources and click the edit button. THen click the "show advance settings" button. Make sure that the Allowed sql privelages are correct (ie. select, delete, update, etc). That is, if you give your coldfusion a datasource using the user name mySource you have to make sure that your sql database has a user mySource. Make sure that the user mySource has the correct privelages. That is, if you say that the user mySource can only have select privelages then you have to make sure that the coldfusion knows about it too and thus, you can't say that the user: mySource has drop or alter privelages.
Hope this helps Desmond >From: "marco" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >CC: <[EMAIL PROTECTED]> >Subject: COLDFUSION AND MYSQL >Date: Mon, 19 Aug 2002 10:23:19 +0200 > >Hello everybody!!!! >I'm just getting mad with coldfusion, installed on a redhat platform >running >mysql 2.1.0 > >Well, the problem occures when I try to create a data source, because I >always get this ERROR MESSAGE: > >[]java.sql.SQLException: SQLException occurred in JDBCPool while attempting >to connect, please check your username, password, URL, and other >connectivity info. >The root cause was that: java.sql.SQLException: SQLException occurred in >JDBCPool while attempting to connect, please check your username, password, >URL, and other connectivity info. > >So I was wondering if it's a problem of drivers..... for example I may not >have JDBC drivers installed on that redhat server???Is it possible???If so, >can I install them?? > >thanx >marco > > > >--------------------------------------------------------------------- >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 _________________________________________________________________ Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.com --------------------------------------------------------------------- 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
