Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Bulk Insert of image data via OleDb Expand / Collapse
Author
Message
Posted Friday, May 23, 2008 8:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 10, 2008 4:58 AM
Points: 3, Visits: 16
Hi Folks!

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!

Best regards,
Andreas
Post #505894
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse