Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2004
    Posts
    21

    Unanswered: Could not create an instance of OLE DB provider 'BULKIMPORTSTREAM'.

    Run this script:

    bulk insert viewdisp
    from 'd:\downloads\assessment05_preload\viewdisp.txt'
    with (
    check_constraints,
    datafiletype = 'widechar',
    firstrow = 1,
    maxerrors = 0
    )
    go

    Get this error:

    Could not create an instance of OLE DB provider 'BULKIMPORTSTREAM'.
    OLE DB error trace [Non-interface error: CoCreate of DSO for BULKIMPORTSTREAM returned 0x80040154].

    SQL Server 2000 - SP3a
    Logged in as sa with system admin, bulk insert admin, dbo, ddl admin, local admin, king of the world... you name it.

    Is this a OLE DB Driver or MDAC issue?

    Anyone else ever had this issue. You would think that Microsoft would have all of their error messages on their own WebSite, but that must be too much trouble for them.
    Last edited by rknorc; 02-10-05 at 17:25.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Based on the HRESULT you posted (80040154), you've got at least one DLL class that isn't registered properly. The simple answer is to remove the SQL client tools using the Control Panel, then reinstall the SQL Client tools.

    If you know (or at least strongly suspect) which DLL has gone AWOL, you can certainly try to register it manually.

    -PatP

  3. #3
    Join Date
    Sep 2004
    Posts
    21
    Do you know which DLLs I should look at? Is the the ODBC or the SQL Server?

    Thanks.

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Operative word being "should", the problem should be in the SQL Server.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •