[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::odbc_rdb_driver

Title:DEC ODBC Driver
Notice:DEC ODBC Driver V2.0 Now Available
Moderator:SQLSRV::MAVRIS
Created:Tue Dec 29 1992
Last Modified:Fri Jun 06 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:1357
Total number of notes:4864

1355.0. "The fetched data as more than 100 columns" by CHSR36::JSUBRI (Focus on Open/Rdb++) Mon Jun 02 1997 11:02

Hello,                                          

One customer claims ODBC for Rdb is not able to retrieve more than 
100 columns ... Rdb V6.1-10 , SQL/Services V6.1-02 , Odbc V2.10.11

The message box says:

	The fetched data as more than 100 columns.
	Only the first 100 columns will be retrieved.

I tried on RDBMS as well and got the same error.

Is the limitation to fetch 100 columns comes from ODBC spec ?
Only few notes talk about this one, do I missed something ?

/Jean-Luc

I found some very old info V4.1 timeframe, seems not related here.

       2.4.6 Column Limit Raised to 500

              The previous SQL/Services limit of 100 columns per table
              has been raised to 500 in Rdb/VMS V4.0B and V4.1.

    
T.RTitleUserPersonal
Name
DateLines
1355.1M5::JBALOGHMon Jun 02 1997 12:096
    Sounds like your application has the limit. Nothing in the ODBC spec
    limits you to 100 columns. 
    
    Seems like I read recently that SQLSRV has a 500 column limit...
    
    John
1355.2who is limitingCHSR36::JSUBRIFocus on Open/Rdb++Mon Jun 02 1997 13:3811
    John,
    
    	I tested with the "32-bit ODBC TEST" program against RDBMS 7.3.2.3
    and with the "Oracle ODBC for Rdb Test" with SQl/services V7.1 and 
    Rdb V7.0-01.
    
    Who is limiting this stuffs ?
    
    I found nothing in the regedit
    
    /Jean-Luc
1355.3SQL_MAX_COLUMNS_IN_SELECTCHSR36::JSUBRIFocus on Open/Rdb++Mon Jun 02 1997 15:2719
    I may found the culprit:
    
    
    '
    '|========================================================================|
    '| ODBC Module Core Definitions                                          
    '|========================================================================|
    '
    '  ODBC Core API's Definitions -- 32 bit versions
    .
    .
    .
    
    ' Defines for SQLGetInfo
    '
    Global Const SQL_MAX_COLUMNS_IN_SELECT As Long = 100
    
    
    /Jean-Luc