Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Application raised an exception class PDOException with message 'SQLSTATE[4


This question is not answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 0 Threads: [ Previous | Next ]
Zivota Milic

Posts: 35
Registered: 4/4/08
Application raised an exception class PDOException with message 'SQLSTATE[4  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jan 1, 2015 4:25 PM
(I'm sure that the host,username,password and database are correct in datamodule)
when i deploy my file to the remote web-server i riceive an error:

Application raised an exception class PDOException with message 'SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'Sql....1'@'xx.xxx.xx.xx' for table 'utenti''

I chech the file php.ini.template and i have enabled the row extension=php_pdo_mysql.dll and the row extension=php_mysql.dll.

I tried to write and deploy a simple file.php with notepadd++ to try to connect to the database and work fine.

I think that the problem is on embarcadero deployment/output for the remote-server?

thank you.
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02