MS SQL using a Linked Server to my IQ 16

[Former Member]

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

[Gisung]

Hi,

Which OLEDB Provider has been used when test connection?

And Please show the definition of tables.

Is it same when using OPENQUERY?

ex)

select * from OPENQUERY( MyLinkName, 'select * from Account').

Please refer to below SCN Article (ASE / MSSQL)

...

{COLUMN} was reported to have a "DBCOLUMNFLAGS_ISNULLABLE" of 0 at compile time and 32 at run time.

Actually, there is no way to bypass this error other than changing the source table definition for the column to allow null values.  This is pretty grave – but the only alternative is to retrieve the full remote table values locally and to make the outer join locally.

...

==

Gi-Sung Jang

[Former Member]

Hi,

the linked server use "Microsoft OLE DB Provider for ODBC Drivers".

If I use openquery, the query works without errors.

I will read the SCN Article (ASE/MSSQL), and then I decide how to proceed.

Thank you very much for your reply.

Regards

Paolo Serra