Skip to Content
0
Former Member
Jul 17, 2015 at 12:17 PM

MS SQL using a Linked Server to my IQ 16

454 Views

Hi to all,

I have a problem with a query executed from any MS SQL using a Linked Server to my SAP IQ 16.

If I do a Test Connection, it works.

The query is:

select * from IQ..dba.table (IQ is my Linked Server)

The error is:

MSG 7356, Level 16, State 1, Line 1

The OLE DB provider "MSDASQL" for linked server "IQ" supplied inconsistent metadata for a column.

The column "column name" (compile-time ordinal 1) of object ""dba"."table""

Was reported to have a "DBCOLUMNFLAGS_ISNULLABLE" of 0 at compile time and 32 at run time.

Someone already had the same problem?

Thanks

Paolo