I have a table with one column (nvarchar) with a length >127. Everything is working fine until I want to make a simple SELECT * FROM table_1, which results in error. Error message: "Object was open".
I connect to the database using ADOConnection "Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5". No prob to insert more than 127 characters in the column with an INSERT INTO command. No problems to update a row. But there's just no way to make a SELECT!
Is there a fix for this... bug(?) ? Workaround? It's really annoying.
View Complete Post