New problem with PHP "odbc_exec".
| From: | Scott Fletcher | Date: | Wed, 18 Apr 2001 13:37:16 +0000 |
| Subject: | New problem with PHP "odbc_exec". | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-49208@lists.php.net to get a copy of this message | ||
Hi! I don't understand why PHP is having trouble with the odbc_exec. Is
there a bug in PHP code? Here's what the error messages said!
"SQL error: [OpenLink][ODBC][Driver]No key columns found for table
referenced by keyset driven cursor., SQL state IM909 in SQLExecDirect".
This show that it had to do with primary (or secondary) keys or index
issues. I'm using MS-SQL Sever and this table I'm using in the database
have primary key already!
So, what can I do to fix it? I need it to be working. When I use the
Linux odbctest command and it execute without a problem. So, it is obvious
the problem lie with PHP code, odbc_exec();
Thanks,
Scott