Re: [PHP3] An ODBC problem
| From: | (Richard Lynch) | Date: | Tue, 20 Jun 2000 22:48:40 +0000 |
| Subject: | Re: [PHP3] An ODBC problem | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-2389@lists.php.net to get a copy of this message | ||
In article <83FC3C78A4D5D211A0250008C7F4CFE6013A6258@ex3.state.nm.us>,
Bill.Bailargeon@state.nm.us ("Baillargeon, Bill") wrote:
> Warning: SQL error: [OpenLink][ODBC][Driver]No key columns found for table
> referenced by keyset driven cursor., SQL state IM909 in SQLExecDirect in
> /www/html/odbc2.php3 on line ...
Assuming this message isn't just total nonsense, you could try:
(A) Adding a key column (which the rest of the world calls an index) to
the table you're accessing.
(B) Trying to convince ODBC to use a different cursor type that doesn't
care about key columns. I think there's an optional cursor type argument
in the ODBC connect functions, or something like that...
(C) Switching from OpenLink to EasyODBC or Native calls or... (Okay this
option is rather extreme).
--
Richard Lynch | If this was worth $$$ to you, buy a CD
US Customer Support Director | from one of the artists listed here:
Zend Technologies USA | http://www.L-I-E.com/artists.htm
http://www.zend.com | (this has nothing to do with Zend,
duh!)