Unanswered: bulk copy - problem with OLE DB provider
I cannot fill a table with data from a text file. I generated the text file under the DOS command line:
C:\>bcp spring2.dbo.UmTRight out d:\tmp.txt -c -Usa -P -SCH03W0261
The file was created without any problems.
The I tried to read in the data with an SQL statement (within Query Analyzer):
BULK INSERT UmTRight FROM 'D:\tmp.txt'
The message was:
Server: Msg 7302, Level 16, State 1, Line 1
Could not create an instance of OLE DB provider 'STREAM'.
Windows 2000 SP2; SQL Server 7.0 Desktop Edition SP2; MDAC 2.7
On other PC's it works fine.