All geek questions in one place

The binding status was "DT_NTEXT". The data stream column type is "DBBINDSTATUS_UNSUPPORTEDCONVERSION"

I have the following query in Access:

SELECT Field1, Field2, Field3, "2015" As TestYear
FROM Table1

I use this query in the SQL Server Import / Export tool to retrieve data from an Access database into a SQL Server database.

I get an error message:

"(SQL Server Import and Export Wizard)

Error 0xc002f446: data stream Task 1: An error occurred while setting the binding for the "TestYear" column. The binding status was "DT_NTEXT". The data stream column type is DBBINDSTATUS_UNSUPPORTEDCONVERSION. Conversion from OLE DB type "DBTYPE_IUNKNOWN" to destination column type "DBTYPE_WVARCHAR" may not be supported by this provider.

TestYear nvarchar.

, LongText. , , 4.

- ?

+4
1

, , , "2015" LongText, DT_WSTR, , NVARCHAR. , CVar("2015") AS TestYear MS Access SQL Server.

, , , , .

0

Source: https://habr.com/ru/post/1609653/

More articles:


All Articles