In our application we're inserting data using bulk inserts via OleDb (IRowsetFastLoad). If we connect to an SQL-Server 9.0 (Server 2005 or Express Edition) everything works fine. Yet if we connect to an MSDE-Instance (Server 8.0) the application crashes as soon as a row with an image field has been inserted.
We recognized that version 9.0 uses instapi.dll to connect to the database engine while clients on which only MSDE (8.0) is installed load several other DLLs when connecting to the engine.
Has anyone else encountered this problem or knows any solution, how to bulk insert image data via OleDb into engine without having to upgrade from 8.0 to 9.0?
Many thanks in advance!