Welcome Guest, Not a member yet? Register   Sign In
cursor type in missing in ODBC driver
#1

[eluser]umefarooq[/eluser]
Hi today i try to connect oracle with CI using odbc driver it connected successfully but when i try to query from database i got the following error message

[Microsoft][ODBC driver for Oracle]Cannot use Keyset-driven cursor on join, with distinct clause, union, intersect or minus or on read only result set

i google it and found i have to set cursor type to SQL_CUR_USE_ODBC in odbc_connect() and put the cursor type and it work great but by default there is no cursor type in CI odbc driver class can is set through CI or i have to set manually in the driver class

here is php documentation for odbc_connect

http://www.php.net/manual/en/function.odbc-connect.php




Theme © iAndrew 2016 - Forum software by © MyBB