Hi, > -----Original Message----- > From: Peter Klinge [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 06, 2002 5:33 AM > To: [EMAIL PROTECTED] > Subject: Error in myodbc 3.51.01.00 > > > Dear all, > > today I have switched from myodbc 2.50.39.00 to 3.51.01.00, > because I had a problem using SQLColumnPrivileges (see below) > > After that I couldn't use my application because of the > ConnectionHandle was destroyed. After logging the application I > have found, that there is an problem inside of SQLGetInfo. I made a > call: > > SQLHDBC hdbc=NULL; > SQLUSMALLINT MaxStatementHdls; > SQLSMALLINT len; > SQLGetInfo (hdbc, SQL_ACTIVE_STATEMENTS, > &MaxStatementHdls, sizeof (MaxStatementHdls), &len); > SQLAllocHandle (SQL_HANDLE_STMT, hdbc, &hstmt); > > after SQLGetInfo and before SQLAllocHandle, the <hdbc> lost his > low part. The reason for that seems to be the variable > <MaxStatementHdls> defined as SQLUSMALLINT (like the > description of ODBC in MSDN). <len> says, that in > <MaxStatementHdls> will be returned a value with a lenght of 4 > (instead of 2). As work around I have changed the definition of > <MaxStatementHdls> from SQLUSMALLINT to int. (see attached > file sql.log)
SQL_ACTIVE_STATEMENTS is deprecated/renamed in ODBC 3.x spec, and the new one is SQL_MAX_CONCURRENT_ACTIVITIES. You should try to use this with 3.x applications. SQL_MAX_CONCURRENT_ACTIVITIES returns SQLUINTEGER only, though it was a typo error as SQLUSMALLINT in ODBC spec. > > And this is my original problem - but here I can't find a reason: > If I try to call > > SQLColumnPrivileges (hstmt, NULL, 0, NULL, 0, > (SQLCHAR*)"patdat", SQL_NTS, NULL, 0) ? > > I get a error message "[Microsoft][ODBC Driver Manager] Driver > does not support this function" if I use myodbc V2.50. If I try to do > the same with myodbc V3.51 I will get "[mysqld-3.23.43]Driver > doesn't support this yet". But the documentation says, this > functions is included in both versions. We don't support yet. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php