Hi,
I'm running SQL 2k SP3a on a 2.2P4 workstation with 250GB
drives and Windows Server 2003 sp1. I'm running a fairly
simple stored proc and I get the following error:
[Microsoft][ODBC SQL Server Driver][Shared Memory]
ConnectionCheckForData (CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection Broken
I've tried changing protocols in the client utiltiy (tcp
and named pipes) as suggested elsewhere. There are no
errors in the application log or the sql log.
Any ideas what is happening? The same query doesn't
crash on W2k Server/SQL Server 2k. It happens repeatedly,
but sometimes on the first, second or third execution of
the stored proc.
Thanks for any insight.Fred,
You could try to adjust couple of parameters of your SQL
Server:
network packet size (B):
default 4096, change it to eg. 1024
remote query timeout (s):
default 30 or 60, change it to eg. 600
You can see the current configuration with "sp_configure".
You could also design your procedure to interact
with "the client program" more frequently. One
possibility is to add rows like
PRINT 'Just sending something to the interface'
to your procedure. The idea is to keep the connection
alive.
I've tested these and it helped with some procedures (but
not with everyone).
If anyone has any other ideas, please let us know!
.mika
>--Original Message--
>Hi,
>I'm running SQL 2k SP3a on a 2.2P4 workstation with
250GB
>drives and Windows Server 2003 sp1. I'm running a
fairly
>simple stored proc and I get the following error:
>[Microsoft][ODBC SQL Server Driver][Shared Memory]
>ConnectionCheckForData (CheckforData()).
>Server: Msg 11, Level 16, State 1, Line 0
>General network error. Check your network documentation.
>Connection Broken
>I've tried changing protocols in the client utiltiy (tcp
>and named pipes) as suggested elsewhere. There are no
>errors in the application log or the sql log.
>Any ideas what is happening? The same query doesn't
>crash on W2k Server/SQL Server 2k. It happens
repeatedly,
>but sometimes on the first, second or third execution of
>the stored proc.
>Thanks for any insight.
>.
>|||Hi Fred,
Have had this problem recently, it seems a common error with quite a
few different symptoms. I will tell you our story, which may or may
not help.
For our case, we had this error executing dynamic SQL over ADO.NET,
but could also recreate the problem via Query Analyser using different
protocols.
We were using a complex query and got either your error or the
following:
ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process 51 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
Connection Broken
We only got this error under certain conditions but could reproduce it
faithfully under those conditions.
Sniffing around the newsgroups, the general opinion was that if you
changed the query slightly, then in some cases the problem just "went
away".
I found 2 solutions to our problem.
Solution 1
Our query was using a view and by putting a "TOP 100 PERCENT" clause
in the view the problem went away. This is the solution we went with.
Solution 2
By using "OPTION(MERGE JOIN)" or "OPTION(LOOP JOIN)" in the SQL
statement, the problem went away. By forcing "OPTION(HASH JOIN)" the
problem re-appeared.
My theory is that merge joins were causing the problem (possibly in
conjunction with parallel query execution) but can't prove anything
because when you get this problem, you can't even get a query plan.
Looking at the query plan after using "TOP 100 PERCENT" I noticed that
there were no merge joins, although that proves nothing.
I wish you luck.
"Fred Jones" <anonymous@.discussions.microsoft.com> wrote in message news:<98f701c3ea99$2d681e80$a501280a@.phx.gbl>...
> Hi,
> I'm running SQL 2k SP3a on a 2.2P4 workstation with 250GB
> drives and Windows Server 2003 sp1. I'm running a fairly
> simple stored proc and I get the following error:
> [Microsoft][ODBC SQL Server Driver][Shared Memory]
> ConnectionCheckForData (CheckforData()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> Connection Broken
> I've tried changing protocols in the client utiltiy (tcp
> and named pipes) as suggested elsewhere. There are no
> errors in the application log or the sql log.
> Any ideas what is happening? The same query doesn't
> crash on W2k Server/SQL Server 2k. It happens repeatedly,
> but sometimes on the first, second or third execution of
> the stored proc.
> Thanks for any insight.
Showing posts with label sp3a. Show all posts
Showing posts with label sp3a. Show all posts
Thursday, March 29, 2012
Error: ConnectionCheckForData (CheckforData())
Hi,
I'm running SQL 2k SP3a on a 2.2P4 workstation with 250GB
drives and Windows Server 2003 sp1. I'm running a fairly
simple stored proc and I get the following error:
[Microsoft][ODBC SQL Server Driver][Shared Memory]
ConnectionCheckForData (CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection Broken
I've tried changing protocols in the client utiltiy (tcp
and named pipes) as suggested elsewhere. There are no
errors in the application log or the sql log.
Any ideas what is happening? The same query doesn't
crash on W2k Server/SQL Server 2k. It happens repeatedly,
but sometimes on the first, second or third execution of
the stored proc.
Thanks for any insight.Hi Fred,
Have had this problem recently, it seems a common error with quite a
few different symptoms. I will tell you our story, which may or may
not help.
For our case, we had this error executing dynamic SQL over ADO.NET,
but could also recreate the problem via Query Analyser using different
protocols.
We were using a complex query and got either your error or the
following:
ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process 51 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
Connection Broken
We only got this error under certain conditions but could reproduce it
faithfully under those conditions.
Sniffing around the newsgroups, the general opinion was that if you
changed the query slightly, then in some cases the problem just "went
away".
I found 2 solutions to our problem.
Solution 1
Our query was using a view and by putting a "TOP 100 PERCENT" clause
in the view the problem went away. This is the solution we went with.
Solution 2
By using "OPTION(MERGE JOIN)" or "OPTION(LOOP JOIN)" in the SQL
statement, the problem went away. By forcing "OPTION(HASH JOIN)" the
problem re-appeared.
My theory is that merge joins were causing the problem (possibly in
conjunction with parallel query execution) but can't prove anything
because when you get this problem, you can't even get a query plan.
Looking at the query plan after using "TOP 100 PERCENT" I noticed that
there were no merge joins, although that proves nothing.
I wish you luck.
"Fred Jones" <anonymous@.discussions.microsoft.com> wrote in message news:<98f701c3ea99$2
d681e80$a501280a@.phx.gbl>...
> Hi,
> I'm running SQL 2k SP3a on a 2.2P4 workstation with 250GB
> drives and Windows Server 2003 sp1. I'm running a fairly
> simple stored proc and I get the following error:
> [Microsoft][ODBC SQL Server Driver][Shared Memory]
> ConnectionCheckForData (CheckforData()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> Connection Broken
> I've tried changing protocols in the client utiltiy (tcp
> and named pipes) as suggested elsewhere. There are no
> errors in the application log or the sql log.
> Any ideas what is happening? The same query doesn't
> crash on W2k Server/SQL Server 2k. It happens repeatedly,
> but sometimes on the first, second or third execution of
> the stored proc.
> Thanks for any insight.sql
I'm running SQL 2k SP3a on a 2.2P4 workstation with 250GB
drives and Windows Server 2003 sp1. I'm running a fairly
simple stored proc and I get the following error:
[Microsoft][ODBC SQL Server Driver][Shared Memory]
ConnectionCheckForData (CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection Broken
I've tried changing protocols in the client utiltiy (tcp
and named pipes) as suggested elsewhere. There are no
errors in the application log or the sql log.
Any ideas what is happening? The same query doesn't
crash on W2k Server/SQL Server 2k. It happens repeatedly,
but sometimes on the first, second or third execution of
the stored proc.
Thanks for any insight.Hi Fred,
Have had this problem recently, it seems a common error with quite a
few different symptoms. I will tell you our story, which may or may
not help.
For our case, we had this error executing dynamic SQL over ADO.NET,
but could also recreate the problem via Query Analyser using different
protocols.
We were using a complex query and got either your error or the
following:
ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process 51 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
Connection Broken
We only got this error under certain conditions but could reproduce it
faithfully under those conditions.
Sniffing around the newsgroups, the general opinion was that if you
changed the query slightly, then in some cases the problem just "went
away".
I found 2 solutions to our problem.
Solution 1
Our query was using a view and by putting a "TOP 100 PERCENT" clause
in the view the problem went away. This is the solution we went with.
Solution 2
By using "OPTION(MERGE JOIN)" or "OPTION(LOOP JOIN)" in the SQL
statement, the problem went away. By forcing "OPTION(HASH JOIN)" the
problem re-appeared.
My theory is that merge joins were causing the problem (possibly in
conjunction with parallel query execution) but can't prove anything
because when you get this problem, you can't even get a query plan.
Looking at the query plan after using "TOP 100 PERCENT" I noticed that
there were no merge joins, although that proves nothing.
I wish you luck.
"Fred Jones" <anonymous@.discussions.microsoft.com> wrote in message news:<98f701c3ea99$2
d681e80$a501280a@.phx.gbl>...
> Hi,
> I'm running SQL 2k SP3a on a 2.2P4 workstation with 250GB
> drives and Windows Server 2003 sp1. I'm running a fairly
> simple stored proc and I get the following error:
> [Microsoft][ODBC SQL Server Driver][Shared Memory]
> ConnectionCheckForData (CheckforData()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> Connection Broken
> I've tried changing protocols in the client utiltiy (tcp
> and named pipes) as suggested elsewhere. There are no
> errors in the application log or the sql log.
> Any ideas what is happening? The same query doesn't
> crash on W2k Server/SQL Server 2k. It happens repeatedly,
> but sometimes on the first, second or third execution of
> the stored proc.
> Thanks for any insight.sql
Tuesday, March 27, 2012
error: CoCreate of DSO for BULKIMPORTSTREAM
Hi,
Sql 2000 SP3a, Windows 2000 Enterprise, SP4
I've extensively searched through most means (google, microsoft,
newsgroups,etc) and really haven't found a definitive answer. There really
isn't any real answers. I run an ASP and most clients on one of the
production servers are experiencing this problem. My problem is when using
bulk insert every once in awhile we'll receive a
CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
error. Restarting the service used to take care of this for awhile, but now
this happens everyday.
Is there any special hotfixes for this or a final fix for this? Or any
other information on it. My next steps are to re-apply sp3a (sp4 hasn't
made it through testing yet), if that fails register the IMPPROV.dll ...
other than that... i'm out of ideas.
Please Please help!!!!
thanks in advance.
Hi
This may be a ERR_DLL_INIT_FAILED error, in which case you may want to try
re-installing/updating MDAC, check system resources...
I am not sure if this is relevant! http://www.aspfaq.com/show.asp?id=2388
John
"Chris Trailer" wrote:
> Hi,
> Sql 2000 SP3a, Windows 2000 Enterprise, SP4
> I've extensively searched through most means (google, microsoft,
> newsgroups,etc) and really haven't found a definitive answer. There really
> isn't any real answers. I run an ASP and most clients on one of the
> production servers are experiencing this problem. My problem is when using
> bulk insert every once in awhile we'll receive a
> CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
> error. Restarting the service used to take care of this for awhile, but now
> this happens everyday.
> Is there any special hotfixes for this or a final fix for this? Or any
> other information on it. My next steps are to re-apply sp3a (sp4 hasn't
> made it through testing yet), if that fails register the IMPPROV.dll ...
> other than that... i'm out of ideas.
> Please Please help!!!!
> thanks in advance.
>
>
Sql 2000 SP3a, Windows 2000 Enterprise, SP4
I've extensively searched through most means (google, microsoft,
newsgroups,etc) and really haven't found a definitive answer. There really
isn't any real answers. I run an ASP and most clients on one of the
production servers are experiencing this problem. My problem is when using
bulk insert every once in awhile we'll receive a
CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
error. Restarting the service used to take care of this for awhile, but now
this happens everyday.
Is there any special hotfixes for this or a final fix for this? Or any
other information on it. My next steps are to re-apply sp3a (sp4 hasn't
made it through testing yet), if that fails register the IMPPROV.dll ...
other than that... i'm out of ideas.
Please Please help!!!!
thanks in advance.
Hi
This may be a ERR_DLL_INIT_FAILED error, in which case you may want to try
re-installing/updating MDAC, check system resources...
I am not sure if this is relevant! http://www.aspfaq.com/show.asp?id=2388
John
"Chris Trailer" wrote:
> Hi,
> Sql 2000 SP3a, Windows 2000 Enterprise, SP4
> I've extensively searched through most means (google, microsoft,
> newsgroups,etc) and really haven't found a definitive answer. There really
> isn't any real answers. I run an ASP and most clients on one of the
> production servers are experiencing this problem. My problem is when using
> bulk insert every once in awhile we'll receive a
> CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
> error. Restarting the service used to take care of this for awhile, but now
> this happens everyday.
> Is there any special hotfixes for this or a final fix for this? Or any
> other information on it. My next steps are to re-apply sp3a (sp4 hasn't
> made it through testing yet), if that fails register the IMPPROV.dll ...
> other than that... i'm out of ideas.
> Please Please help!!!!
> thanks in advance.
>
>
error: CoCreate of DSO for BULKIMPORTSTREAM
Hi,
Sql 2000 SP3a, Windows 2000 Enterprise, SP4
I've extensively searched through most means (google, microsoft,
newsgroups,etc) and really haven't found a definitive answer. There really
isn't any real answers. I run an ASP and most clients on one of the
production servers are experiencing this problem. My problem is when using
bulk insert every once in awhile we'll receive a
CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
error. Restarting the service used to take care of this for awhile, but now
this happens everyday.
Is there any special hotfixes for this or a final fix for this? Or any
other information on it. My next steps are to re-apply sp3a (sp4 hasn't
made it through testing yet), if that fails register the IMPPROV.dll ...
other than that... i'm out of ideas.
Please Please help!!!!
thanks in advance.Hi
This may be a ERR_DLL_INIT_FAILED error, in which case you may want to try
re-installing/updating MDAC, check system resources...
I am not sure if this is relevant! http://www.aspfaq.com/show.asp?id=2388
John
"Chris Trailer" wrote:
> Hi,
> Sql 2000 SP3a, Windows 2000 Enterprise, SP4
> I've extensively searched through most means (google, microsoft,
> newsgroups,etc) and really haven't found a definitive answer. There reall
y
> isn't any real answers. I run an ASP and most clients on one of the
> production servers are experiencing this problem. My problem is when usin
g
> bulk insert every once in awhile we'll receive a
> CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
> error. Restarting the service used to take care of this for awhile, but n
ow
> this happens everyday.
> Is there any special hotfixes for this or a final fix for this? Or any
> other information on it. My next steps are to re-apply sp3a (sp4 hasn't
> made it through testing yet), if that fails register the IMPPROV.dll ...
> other than that... i'm out of ideas.
> Please Please help!!!!
> thanks in advance.
>
>
Sql 2000 SP3a, Windows 2000 Enterprise, SP4
I've extensively searched through most means (google, microsoft,
newsgroups,etc) and really haven't found a definitive answer. There really
isn't any real answers. I run an ASP and most clients on one of the
production servers are experiencing this problem. My problem is when using
bulk insert every once in awhile we'll receive a
CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
error. Restarting the service used to take care of this for awhile, but now
this happens everyday.
Is there any special hotfixes for this or a final fix for this? Or any
other information on it. My next steps are to re-apply sp3a (sp4 hasn't
made it through testing yet), if that fails register the IMPPROV.dll ...
other than that... i'm out of ideas.
Please Please help!!!!
thanks in advance.Hi
This may be a ERR_DLL_INIT_FAILED error, in which case you may want to try
re-installing/updating MDAC, check system resources...
I am not sure if this is relevant! http://www.aspfaq.com/show.asp?id=2388
John
"Chris Trailer" wrote:
> Hi,
> Sql 2000 SP3a, Windows 2000 Enterprise, SP4
> I've extensively searched through most means (google, microsoft,
> newsgroups,etc) and really haven't found a definitive answer. There reall
y
> isn't any real answers. I run an ASP and most clients on one of the
> production servers are experiencing this problem. My problem is when usin
g
> bulk insert every once in awhile we'll receive a
> CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
> error. Restarting the service used to take care of this for awhile, but n
ow
> this happens everyday.
> Is there any special hotfixes for this or a final fix for this? Or any
> other information on it. My next steps are to re-apply sp3a (sp4 hasn't
> made it through testing yet), if that fails register the IMPPROV.dll ...
> other than that... i'm out of ideas.
> Please Please help!!!!
> thanks in advance.
>
>
error: CoCreate of DSO for BULKIMPORTSTREAM
Hi,
Sql 2000 SP3a, Windows 2000 Enterprise, SP4
I've extensively searched through most means (google, microsoft,
newsgroups,etc) and really haven't found a definitive answer. There really
isn't any real answers. I run an ASP and most clients on one of the
production servers are experiencing this problem. My problem is when using
bulk insert every once in awhile we'll receive a
CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
error. Restarting the service used to take care of this for awhile, but now
this happens everyday.
Is there any special hotfixes for this or a final fix for this? Or any
other information on it. My next steps are to re-apply sp3a (sp4 hasn't
made it through testing yet), if that fails register the IMPPROV.dll ...
other than that... i'm out of ideas.
Please Please help!!!!
thanks in advance.Hi
This may be a ERR_DLL_INIT_FAILED error, in which case you may want to try
re-installing/updating MDAC, check system resources...
I am not sure if this is relevant! http://www.aspfaq.com/show.asp?id=2388
John
"Chris Trailer" wrote:
> Hi,
> Sql 2000 SP3a, Windows 2000 Enterprise, SP4
> I've extensively searched through most means (google, microsoft,
> newsgroups,etc) and really haven't found a definitive answer. There reall
y
> isn't any real answers. I run an ASP and most clients on one of the
> production servers are experiencing this problem. My problem is when usin
g
> bulk insert every once in awhile we'll receive a
> CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
> error. Restarting the service used to take care of this for awhile, but n
ow
> this happens everyday.
> Is there any special hotfixes for this or a final fix for this? Or any
> other information on it. My next steps are to re-apply sp3a (sp4 hasn't
> made it through testing yet), if that fails register the IMPPROV.dll ...
> other than that... i'm out of ideas.
> Please Please help!!!!
> thanks in advance.
>
>sql
Sql 2000 SP3a, Windows 2000 Enterprise, SP4
I've extensively searched through most means (google, microsoft,
newsgroups,etc) and really haven't found a definitive answer. There really
isn't any real answers. I run an ASP and most clients on one of the
production servers are experiencing this problem. My problem is when using
bulk insert every once in awhile we'll receive a
CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
error. Restarting the service used to take care of this for awhile, but now
this happens everyday.
Is there any special hotfixes for this or a final fix for this? Or any
other information on it. My next steps are to re-apply sp3a (sp4 hasn't
made it through testing yet), if that fails register the IMPPROV.dll ...
other than that... i'm out of ideas.
Please Please help!!!!
thanks in advance.Hi
This may be a ERR_DLL_INIT_FAILED error, in which case you may want to try
re-installing/updating MDAC, check system resources...
I am not sure if this is relevant! http://www.aspfaq.com/show.asp?id=2388
John
"Chris Trailer" wrote:
> Hi,
> Sql 2000 SP3a, Windows 2000 Enterprise, SP4
> I've extensively searched through most means (google, microsoft,
> newsgroups,etc) and really haven't found a definitive answer. There reall
y
> isn't any real answers. I run an ASP and most clients on one of the
> production servers are experiencing this problem. My problem is when usin
g
> bulk insert every once in awhile we'll receive a
> CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
> error. Restarting the service used to take care of this for awhile, but n
ow
> this happens everyday.
> Is there any special hotfixes for this or a final fix for this? Or any
> other information on it. My next steps are to re-apply sp3a (sp4 hasn't
> made it through testing yet), if that fails register the IMPPROV.dll ...
> other than that... i'm out of ideas.
> Please Please help!!!!
> thanks in advance.
>
>sql
error: CoCreate of DSO for BULKIMPORTSTREAM
Hi,
Sql 2000 SP3a, Windows 2000 Enterprise, SP4
I've extensively searched through most means (google, microsoft,
newsgroups,etc) and really haven't found a definitive answer. There really
isn't any real answers. I run an ASP and most clients on one of the
production servers are experiencing this problem. My problem is when using
bulk insert every once in awhile we'll receive a
CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
error. Restarting the service used to take care of this for awhile, but now
this happens everyday.
Is there any special hotfixes for this or a final fix for this? Or any
other information on it. My next steps are to re-apply sp3a (sp4 hasn't
made it through testing yet), if that fails register the IMPPROV.dll ...
other than that... i'm out of ideas.
Please Please help!!!!
thanks in advance.
Hi
This may be a ERR_DLL_INIT_FAILED error, in which case you may want to try
re-installing/updating MDAC, check system resources...
I am not sure if this is relevant! http://www.aspfaq.com/show.asp?id=2388
John
"Chris Trailer" wrote:
> Hi,
> Sql 2000 SP3a, Windows 2000 Enterprise, SP4
> I've extensively searched through most means (google, microsoft,
> newsgroups,etc) and really haven't found a definitive answer. There really
> isn't any real answers. I run an ASP and most clients on one of the
> production servers are experiencing this problem. My problem is when using
> bulk insert every once in awhile we'll receive a
> CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
> error. Restarting the service used to take care of this for awhile, but now
> this happens everyday.
> Is there any special hotfixes for this or a final fix for this? Or any
> other information on it. My next steps are to re-apply sp3a (sp4 hasn't
> made it through testing yet), if that fails register the IMPPROV.dll ...
> other than that... i'm out of ideas.
> Please Please help!!!!
> thanks in advance.
>
>
Sql 2000 SP3a, Windows 2000 Enterprise, SP4
I've extensively searched through most means (google, microsoft,
newsgroups,etc) and really haven't found a definitive answer. There really
isn't any real answers. I run an ASP and most clients on one of the
production servers are experiencing this problem. My problem is when using
bulk insert every once in awhile we'll receive a
CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
error. Restarting the service used to take care of this for awhile, but now
this happens everyday.
Is there any special hotfixes for this or a final fix for this? Or any
other information on it. My next steps are to re-apply sp3a (sp4 hasn't
made it through testing yet), if that fails register the IMPPROV.dll ...
other than that... i'm out of ideas.
Please Please help!!!!
thanks in advance.
Hi
This may be a ERR_DLL_INIT_FAILED error, in which case you may want to try
re-installing/updating MDAC, check system resources...
I am not sure if this is relevant! http://www.aspfaq.com/show.asp?id=2388
John
"Chris Trailer" wrote:
> Hi,
> Sql 2000 SP3a, Windows 2000 Enterprise, SP4
> I've extensively searched through most means (google, microsoft,
> newsgroups,etc) and really haven't found a definitive answer. There really
> isn't any real answers. I run an ASP and most clients on one of the
> production servers are experiencing this problem. My problem is when using
> bulk insert every once in awhile we'll receive a
> CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
> error. Restarting the service used to take care of this for awhile, but now
> this happens everyday.
> Is there any special hotfixes for this or a final fix for this? Or any
> other information on it. My next steps are to re-apply sp3a (sp4 hasn't
> made it through testing yet), if that fails register the IMPPROV.dll ...
> other than that... i'm out of ideas.
> Please Please help!!!!
> thanks in advance.
>
>
error: CoCreate of DSO for BULKIMPORTSTREAM
Hi,
Sql 2000 SP3a, Windows 2000 Enterprise, SP4
I've extensively searched through most means (google, microsoft,
newsgroups,etc) and really haven't found a definitive answer. There really
isn't any real answers. I run an ASP and most clients on one of the
production servers are experiencing this problem. My problem is when using
bulk insert every once in awhile we'll receive a
CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
error. Restarting the service used to take care of this for awhile, but now
this happens everyday.
Is there any special hotfixes for this or a final fix for this? Or any
other information on it. My next steps are to re-apply sp3a (sp4 hasn't
made it through testing yet), if that fails register the IMPPROV.dll ...
other than that... i'm out of ideas.
Please Please help!!!!
thanks in advance.
Hi
This may be a ERR_DLL_INIT_FAILED error, in which case you may want to try
re-installing/updating MDAC, check system resources...
I am not sure if this is relevant! http://www.aspfaq.com/show.asp?id=2388
John
"Chris Trailer" wrote:
> Hi,
> Sql 2000 SP3a, Windows 2000 Enterprise, SP4
> I've extensively searched through most means (google, microsoft,
> newsgroups,etc) and really haven't found a definitive answer. There really
> isn't any real answers. I run an ASP and most clients on one of the
> production servers are experiencing this problem. My problem is when using
> bulk insert every once in awhile we'll receive a
> CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
> error. Restarting the service used to take care of this for awhile, but now
> this happens everyday.
> Is there any special hotfixes for this or a final fix for this? Or any
> other information on it. My next steps are to re-apply sp3a (sp4 hasn't
> made it through testing yet), if that fails register the IMPPROV.dll ...
> other than that... i'm out of ideas.
> Please Please help!!!!
> thanks in advance.
>
>
Sql 2000 SP3a, Windows 2000 Enterprise, SP4
I've extensively searched through most means (google, microsoft,
newsgroups,etc) and really haven't found a definitive answer. There really
isn't any real answers. I run an ASP and most clients on one of the
production servers are experiencing this problem. My problem is when using
bulk insert every once in awhile we'll receive a
CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
error. Restarting the service used to take care of this for awhile, but now
this happens everyday.
Is there any special hotfixes for this or a final fix for this? Or any
other information on it. My next steps are to re-apply sp3a (sp4 hasn't
made it through testing yet), if that fails register the IMPPROV.dll ...
other than that... i'm out of ideas.
Please Please help!!!!
thanks in advance.
Hi
This may be a ERR_DLL_INIT_FAILED error, in which case you may want to try
re-installing/updating MDAC, check system resources...
I am not sure if this is relevant! http://www.aspfaq.com/show.asp?id=2388
John
"Chris Trailer" wrote:
> Hi,
> Sql 2000 SP3a, Windows 2000 Enterprise, SP4
> I've extensively searched through most means (google, microsoft,
> newsgroups,etc) and really haven't found a definitive answer. There really
> isn't any real answers. I run an ASP and most clients on one of the
> production servers are experiencing this problem. My problem is when using
> bulk insert every once in awhile we'll receive a
> CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
> error. Restarting the service used to take care of this for awhile, but now
> this happens everyday.
> Is there any special hotfixes for this or a final fix for this? Or any
> other information on it. My next steps are to re-apply sp3a (sp4 hasn't
> made it through testing yet), if that fails register the IMPPROV.dll ...
> other than that... i'm out of ideas.
> Please Please help!!!!
> thanks in advance.
>
>
error: CoCreate of DSO for BULKIMPORTSTREAM
Hi,
Sql 2000 SP3a, Windows 2000 Enterprise, SP4
I've extensively searched through most means (google, microsoft,
newsgroups,etc) and really haven't found a definitive answer. There really
isn't any real answers. I run an ASP and most clients on one of the
production servers are experiencing this problem. My problem is when using
bulk insert every once in awhile we'll receive a
CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
error. Restarting the service used to take care of this for awhile, but now
this happens everyday.
Is there any special hotfixes for this or a final fix for this? Or any
other information on it. My next steps are to re-apply sp3a (sp4 hasn't
made it through testing yet), if that fails register the IMPPROV.dll ...
other than that... i'm out of ideas.
Please Please help!!!!
thanks in advance.Hi
This may be a ERR_DLL_INIT_FAILED error, in which case you may want to try
re-installing/updating MDAC, check system resources...
I am not sure if this is relevant! http://www.aspfaq.com/show.asp?id=2388
John
"Chris Trailer" wrote:
> Hi,
> Sql 2000 SP3a, Windows 2000 Enterprise, SP4
> I've extensively searched through most means (google, microsoft,
> newsgroups,etc) and really haven't found a definitive answer. There really
> isn't any real answers. I run an ASP and most clients on one of the
> production servers are experiencing this problem. My problem is when using
> bulk insert every once in awhile we'll receive a
> CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
> error. Restarting the service used to take care of this for awhile, but now
> this happens everyday.
> Is there any special hotfixes for this or a final fix for this? Or any
> other information on it. My next steps are to re-apply sp3a (sp4 hasn't
> made it through testing yet), if that fails register the IMPPROV.dll ...
> other than that... i'm out of ideas.
> Please Please help!!!!
> thanks in advance.
>
>
Sql 2000 SP3a, Windows 2000 Enterprise, SP4
I've extensively searched through most means (google, microsoft,
newsgroups,etc) and really haven't found a definitive answer. There really
isn't any real answers. I run an ASP and most clients on one of the
production servers are experiencing this problem. My problem is when using
bulk insert every once in awhile we'll receive a
CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
error. Restarting the service used to take care of this for awhile, but now
this happens everyday.
Is there any special hotfixes for this or a final fix for this? Or any
other information on it. My next steps are to re-apply sp3a (sp4 hasn't
made it through testing yet), if that fails register the IMPPROV.dll ...
other than that... i'm out of ideas.
Please Please help!!!!
thanks in advance.Hi
This may be a ERR_DLL_INIT_FAILED error, in which case you may want to try
re-installing/updating MDAC, check system resources...
I am not sure if this is relevant! http://www.aspfaq.com/show.asp?id=2388
John
"Chris Trailer" wrote:
> Hi,
> Sql 2000 SP3a, Windows 2000 Enterprise, SP4
> I've extensively searched through most means (google, microsoft,
> newsgroups,etc) and really haven't found a definitive answer. There really
> isn't any real answers. I run an ASP and most clients on one of the
> production servers are experiencing this problem. My problem is when using
> bulk insert every once in awhile we'll receive a
> CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
> error. Restarting the service used to take care of this for awhile, but now
> this happens everyday.
> Is there any special hotfixes for this or a final fix for this? Or any
> other information on it. My next steps are to re-apply sp3a (sp4 hasn't
> made it through testing yet), if that fails register the IMPPROV.dll ...
> other than that... i'm out of ideas.
> Please Please help!!!!
> thanks in advance.
>
>
Wednesday, March 21, 2012
Error: 17883 - The scheduler 0 appears to be hung...
Environment:
Clustered SQL Server 2K sp3a (single instance)
Product version: 8.00.760
Problem:
I end up in error 17883.
I am aware that the solution is to apply this patch:
821277 MS03-031:Security Patch for SQL Server 2000 Service
Pack 3.
I am also aware that after you install this cumulative
patch you will end up in this problem:
826161 FIX: You are prompted for password after you change
a standard SQL Server login.
After reading this one I found that there are 2
possibility to solve this problem, one if you have already
installed the security patch from MS03-031 and another one
if you do NOT have installed this patch.
Question:
Do I only need to apply this last one (is it also
cumulative?) or do I need to first apply MS03-031 and then
later the FIX 826161?
Please advise.
Kind regards.
You will need to follow the instructions in the section "If you have not
installed the security patch for Microsoft Security Bulletin
MS03-031,Q826161..." . This will include the
fix for the Enterprise Manager issue.
Additionally, this will not fix the cause of the 17883. This will only
provide additional diagnostic information for Microsoft Support should a
17883 occur which was not available in previous builds. If you believe you
are seeing performance issues at the time the 17883's are being recorded, I
urge you to open a case with Microsoft Support for assistance.
Regards,
Farooq Mahmud [MS SQL Support]
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
|||Thank you so much for your answer.
I still don't understand why, when you read MS KB article
810885,under resolution, you find the reference for MS03-
031 Cumulative Security Patch for SQL Server.
What does this cumulative patch solve?
I was sure that it will solve many problems, most of them
security related, but also the 17883 problem.
If this cumulative patch does not solve the 17883 problem
so I don't need to install any patch, right?
Am I wrong?
Please advise.
Clustered SQL Server 2K sp3a (single instance)
Product version: 8.00.760
Problem:
I end up in error 17883.
I am aware that the solution is to apply this patch:
821277 MS03-031:Security Patch for SQL Server 2000 Service
Pack 3.
I am also aware that after you install this cumulative
patch you will end up in this problem:
826161 FIX: You are prompted for password after you change
a standard SQL Server login.
After reading this one I found that there are 2
possibility to solve this problem, one if you have already
installed the security patch from MS03-031 and another one
if you do NOT have installed this patch.
Question:
Do I only need to apply this last one (is it also
cumulative?) or do I need to first apply MS03-031 and then
later the FIX 826161?
Please advise.
Kind regards.
You will need to follow the instructions in the section "If you have not
installed the security patch for Microsoft Security Bulletin
MS03-031,Q826161..." . This will include the
fix for the Enterprise Manager issue.
Additionally, this will not fix the cause of the 17883. This will only
provide additional diagnostic information for Microsoft Support should a
17883 occur which was not available in previous builds. If you believe you
are seeing performance issues at the time the 17883's are being recorded, I
urge you to open a case with Microsoft Support for assistance.
Regards,
Farooq Mahmud [MS SQL Support]
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
|||Thank you so much for your answer.
I still don't understand why, when you read MS KB article
810885,under resolution, you find the reference for MS03-
031 Cumulative Security Patch for SQL Server.
What does this cumulative patch solve?
I was sure that it will solve many problems, most of them
security related, but also the 17883 problem.
If this cumulative patch does not solve the 17883 problem
so I don't need to install any patch, right?
Am I wrong?
Please advise.
Monday, March 19, 2012
Error: 17803, Severity: 20, State: 17
I have an application connected to a machine running MSSQL Server 2000 SP3a
Std Edition. Machine is 2.8GHZ, Windows Server 2000. This application runs
extensive query periodically. Over a period of time, I notice through Task
Manager the sqlservr.exe memory usage has grow to ~1.6GB. When this happen,
the application experience slowdown and eventually hang out.
SQL ERRORLog show
2005-04-22 07:16:36.45 spid1 LazyWriter: warning, no free buffers found.
2005-04-22 07:16:36.45 spid1 Buffer Distribution: Stolen=159182 Free=0
Procedures=22931
Inram=0 Dirty=24545 Kept=0
I/O=0, Latched=2022, Other=0
2005-04-22 07:16:36.45 spid1 Buffer Counts: Commited=208680
Target=208680 Hashed=26567
InternalReservation=2130 ExternalReservation=57 Min Free=512
2005-04-22 07:16:36.45 spid1 Procedure Cache: TotalProcs=3969
TotalPages=22931 InUsePages=22931
2005-04-22 07:16:36.45 spid1 Dynamic Memory Manager: Stolen=182112 OS
Reserved=2544
OS Committed=2487
OS In Use=2468
Query Plan=166599 Optimizer=3
General=14803
Utilities=7 Connection=2910
2005-04-22 07:16:36.45 spid1 Global Memory Objects: Resource=11637
Locks=147
SQLCache=1236 Replication=2
LockBytes=2 ServerGlobal=43
Xact=1862
2005-04-22 07:16:36.45 spid1 Query Memory Manager: Grants=1 Waiting=0
Maximum=13450 Available=13392
2005-04-22 07:16:36.70 server Error: 17803, Severity: 20, State: 17
2005-04-22 07:16:36.70 server Insufficient memory available..
I'm currently using SQL Server 2000 Driver for JDBC (with
SelectMethod=Cursor). From SQL Profiler, I do see alot of sp_cursorfetch
calls that don't have a corresponding sp_cursorclose.
Help is greatly appreaciated here!SQL ran out of free buffers (Free=0). You should probably apply the latest
SQL Server hotfix and update JDBC drivers to prevent problems such as 818095
and 837957. In addition, there are changes in the latest SQL hotfixes which
allow Lazy Writer to run more aggressively when it detects a low number of
free buffers.
If the problems persist engage MS product support and have them check your
server for additional leaks.
Adrian
"SS" <SS@.discussions.microsoft.com> wrote in message
news:884EB064-D4C5-4454-A8B4-A151EBC0ED11@.microsoft.com...
>I have an application connected to a machine running MSSQL Server 2000 SP3a
> Std Edition. Machine is 2.8GHZ, Windows Server 2000. This application runs
> extensive query periodically. Over a period of time, I notice through Task
> Manager the sqlservr.exe memory usage has grow to ~1.6GB. When this
> happen,
> the application experience slowdown and eventually hang out.
> SQL ERRORLog show
> 2005-04-22 07:16:36.45 spid1 LazyWriter: warning, no free buffers
> found.
> 2005-04-22 07:16:36.45 spid1 Buffer Distribution: Stolen=159182
> Free=0
> Procedures=22931
> Inram=0 Dirty=24545 Kept=0
> I/O=0, Latched=2022, Other=0
> 2005-04-22 07:16:36.45 spid1 Buffer Counts: Commited=208680
> Target=208680 Hashed=26567
> InternalReservation=2130 ExternalReservation=57 Min Free=512
> 2005-04-22 07:16:36.45 spid1 Procedure Cache: TotalProcs=3969
> TotalPages=22931 InUsePages=22931
> 2005-04-22 07:16:36.45 spid1 Dynamic Memory Manager: Stolen=182112 OS
> Reserved=2544
> OS Committed=2487
> OS In Use=2468
> Query Plan=166599 Optimizer=3
> General=14803
> Utilities=7 Connection=2910
> 2005-04-22 07:16:36.45 spid1 Global Memory Objects: Resource=11637
> Locks=147
> SQLCache=1236 Replication=2
> LockBytes=2 ServerGlobal=43
> Xact=1862
> 2005-04-22 07:16:36.45 spid1 Query Memory Manager: Grants=1 Waiting=0
> Maximum=13450 Available=13392
> 2005-04-22 07:16:36.70 server Error: 17803, Severity: 20, State: 17
> 2005-04-22 07:16:36.70 server Insufficient memory available..
> I'm currently using SQL Server 2000 Driver for JDBC (with
> SelectMethod=Cursor). From SQL Profiler, I do see alot of sp_cursorfetch
> calls that don't have a corresponding sp_cursorclose.
> Help is greatly appreaciated here!
>
Std Edition. Machine is 2.8GHZ, Windows Server 2000. This application runs
extensive query periodically. Over a period of time, I notice through Task
Manager the sqlservr.exe memory usage has grow to ~1.6GB. When this happen,
the application experience slowdown and eventually hang out.
SQL ERRORLog show
2005-04-22 07:16:36.45 spid1 LazyWriter: warning, no free buffers found.
2005-04-22 07:16:36.45 spid1 Buffer Distribution: Stolen=159182 Free=0
Procedures=22931
Inram=0 Dirty=24545 Kept=0
I/O=0, Latched=2022, Other=0
2005-04-22 07:16:36.45 spid1 Buffer Counts: Commited=208680
Target=208680 Hashed=26567
InternalReservation=2130 ExternalReservation=57 Min Free=512
2005-04-22 07:16:36.45 spid1 Procedure Cache: TotalProcs=3969
TotalPages=22931 InUsePages=22931
2005-04-22 07:16:36.45 spid1 Dynamic Memory Manager: Stolen=182112 OS
Reserved=2544
OS Committed=2487
OS In Use=2468
Query Plan=166599 Optimizer=3
General=14803
Utilities=7 Connection=2910
2005-04-22 07:16:36.45 spid1 Global Memory Objects: Resource=11637
Locks=147
SQLCache=1236 Replication=2
LockBytes=2 ServerGlobal=43
Xact=1862
2005-04-22 07:16:36.45 spid1 Query Memory Manager: Grants=1 Waiting=0
Maximum=13450 Available=13392
2005-04-22 07:16:36.70 server Error: 17803, Severity: 20, State: 17
2005-04-22 07:16:36.70 server Insufficient memory available..
I'm currently using SQL Server 2000 Driver for JDBC (with
SelectMethod=Cursor). From SQL Profiler, I do see alot of sp_cursorfetch
calls that don't have a corresponding sp_cursorclose.
Help is greatly appreaciated here!SQL ran out of free buffers (Free=0). You should probably apply the latest
SQL Server hotfix and update JDBC drivers to prevent problems such as 818095
and 837957. In addition, there are changes in the latest SQL hotfixes which
allow Lazy Writer to run more aggressively when it detects a low number of
free buffers.
If the problems persist engage MS product support and have them check your
server for additional leaks.
Adrian
"SS" <SS@.discussions.microsoft.com> wrote in message
news:884EB064-D4C5-4454-A8B4-A151EBC0ED11@.microsoft.com...
>I have an application connected to a machine running MSSQL Server 2000 SP3a
> Std Edition. Machine is 2.8GHZ, Windows Server 2000. This application runs
> extensive query periodically. Over a period of time, I notice through Task
> Manager the sqlservr.exe memory usage has grow to ~1.6GB. When this
> happen,
> the application experience slowdown and eventually hang out.
> SQL ERRORLog show
> 2005-04-22 07:16:36.45 spid1 LazyWriter: warning, no free buffers
> found.
> 2005-04-22 07:16:36.45 spid1 Buffer Distribution: Stolen=159182
> Free=0
> Procedures=22931
> Inram=0 Dirty=24545 Kept=0
> I/O=0, Latched=2022, Other=0
> 2005-04-22 07:16:36.45 spid1 Buffer Counts: Commited=208680
> Target=208680 Hashed=26567
> InternalReservation=2130 ExternalReservation=57 Min Free=512
> 2005-04-22 07:16:36.45 spid1 Procedure Cache: TotalProcs=3969
> TotalPages=22931 InUsePages=22931
> 2005-04-22 07:16:36.45 spid1 Dynamic Memory Manager: Stolen=182112 OS
> Reserved=2544
> OS Committed=2487
> OS In Use=2468
> Query Plan=166599 Optimizer=3
> General=14803
> Utilities=7 Connection=2910
> 2005-04-22 07:16:36.45 spid1 Global Memory Objects: Resource=11637
> Locks=147
> SQLCache=1236 Replication=2
> LockBytes=2 ServerGlobal=43
> Xact=1862
> 2005-04-22 07:16:36.45 spid1 Query Memory Manager: Grants=1 Waiting=0
> Maximum=13450 Available=13392
> 2005-04-22 07:16:36.70 server Error: 17803, Severity: 20, State: 17
> 2005-04-22 07:16:36.70 server Insufficient memory available..
> I'm currently using SQL Server 2000 Driver for JDBC (with
> SelectMethod=Cursor). From SQL Profiler, I do see alot of sp_cursorfetch
> calls that don't have a corresponding sp_cursorclose.
> Help is greatly appreaciated here!
>
Subscribe to:
Posts (Atom)