Bulk Insert problem

Bulk insert report the following code after being
used for a period.
When this happens, we need to re-start the SQL Server
and then it will disappear for a while and then happen
again.
Any body have idea about how to work around this problem?
Server: Msg 7302, Level 16, State 1, Line 1
Could not create an instance of OLE DB
provider 'BULKIMPORTSTREAM'.
OLE DB error trace [Non-interface error: CoCreate of DSO
for BULKIMPORTSTREAM returned 0x8007045a].
In Programming Xing has a problem where he gets this error
http://support.microsoft.com/default...&Product=sql2k
due to not being sysadmin.
The second time he tries to run a bulk insert he gets your error.
Do you have something using the wrong permissions for bulkinsert?
"Mike" wrote:

> Bulk insert report the following code after being
> used for a period.
> When this happens, we need to re-start the SQL Server
> and then it will disappear for a while and then happen
> again.
> Any body have idea about how to work around this problem?
> Server: Msg 7302, Level 16, State 1, Line 1
> Could not create an instance of OLE DB
> provider 'BULKIMPORTSTREAM'.
> OLE DB error trace [Non-interface error: CoCreate of DSO
> for BULKIMPORTSTREAM returned 0x8007045a].
>
|||This should have nothing about access since
my problem is that this BULK INSERT statement
works most time and then report the error.
After re-starting the SQL Server, then it works
again.
Looks like a bug of MS related to memory allocation
and instance creation.
Thanks!

>--Original Message--
>In Programming Xing has a problem where he gets this error
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;302621&Product=sql2k
>due to not being sysadmin.
>The second time he tries to run a bulk insert he gets
your error.
>Do you have something using the wrong permissions for
bulkinsert?[vbcol=seagreen]
>
>"Mike" wrote:
problem?[vbcol=seagreen]
DSO
>.
>

Bulk Insert problem

Bulk insert report the following code after being
used for a period.
When this happens, we need to re-start the SQL Server
and then it will disappear for a while and then happen
again.
Any body have idea about how to work around this problem?
Server: Msg 7302, Level 16, State 1, Line 1
Could not create an instance of OLE DB
provider 'BULKIMPORTSTREAM'.
OLE DB error trace [Non-interface error: CoCreate of DSO
for BULKIMPORTSTREAM returned 0x8007045a].In programming Xing has a problem where he gets this error
http://support.microsoft.com/defaul...1&Product=sql2k
due to not being sysadmin.
The second time he tries to run a bulk insert he gets your error.
Do you have something using the wrong permissions for bulkinsert?
"Mike" wrote:

> Bulk insert report the following code after being
> used for a period.
> When this happens, we need to re-start the SQL Server
> and then it will disappear for a while and then happen
> again.
> Any body have idea about how to work around this problem?
> Server: Msg 7302, Level 16, State 1, Line 1
> Could not create an instance of OLE DB
> provider 'BULKIMPORTSTREAM'.
> OLE DB error trace [Non-interface error: CoCreate of DSO
> for BULKIMPORTSTREAM returned 0x8007045a].
>|||This should have nothing about access since
my problem is that this BULK INSERT statement
works most time and then report the error.
After re-starting the SQL Server, then it works
again.
Looks like a bug of MS related to memory allocation
and instance creation.
Thanks!

>--Original Message--
>In programming Xing has a problem where he gets this error
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;302621&Product=sql2k
>due to not being sysadmin.
>The second time he tries to run a bulk insert he gets
your error.
>Do you have something using the wrong permissions for
bulkinsert?
>
>"Mike" wrote:
>
problem?[vbcol=seagreen]
DSO[vbcol=seagreen]
>.
>