#59 SQLGetInfo() needs to be implemented

open
nobody
ODBC (10)
5
2004-06-24
2004-06-24
Anonymous
No

In the current mdbtools-0.6pre1, the implementation of
SQLGetInfo() does nothing.

[ The current implementation leaves the return
parameters unitialized, and returns SQL_SUCCESS, which
(IMHO) is poor style, as the caller is left to debug
why it didn't do what it says it sucessfully did... :-< ]

Although I don't have the specific details about what
this function does, its purpose includes getting
information from the driver - Information that may
vary between different ODBC databases (and maybe
between different drivers?)

Thus, for generic ODBC code that is tryting to support
a wide number of ODBC drivers/databases, it is
important to use this function to avoid hard-coding
incorrect information within the code. Unfortunately,
v0.6 won't be of any use to me unless I can use this
function (Short of hard-coding everything for Access,
which is an unacceptable limitation in our code).

Specifically, I'm looking to use (and their results
from a test using Microsoft Acces Driver 4.00.6019.00):
- SQL_MAX_STATEMENT_LEN=65000
- SQL_SCHEMA_USAGE=0
- SQL_CATALOG_NAME_SEPARATOR='.'
- SQL_CATALOG_LOCATION=1
- SQL_IDENTIFIER_QUOTE_CHAR= '`'
- SQL_DBMS_NAME="ACCESS"

Perhaps mdbtools can simply hard-code these (since it
is only working with Access)? I don't know if these
vary between different versions of Access...

Lemme know if you need any more info, or if you want me
to try anything...
Ian
britten@caris.com

Discussion

  • Brian Bruns

    Brian Bruns - 2007-03-18

    Logged In: YES
    user_id=11673
    Originator: NO

    This bug is believed to be fixed in the current version in CVS.
    If this is not the case, please reopen this bug with text
    explaining how to reproduce your problem. Thank you.

     
  • Brian Bruns

    Brian Bruns - 2007-03-18

    Logged In: YES
    user_id=11673
    Originator: NO

    Fixed in CVS

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks