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);
after that, 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.
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.
Has anyone the same problems or is something wrong at my site ?
-
With best regards
Peter Klinge
---------------------------------------------------------------
Dipl.-Ing. Peter Klinge
AMEDTEC Medizintechnik Aue GmbH, Schneeberger Str. 5, 08280 Aue
Tel.: +049 3771 722133 Fax: +049 3771 722106
Email: [EMAIL PROTECTED]
---------------------------------------------------------------
Der folgende Abschnitt dieser Nachricht enthält einen Dateianhang
im Internet MIME Format.
Wenn Sie Pegasus Mail oder ein anderes MIME-kompatibles Programm verwenden,
sollten Sie den Anhang speichern oder ansehen können.
Sollte das nicht funktionieren, fragen Sie Ihren Systembetreuer um Rat.
The following section of this message contains a file attachment
prepared for transmission using the Internet MIME message format.
If you are using Pegasus Mail, or any another MIME-compliant system,
you should be able to save it or view it from within your mailer.
If you cannot, please ask your system administrator for assistance.
---- Datei-Informationen / File information -----------
Datei/File: SQL.LOG
Datum/Date: 6 Feb 2002, 14:18
Größe/Size: 930 bytes.
Typ/Type: Binary
---------------------------------------------------------------------
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
