Rohail
|
| Posted: 06/12/2005, 12:31 PM |
|
Hello All:
I am using the Trial Version of CodeCharge Studio and I was working on "Creating a Task Management" tutorial. I was at step # 4 and when I tried to add a new task I got the following error message:
Database error: Invalid SQL: INSERT INTO tasks (project_id, priority_id, status_id, type_id, task_name, task_desc, user_id_assign_to, task_finish_date) VALUES (1, 1, 1, 2, 'Testing', 'testing', 32, #2005-06-13 00:00:00#)
ODBC Error: 1 (General Error (The ODBC interface cannot return detailed error messages).)
Session halted.
I am on Windows XP Professional and using PHP 5.0/MySQL 4.1 on IIS 5.1 server.
can anyone help please?
I am also using MyODBC Driver 3.51!!!
Thanks for your help in advance.
Rohail
|
|
|
 |
peterr
Posts: 5971
|
| Posted: 06/12/2005, 12:51 PM |
|
This means that you selected "MS Access" as your database in the connection settings. Please change it to MySQL.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
Rohail
|
| Posted: 06/12/2005, 10:29 PM |
|
Hi Peter:
Thanks a bunch for your quick response. In the connection settings, I selected "IntranetDB" then I changed the following two properties to MySQL:
- Design Database Type = MySQL
- Server Database Type = MySQL
Both of these properties were set to MS Access. However, after changing these properties to MySQL, I am still getting the same error message when I try to add a task. The error message is:
Database error: Invalid SQL: INSERT INTO tasks (project_id, priority_id, status_id, type_id, task_name, task_desc, user_id_assign_to, task_finish_date) VALUES (1, 1, 2, 1, 'Test', 'Testing', 32, '2005-06-14 00:00:00')
ODBC Error: 1 (General Error (The ODBC interface cannot return detailed error messages).)
Session halted.
I am following all steps in the Tutorials; haven't missed any step. Do you've any other suggestions?
Thanks again for your help in advance.
Rohail
|
|
|
|
peterr
Posts: 5971
|
| Posted: 06/12/2005, 11:24 PM |
|
This is a different error message since the SQL is different. This time possibly your database is not created correctly, but I am not sure. Have you created your database using the file Intranet_MySQL.sql that came with CCS?
You can also try running the SQL statement that you provided above directly in MySQL and check what error will be shown in MySQL.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
peterr
Posts: 5971
|
| Posted: 06/12/2005, 11:41 PM |
|
Actually it may be even better if you don't use ODBC for connecting to MySQL from PHP programs. The error messages should be more clear then. You can specify "MySQL" instead of "ODBC / MySQL" in your Connection/Server. The ODBC connection is only needed in Connection/Design, as CCS has no other to connect to MySQL.
Hopefully this will work.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Rohail
|
| Posted: 06/15/2005, 11:08 PM |
|
Hi Peter:
Thanks for all your help. I changed PHP Database Library to MySQL from ODBC and now it's working.
Thanks a million for all your help and cooperation. That was great!!!
Rohail
|
|
|
|
|
