Hi Holger > -----Original Message----- > From: Holger Schurig [mailto:[EMAIL PROTECTED]] > Sent: Mittwoch, 13. M�rz 2002 14:54 > To: [EMAIL PROTECTED] > Subject: missing ODBC functionality SQLFetchScroll ? > > > In the pursuit to find the problem why Qt3/Linux and SAP DB > won't work > with each other, I tried an SQL trace. > > The following is part of the trace file: > [snip] > [ODBC][23394][SQLFetchScroll.c][129] > Entry: > Statement = 0x8082768 > Fetch Orentation = 1 > Fetch Offset = 0 > [ODBC][23394][SQLFetchScroll.c][297]Error: IM001 > > > If I remember this right, the IM001 means "Driver does not > support this > function (DM)". > > > Any idea if there is any plan to add this functionality?
Maybe ... A short story to tell some useful information: SQLFetchScroll is an ODBC 3.x function. It is intended to replace SQLExtendedFetch (an ODBC 2.x function). In general, the driver manager should do some mapping between these functions, if necessary. However, SAP DB ODBC implements both, so it shouldn't harm, if you do not have a driver manager (e.g. on Linux). Now, there is the API SQLGetFunction, giving all functions, the driver supports. The SAP DB ODBC driver distinguishes, whether it runs in ODBC 2.x or ODBC 3.x (SQLSetEnvAttr (henv, SQL_ATTR_ODBC_VERSION, ...);) Running in ODBC 2.x it does not report functions of ODBC 3.x. My guess is, that in your environment, Qt runs the driver in ODBC 2.x and asks for supporting SQLFetchScroll via SQLGetFunctions. The driver, actually having SQLFetchScroll, answers no, since it runs in ODBC 2.x. Maybe it is better, that SQLGetFunctions does not take into accout, which ODBC X.x is active. Any comments? HTH & greetings Thomas ---------------------------------------------- Dr. Thomas K�tter SAP DB, SAP Labs Berlin SAP DB is open source. Get it! www.sapdb.org _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
