14,499 questions
Error when a try a query from an external table
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 71%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
SQL
1
Reputation point
Hi
I worked on SQL Server 2019 (CU12) and Windows 2019. Polybass is installed
I created an ODBC connection with the driver Denodo (9.03.05.05)
I created an external table without issue.
The column definitions in Denodo and SQL Server are the same. Same datatype
When I try a select statement from this external table without a decimal, no issue.
If I include a decimal, I have this error.
Msg 7320, Level 16, State 110, Line 24
Cannot execute the query "Remote Query" against OLE DB provider "MSOLEDBSQL" for linked server "(null)". 105082;
Generic ODBC error: OdbcBufferReader.ReadBuffer, error in OdbcReadBuffer: SqlState: IM001, NativeError: 0, 'Error calling: SQLSetDescRec(this->GetHdesc(),
(SQLSMALLINT)column->idxServerCol, (SQLSMALLINT)column->odbcReadType, 0, column->valueLength, (SQLSMALLINT)column->precision, (SQLSMALLINT)column->scale,
(SQLPOINTER)(pBuffer + column->valueOffset), (SQLLEN *)indPtr, (SQLLEN *)indPtr), SQL return code: -1 | SQL Error Info: Error <1>: ErrorMsg:
[Microsoft][ODBC Driver Manager] Driver does not support this function | Error calling: pReadConn->ReadBuffer(pBuffer, bufferOffset, bufferLength, pBytesRead, pRowsRead) |
state: FFFF, number: 214, active connections: 3', Connection String: Dsn=DenodoODBC;Driver={DenodoODBC Unicode(x64)};server=10.211.233.102;port=9996;database=portail.
Thanks
SQL Server | Other
{count} votes
-
Erland Sommarskog 121.8K Reputation points MVP Volunteer Moderator2022-01-17T22:52:55.727+00:00 This is horribly difficult to troubleshoot, because there are so many components involved. This can very well be an issue in the DenodoODBC driver. (I've heard of that product before.) But I guess that if you bring this up in a Denodo forum, they will point all fingers at SQL Server...
-
CathyJi-MSFT 22,396 Reputation points Microsoft External Staff2022-01-18T07:56:27.157+00:00 Hi @SQL ,
> Microsoft][ODBC Driver Manager] Driver does not support this function
I am not familiar with Denodo, it seems the decimal data precision in Denedo is not same in SQL server.
Refer to this thread Decimal data type column inconsistent results.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 63%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
Kman 46 Reputation points2022-07-15T16:09:46.65+00:00 Hello,
Having a similar error - could you help on this pleaseMsg 105082, Level 16, State 1, Line 1
105082;Generic ODBC error: OdbcBufferReader.ReadBuffer, error in OdbcReadBuffer: SqlState: HY009, NativeError: -1, 'Error calling: SQLFetch(this->GetHstmt()),
SQL return code: -1 | SQL Error Info: SrvrMsgState: 0, SrvrSeverity: 0, Error <1>: ErrorMsg:
Invalid use of null pointer | Error calling: pReadConn->ReadBcpBuffer(pBuffer, bufferOffset, bufferLength, pBytesRead, pRowsRead, pFirstCompleteRowStartOffset,
pLastCompeleteRowEndOffset) | state: FFFF, number: 138, active connections: 9',
Connection String: Dsn=CDataMongodbUatXXXXXXX;uid=YYYYYY;server=ZZZZZZZZ;port=27018;database=CData. -
Erland Sommarskog 121.8K Reputation points MVP Volunteer Moderator
2022-07-15T21:08:11.86+00:00 If you have not already done so, you should start a new thread about your problem, describing it from start to end. Not that I have much hope we can help (se my Answer above), but piggybacking on old threads is rarely the best of ideas.
Sign in to comment
Sign in to answer