![]() 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |