[Search for users]
[Overall Top Noters]
[List of all Conferences]
[Download this site]
| 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 08: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.R | Title | User | Personal
Name | Date | Lines |
|---|
| 1355.1 | | M5::JBALOGH | | Mon Jun 02 1997 09:09 | 6 |
| 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.2 | who is limiting | CHSR36::JSUBRI | Focus on Open/Rdb++ | Mon Jun 02 1997 10:38 | 11 |
| 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.3 | SQL_MAX_COLUMNS_IN_SELECT | CHSR36::JSUBRI | Focus on Open/Rdb++ | Mon Jun 02 1997 12:27 | 19 |
| 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
|