![]() ![]() I used SSIS to transfer data between ODBC and SQL Server. You are trying to put 1930 characters into 255 characters of space. If I am reading your error correctly the error indicates the design of your destination column is too small. I have a blob column in sqlite and trying to view data in ssms. Select * from openquery(mydsn, 'select * from db_blobtable') I dropped the idea of Linked Server and went with SSIS I created SSIS packages using the ODBC driver and this allowed for no truncation of the data while transferring between SQLite and SQL server. I changed the BLOB column to blob(2147483647) in SQLite DB. I was able to fix the BLOB issue in SQlite. I've tried converting the input data to ntext, text, nvarchar, varchar etc. ![]() Hi, does anyone managed to load text data FROM SQL server TO SQLite database? I don't have any problem with loading floats/integers into SQLite database but when it comes to text data I always ran into this error "Das abfragebasierte Einfügen oder Aktualisieren von BLOB-Werten wird nicht unterstützt.". Not sure if the other messages below will help you. It looks like the issue is with a BLOB column. I found the only way to return data was to drop all triggers from the SQLite database.Īre triggers generally not allowed when used with a linked server or should I go looking for problems with these particular update triggers? In SQL Sever my Test connection: succeeded but "An error occurred while preparing the query" Thanks, this is still a very helpful guide and the comments help too. If you have to use triggers why not add only one trigger at a time and test it. Sorry I am not familiar with SQLite triggers. The fix may come with an updated driver one day. UPDATE-FROM is supported beginning in SQLite version 3.33.0 ()."įor interest, shows the difference between UPDATE-FROM and WHERE EXISTS: "The UPDATE-FROM idea is an extension to SQL that allows an UPDATE statement to be driven by other tables in the database. That is, when I rewrote the UPDATE-FROM queries in the triggers into the "WHERE EXISTS" format ("correlated query"), the linked server worked. The problem appears to be that SQLite v3.33.0 supports UPDATE-FROM, but, when used in a trigger, the linked server fails. I tried loading my triggers one at a time without success, but it turns out that other simpler triggers work just fine. ![]()
0 Comments
Leave a Reply. |