Re: [PHP3] An ODBC problem

From: 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!)

« previous php.general (#2389) next »