What does the following error message mean?
I have removed all reference(s) to parameter @.Individual from report.
ERROR:
[rsParameterReference] The Value expression for the query parameter
â'@.Individualâ' refers to a non-existing report parameter â'IndividualResolved!
Had to change/update XML file with new values as follows:
<QueryParameter Name="@.Individual">
<Value>=Parameters!Individual.Value</Value>
</QueryParameter>
"Terry" wrote:
> What does the following error message mean?
> I have removed all reference(s) to parameter @.Individual from report.
> ERROR:
> [rsParameterReference] The Value expression for the query parameter
> â'@.Individualâ' refers to a non-existing report parameter â'Individual|||There is a mapping that occurs from the query parameter to the report
Parameter. Go to the dataset where the query is defined and see if you have
a query parameter. If not, click on the ..., parameters tab and remove the
mapping.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Terry" <Terry@.discussions.microsoft.com> wrote in message
news:3FF16775-6566-463E-A1D4-529A6F21C626@.microsoft.com...
> What does the following error message mean?
> I have removed all reference(s) to parameter @.Individual from report.
> ERROR:
> [rsParameterReference] The Value expression for the query parameter
> '@.Individual' refers to a non-existing report parameter 'Individual|||Thank you!
"Bruce L-C [MVP]" wrote:
> There is a mapping that occurs from the query parameter to the report
> Parameter. Go to the dataset where the query is defined and see if you have
> a query parameter. If not, click on the ..., parameters tab and remove the
> mapping.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Terry" <Terry@.discussions.microsoft.com> wrote in message
> news:3FF16775-6566-463E-A1D4-529A6F21C626@.microsoft.com...
> > What does the following error message mean?
> >
> > I have removed all reference(s) to parameter @.Individual from report.
> >
> > ERROR:
> >
> > [rsParameterReference] The Value expression for the query parameter
> > '@.Individual' refers to a non-existing report parameter 'Individual
>
>
Sunday, February 26, 2012
Error message:
One of our production box is running really slow right now.. and I issue the following statement: DBCC MEMUSAGE and I got back the following error message:
Server: Msg 8966, Level 16, State 4, Line 1
Could not read and latch page (1:204858) with latch type SH. VerifyPageId failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:206393) with latch type SH. VerifyPageId failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:206392) with latch type SH. VerifyPageId failed.
Server: Msg 8966, Level 16, State 1, Line 1
The comment doesn't even finish. I thought there were some corruption on our databases, but I schedule a job and ran it through all our databases with DBCC checkdb. None of them seems to have any integrity or data corruption problem.
Any idea where else I should look for any possible problems? I free the buffer and procedure cache using
DBCC FREEPROCCACHE
go
DBCC DROPCLEANBUFFERS
go
already!
help!What sql server build are you on? You might consider going through
826433 PRB: Additional SQL Server Diagnostics Added to Detect Unreported I/O
http://support.microsoft.com/?id=826433 and also considre opening a case
with PSS Support for this.
In the meantime, I'd suggest you check your Application and Sys event logs
for hardware errors. Also check your backups. Do you see the same error
message after restoring them?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
Server: Msg 8966, Level 16, State 4, Line 1
Could not read and latch page (1:204858) with latch type SH. VerifyPageId failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:206393) with latch type SH. VerifyPageId failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:206392) with latch type SH. VerifyPageId failed.
Server: Msg 8966, Level 16, State 1, Line 1
The comment doesn't even finish. I thought there were some corruption on our databases, but I schedule a job and ran it through all our databases with DBCC checkdb. None of them seems to have any integrity or data corruption problem.
Any idea where else I should look for any possible problems? I free the buffer and procedure cache using
DBCC FREEPROCCACHE
go
DBCC DROPCLEANBUFFERS
go
already!
help!What sql server build are you on? You might consider going through
826433 PRB: Additional SQL Server Diagnostics Added to Detect Unreported I/O
http://support.microsoft.com/?id=826433 and also considre opening a case
with PSS Support for this.
In the meantime, I'd suggest you check your Application and Sys event logs
for hardware errors. Also check your backups. Do you see the same error
message after restoring them?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
Error Message.....
I am using SQL 2K.
I am calling the below SQL statement as one of the SQL task in one of the
step.
EXEC SP_CYCLE_ERRORLOG
I am getting the attached message.
How to solve it?
Thanks,
Alok
Below is the error message.
"EXCUTE permission denied on object 'sp_cycle_errolog', database
'master',owner 'dbo'"
Alok Choudhary wrote:
> I am using SQL 2K.
> I am calling the below SQL statement as one of the SQL task in one of
> the step.
> EXEC SP_CYCLE_ERRORLOG
> I am getting the attached message.
> How to solve it?
> Thanks,
> Alok
> Below is the error message.
> "EXCUTE permission denied on object 'sp_cycle_errolog', database
> 'master',owner 'dbo'"
Your user id does not have rights to execute that procedure because you
are probably not a system administrator. Admin rights are required.
David Gugick
Imceda Software
www.imceda.com
|||What server roles are you a member of? sp_cycle_errorlog is sysadmin only.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Alok Choudhary" <AC_Ind@.hotmail.com> wrote in message
news:eCsUogNCFHA.1396@.TK2MSFTNGP14.phx.gbl...
> I am using SQL 2K.
> I am calling the below SQL statement as one of the SQL task in one of the
> step.
> EXEC SP_CYCLE_ERRORLOG
> I am getting the attached message.
> How to solve it?
> Thanks,
> Alok
> Below is the error message.
> "EXCUTE permission denied on object 'sp_cycle_errolog', database
> 'master',owner 'dbo'"
>
>
I am calling the below SQL statement as one of the SQL task in one of the
step.
EXEC SP_CYCLE_ERRORLOG
I am getting the attached message.
How to solve it?
Thanks,
Alok
Below is the error message.
"EXCUTE permission denied on object 'sp_cycle_errolog', database
'master',owner 'dbo'"
Alok Choudhary wrote:
> I am using SQL 2K.
> I am calling the below SQL statement as one of the SQL task in one of
> the step.
> EXEC SP_CYCLE_ERRORLOG
> I am getting the attached message.
> How to solve it?
> Thanks,
> Alok
> Below is the error message.
> "EXCUTE permission denied on object 'sp_cycle_errolog', database
> 'master',owner 'dbo'"
Your user id does not have rights to execute that procedure because you
are probably not a system administrator. Admin rights are required.
David Gugick
Imceda Software
www.imceda.com
|||What server roles are you a member of? sp_cycle_errorlog is sysadmin only.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Alok Choudhary" <AC_Ind@.hotmail.com> wrote in message
news:eCsUogNCFHA.1396@.TK2MSFTNGP14.phx.gbl...
> I am using SQL 2K.
> I am calling the below SQL statement as one of the SQL task in one of the
> step.
> EXEC SP_CYCLE_ERRORLOG
> I am getting the attached message.
> How to solve it?
> Thanks,
> Alok
> Below is the error message.
> "EXCUTE permission denied on object 'sp_cycle_errolog', database
> 'master',owner 'dbo'"
>
>
Error Message.....
I am using SQL 2K.
I am calling the below SQL statement as one of the SQL task in one of the
step.
EXEC SP_CYCLE_ERRORLOG
I am getting the attached message.
How to solve it?
Thanks,
Alok
Below is the error message.
"EXCUTE permission denied on object 'sp_cycle_errolog', database
'master',owner 'dbo'"Alok Choudhary wrote:
> I am using SQL 2K.
> I am calling the below SQL statement as one of the SQL task in one of
> the step.
> EXEC SP_CYCLE_ERRORLOG
> I am getting the attached message.
> How to solve it?
> Thanks,
> Alok
> Below is the error message.
> "EXCUTE permission denied on object 'sp_cycle_errolog', database
> 'master',owner 'dbo'"
Your user id does not have rights to execute that procedure because you
are probably not a system administrator. Admin rights are required.
David Gugick
Imceda Software
www.imceda.com|||What server roles are you a member of? sp_cycle_errorlog is sysadmin only.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Alok Choudhary" <AC_Ind@.hotmail.com> wrote in message
news:eCsUogNCFHA.1396@.TK2MSFTNGP14.phx.gbl...
> I am using SQL 2K.
> I am calling the below SQL statement as one of the SQL task in one of the
> step.
> EXEC SP_CYCLE_ERRORLOG
> I am getting the attached message.
> How to solve it?
> Thanks,
> Alok
> Below is the error message.
> "EXCUTE permission denied on object 'sp_cycle_errolog', database
> 'master',owner 'dbo'"
>
>
I am calling the below SQL statement as one of the SQL task in one of the
step.
EXEC SP_CYCLE_ERRORLOG
I am getting the attached message.
How to solve it?
Thanks,
Alok
Below is the error message.
"EXCUTE permission denied on object 'sp_cycle_errolog', database
'master',owner 'dbo'"Alok Choudhary wrote:
> I am using SQL 2K.
> I am calling the below SQL statement as one of the SQL task in one of
> the step.
> EXEC SP_CYCLE_ERRORLOG
> I am getting the attached message.
> How to solve it?
> Thanks,
> Alok
> Below is the error message.
> "EXCUTE permission denied on object 'sp_cycle_errolog', database
> 'master',owner 'dbo'"
Your user id does not have rights to execute that procedure because you
are probably not a system administrator. Admin rights are required.
David Gugick
Imceda Software
www.imceda.com|||What server roles are you a member of? sp_cycle_errorlog is sysadmin only.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Alok Choudhary" <AC_Ind@.hotmail.com> wrote in message
news:eCsUogNCFHA.1396@.TK2MSFTNGP14.phx.gbl...
> I am using SQL 2K.
> I am calling the below SQL statement as one of the SQL task in one of the
> step.
> EXEC SP_CYCLE_ERRORLOG
> I am getting the attached message.
> How to solve it?
> Thanks,
> Alok
> Below is the error message.
> "EXCUTE permission denied on object 'sp_cycle_errolog', database
> 'master',owner 'dbo'"
>
>
Error Message.....
I am using SQL 2K.
I am calling the below SQL statement as one of the SQL task in one of the
step.
EXEC SP_CYCLE_ERRORLOG
I am getting the attached message.
How to solve it?
Thanks,
Alok
Below is the error message.
"EXCUTE permission denied on object 'sp_cycle_errolog', database
'master',owner 'dbo'"Alok Choudhary wrote:
> I am using SQL 2K.
> I am calling the below SQL statement as one of the SQL task in one of
> the step.
> EXEC SP_CYCLE_ERRORLOG
> I am getting the attached message.
> How to solve it?
> Thanks,
> Alok
> Below is the error message.
> "EXCUTE permission denied on object 'sp_cycle_errolog', database
> 'master',owner 'dbo'"
Your user id does not have rights to execute that procedure because you
are probably not a system administrator. Admin rights are required.
--
David Gugick
Imceda Software
www.imceda.com|||What server roles are you a member of? sp_cycle_errorlog is sysadmin only.
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Alok Choudhary" <AC_Ind@.hotmail.com> wrote in message
news:eCsUogNCFHA.1396@.TK2MSFTNGP14.phx.gbl...
> I am using SQL 2K.
> I am calling the below SQL statement as one of the SQL task in one of the
> step.
> EXEC SP_CYCLE_ERRORLOG
> I am getting the attached message.
> How to solve it?
> Thanks,
> Alok
> Below is the error message.
> "EXCUTE permission denied on object 'sp_cycle_errolog', database
> 'master',owner 'dbo'"
>
>
I am calling the below SQL statement as one of the SQL task in one of the
step.
EXEC SP_CYCLE_ERRORLOG
I am getting the attached message.
How to solve it?
Thanks,
Alok
Below is the error message.
"EXCUTE permission denied on object 'sp_cycle_errolog', database
'master',owner 'dbo'"Alok Choudhary wrote:
> I am using SQL 2K.
> I am calling the below SQL statement as one of the SQL task in one of
> the step.
> EXEC SP_CYCLE_ERRORLOG
> I am getting the attached message.
> How to solve it?
> Thanks,
> Alok
> Below is the error message.
> "EXCUTE permission denied on object 'sp_cycle_errolog', database
> 'master',owner 'dbo'"
Your user id does not have rights to execute that procedure because you
are probably not a system administrator. Admin rights are required.
--
David Gugick
Imceda Software
www.imceda.com|||What server roles are you a member of? sp_cycle_errorlog is sysadmin only.
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Alok Choudhary" <AC_Ind@.hotmail.com> wrote in message
news:eCsUogNCFHA.1396@.TK2MSFTNGP14.phx.gbl...
> I am using SQL 2K.
> I am calling the below SQL statement as one of the SQL task in one of the
> step.
> EXEC SP_CYCLE_ERRORLOG
> I am getting the attached message.
> How to solve it?
> Thanks,
> Alok
> Below is the error message.
> "EXCUTE permission denied on object 'sp_cycle_errolog', database
> 'master',owner 'dbo'"
>
>
error message....
hi
I have the followin code but it isnot working giving the following error message
String or binary data would be truncated.
The statement has been terminated.
string sqlStrInsert = "insert into tbl_izinTalep (b_date, e_date, info, cc, comment) values('" + dateTimePicker1.Value.ToString() + "' , '" + dateTimePicker2.Value.ToString() + "','" + textBox2.Text + "', '" + textBox3.Text + "', '" + textBox4.Text + "')";
SqlCommand command = newSqlCommand(sqlStrInsert, conn);
command.ExecuteNonQuery();
thanks
if this forum is out of my topic, please write the related forum's name
You really, really, really should not do that becasue this leaves a security hole for SQL injection, imagine you user input (which should be treaten as suspious), enter in the textbox2 the following text:'',NULL'); DROP DATABASE model; --
THis would cause the model database to be dropped, I am sure you don′t want to do this. :-) Always use parametrized queries for the access, that can′t be comnposed as easy as in the sample code of yours.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||
but I dont understand the security hole reason, how I overcome it please explain with a sample
thank you
|||hi,
Jens already provide the example..
you "load" a dynamic SQL statement into tbl_izinTalep table that must be evenutally executed...
if your loaded statement has been "tampered" with malicious code, like Jens said, you will be very sad 
your code is
string sqlStrInsert = "insert into tbl_izinTalep (b_date, e_date, info, cc, comment) values('" + dateTimePicker1.Value.ToString() + "' , '" + dateTimePicker2.Value.ToString() + "','" + textBox2.Text + "', '" + textBox3.Text + "', '" + textBox4.Text + "')";
but if someone adds "; DROP DATABASE model" to your statement, it will be executed as well..
have a look at http://www.sommarskog.se/dynamic_sql.html for futher info about dynamic SQL..
regards
error message....
hi
I have the followin code but it isnot working giving the following error message
String or binary data would be truncated.
The statement has been terminated.
string sqlStrInsert = "insert into tbl_izinTalep (b_date, e_date, info, cc, comment) values('" + dateTimePicker1.Value.ToString() + "' , '" + dateTimePicker2.Value.ToString() + "','" + textBox2.Text + "', '" + textBox3.Text + "', '" + textBox4.Text + "')";
SqlCommand command = new SqlCommand(sqlStrInsert, conn);
command.ExecuteNonQuery();
thanks
if this forum is out of my topic, please write the related forum's name
You really, really, really should not do that becasue this leaves a security hole for SQL injection, imagine you user input (which should be treaten as suspious), enter in the textbox2 the following text:'',NULL'); DROP DATABASE model; --
THis would cause the model database to be dropped, I am sure you don′t want to do this. :-) Always use parametrized queries for the access, that can′t be comnposed as easy as in the sample code of yours.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de|||
but I dont understand the security hole reason, how I overcome it please explain with a sample
thank you
|||hi,
Jens already provide the example..
you "load" a dynamic SQL statement into tbl_izinTalep table that must be evenutally executed...
if your loaded statement has been "tampered" with malicious code, like Jens said, you will be very sad
your code is
string sqlStrInsert = "insert into tbl_izinTalep (b_date, e_date, info, cc, comment) values('" + dateTimePicker1.Value.ToString() + "' , '" + dateTimePicker2.Value.ToString() + "','" + textBox2.Text + "', '" + textBox3.Text + "', '" + textBox4.Text + "')";
but if someone adds "; DROP DATABASE model" to your statement, it will be executed as well..
have a look at http://www.sommarskog.se/dynamic_sql.html for futher info about dynamic SQL..
regards
Error Message. Please help
I have 7 SQL Servers
They all sync once every hour.
One of my servers shows 2 Views (while the others show 4). SO I tried to create the missing view's and I get this error message
"ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named <name> already exists"
Thank You
Try refreshing enterprise manger.
Regards
Amish Shah
|||I used the right mouse button and clicked REFRESH.
and nothing happened.
Anything else I can try?
Thanks
"amish" <shahamishm@.gmail.com> wrote in message
news:1143649651.420463.246200@.v46g2000cwv.googlegr oups.com...
> Try refreshing enterprise manger.
>
> Regards
> Amish Shah
>
|||I have found disconnecting from the server and/or shutting down EM helps.
Joseph R.P. Maloney, CSP,CCP,CDP
"Shayaan Siddiqui" wrote:
> I used the right mouse button and clicked REFRESH.
> and nothing happened.
> Anything else I can try?
> Thanks
> "amish" <shahamishm@.gmail.com> wrote in message
> news:1143649651.420463.246200@.v46g2000cwv.googlegr oups.com...
>
>
|||How do you do this?
Do you click the "X" or is there another process?
Shayaan
"jrpm" <jrpm@.discussions.microsoft.com> wrote in message
news:9576EDFF-5EF4-4944-8B59-EF4422D1A05F@.microsoft.com...[vbcol=seagreen]
>I have found disconnecting from the server and/or shutting down EM helps.
> --
> Joseph R.P. Maloney, CSP,CCP,CDP
>
> "Shayaan Siddiqui" wrote:
|||Any suggestions?
Thanks
"Shayaan Siddiqui" <givethis@.mac.com> wrote in message news:e2hL$h0UGHA.5884@.TK2MSFTNGP14.phx.gbl...
I have 7 SQL Servers
They all sync once every hour.
One of my servers shows 2 Views (while the others show 4). SO I tried to create the missing view's and I get this error message
"ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named <name> already exists"
Thank You
They all sync once every hour.
One of my servers shows 2 Views (while the others show 4). SO I tried to create the missing view's and I get this error message
"ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named <name> already exists"
Thank You
Try refreshing enterprise manger.
Regards
Amish Shah
|||I used the right mouse button and clicked REFRESH.
and nothing happened.
Anything else I can try?
Thanks
"amish" <shahamishm@.gmail.com> wrote in message
news:1143649651.420463.246200@.v46g2000cwv.googlegr oups.com...
> Try refreshing enterprise manger.
>
> Regards
> Amish Shah
>
|||I have found disconnecting from the server and/or shutting down EM helps.
Joseph R.P. Maloney, CSP,CCP,CDP
"Shayaan Siddiqui" wrote:
> I used the right mouse button and clicked REFRESH.
> and nothing happened.
> Anything else I can try?
> Thanks
> "amish" <shahamishm@.gmail.com> wrote in message
> news:1143649651.420463.246200@.v46g2000cwv.googlegr oups.com...
>
>
|||How do you do this?
Do you click the "X" or is there another process?
Shayaan
"jrpm" <jrpm@.discussions.microsoft.com> wrote in message
news:9576EDFF-5EF4-4944-8B59-EF4422D1A05F@.microsoft.com...[vbcol=seagreen]
>I have found disconnecting from the server and/or shutting down EM helps.
> --
> Joseph R.P. Maloney, CSP,CCP,CDP
>
> "Shayaan Siddiqui" wrote:
|||Any suggestions?
Thanks
"Shayaan Siddiqui" <givethis@.mac.com> wrote in message news:e2hL$h0UGHA.5884@.TK2MSFTNGP14.phx.gbl...
I have 7 SQL Servers
They all sync once every hour.
One of my servers shows 2 Views (while the others show 4). SO I tried to create the missing view's and I get this error message
"ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named <name> already exists"
Thank You
Error Message. Please help
I have 7 SQL Servers
They all sync once every hour.
One of my servers shows 2 Views (while the others show 4). SO I tried to cre
ate the missing view's and I get this error message
"ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Ther
e is already an object named <name> already exists"
Thank YouTry refreshing enterprise manger.
Regards
Amish Shah|||I used the right mouse button and clicked REFRESH.
and nothing happened.
Anything else I can try?
Thanks
"amish" <shahamishm@.gmail.com> wrote in message
news:1143649651.420463.246200@.v46g2000cwv.googlegroups.com...
> Try refreshing enterprise manger.
>
> Regards
> Amish Shah
>|||I have found disconnecting from the server and/or shutting down EM helps.
--
Joseph R.P. Maloney, CSP,CCP,CDP
"Shayaan Siddiqui" wrote:
> I used the right mouse button and clicked REFRESH.
> and nothing happened.
> Anything else I can try?
> Thanks
> "amish" <shahamishm@.gmail.com> wrote in message
> news:1143649651.420463.246200@.v46g2000cwv.googlegroups.com...
>
>|||How do you do this?
Do you click the "X" or is there another process?
Shayaan
"jrpm" <jrpm@.discussions.microsoft.com> wrote in message
news:9576EDFF-5EF4-4944-8B59-EF4422D1A05F@.microsoft.com...[vbcol=seagreen]
>I have found disconnecting from the server and/or shutting down EM helps.
> --
> Joseph R.P. Maloney, CSP,CCP,CDP
>
> "Shayaan Siddiqui" wrote:
>|||Any suggestions?
Thanks
"Shayaan Siddiqui" <givethis@.mac.com> wrote in message news:e2hL$h0UGHA.5884
@.TK2MSFTNGP14.phx.gbl...
I have 7 SQL Servers
They all sync once every hour.
One of my servers shows 2 Views (while the others show 4). SO I tried to cre
ate the missing view's and I get this error message
"ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Ther
e is already an object named <name> already exists"
Thank You
They all sync once every hour.
One of my servers shows 2 Views (while the others show 4). SO I tried to cre
ate the missing view's and I get this error message
"ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Ther
e is already an object named <name> already exists"
Thank YouTry refreshing enterprise manger.
Regards
Amish Shah|||I used the right mouse button and clicked REFRESH.
and nothing happened.
Anything else I can try?
Thanks
"amish" <shahamishm@.gmail.com> wrote in message
news:1143649651.420463.246200@.v46g2000cwv.googlegroups.com...
> Try refreshing enterprise manger.
>
> Regards
> Amish Shah
>|||I have found disconnecting from the server and/or shutting down EM helps.
--
Joseph R.P. Maloney, CSP,CCP,CDP
"Shayaan Siddiqui" wrote:
> I used the right mouse button and clicked REFRESH.
> and nothing happened.
> Anything else I can try?
> Thanks
> "amish" <shahamishm@.gmail.com> wrote in message
> news:1143649651.420463.246200@.v46g2000cwv.googlegroups.com...
>
>|||How do you do this?
Do you click the "X" or is there another process?
Shayaan
"jrpm" <jrpm@.discussions.microsoft.com> wrote in message
news:9576EDFF-5EF4-4944-8B59-EF4422D1A05F@.microsoft.com...[vbcol=seagreen]
>I have found disconnecting from the server and/or shutting down EM helps.
> --
> Joseph R.P. Maloney, CSP,CCP,CDP
>
> "Shayaan Siddiqui" wrote:
>|||Any suggestions?
Thanks
"Shayaan Siddiqui" <givethis@.mac.com> wrote in message news:e2hL$h0UGHA.5884
@.TK2MSFTNGP14.phx.gbl...
I have 7 SQL Servers
They all sync once every hour.
One of my servers shows 2 Views (while the others show 4). SO I tried to cre
ate the missing view's and I get this error message
"ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Ther
e is already an object named <name> already exists"
Thank You
Error Message. Please help
This is a multi-part message in MIME format.
--=_NextPart_000_0006_01C6531E.93D6CCD0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I have 7 SQL Servers
They all sync once every hour.
One of my servers shows 2 Views (while the others show 4). SO I tried to = create the missing view's and I get this error message
"ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]There is = already an object named <name> already exists"
Thank You
--=_NextPart_000_0006_01C6531E.93D6CCD0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
I have 7 SQL Servers
They all sync once every = hour.
One of my servers shows 2 Views (while = the others show 4). SO I tried to create the missing view's and I get this error message
"ODBC error: [Microsoft][ODBC = SQL Server Driver][SQL Server]There is already an object named already = exists"
Thank You
--=_NextPart_000_0006_01C6531E.93D6CCD0--Try refreshing enterprise manger.
Regards
Amish Shah|||I used the right mouse button and clicked REFRESH.
and nothing happened.
Anything else I can try?
Thanks
"amish" <shahamishm@.gmail.com> wrote in message
news:1143649651.420463.246200@.v46g2000cwv.googlegroups.com...
> Try refreshing enterprise manger.
>
> Regards
> Amish Shah
>|||I have found disconnecting from the server and/or shutting down EM helps.
--
Joseph R.P. Maloney, CSP,CCP,CDP
"Shayaan Siddiqui" wrote:
> I used the right mouse button and clicked REFRESH.
> and nothing happened.
> Anything else I can try?
> Thanks
> "amish" <shahamishm@.gmail.com> wrote in message
> news:1143649651.420463.246200@.v46g2000cwv.googlegroups.com...
> > Try refreshing enterprise manger.
> >
> >
> > Regards
> > Amish Shah
> >
>
>|||How do you do this?
Do you click the "X" or is there another process?
Shayaan
"jrpm" <jrpm@.discussions.microsoft.com> wrote in message
news:9576EDFF-5EF4-4944-8B59-EF4422D1A05F@.microsoft.com...
>I have found disconnecting from the server and/or shutting down EM helps.
> --
> Joseph R.P. Maloney, CSP,CCP,CDP
>
> "Shayaan Siddiqui" wrote:
>> I used the right mouse button and clicked REFRESH.
>> and nothing happened.
>> Anything else I can try?
>> Thanks
>> "amish" <shahamishm@.gmail.com> wrote in message
>> news:1143649651.420463.246200@.v46g2000cwv.googlegroups.com...
>> > Try refreshing enterprise manger.
>> >
>> >
>> > Regards
>> > Amish Shah
>> >
>>|||This is a multi-part message in MIME format.
--=_NextPart_000_0008_01C653E0.B89F5FB0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Any suggestions?
Thanks
"Shayaan Siddiqui" <givethis@.mac.com> wrote in message =news:e2hL$h0UGHA.5884@.TK2MSFTNGP14.phx.gbl...
I have 7 SQL Servers
They all sync once every hour.
One of my servers shows 2 Views (while the others show 4). SO I tried =to create the missing view's and I get this error message
"ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]There is =already an object named <name> already exists"
Thank You
--=_NextPart_000_0008_01C653E0.B89F5FB0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Any suggestions?
Thanks
"Shayaan Siddiqui" wrote in =message news:e2hL$h0UGHA.5884=@.TK2MSFTNGP14.phx.gbl...
I have 7 SQL Servers
They all sync once every =hour.
One of my servers shows 2 Views =(while the others show 4). SO I tried to create the missing view's and I get this error message
"ODBC error: [Microsoft][ODBC =SQL Server Driver][SQL Server]There is already an object named =already exists"
Thank =You
--=_NextPart_000_0008_01C653E0.B89F5FB0--
--=_NextPart_000_0006_01C6531E.93D6CCD0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I have 7 SQL Servers
They all sync once every hour.
One of my servers shows 2 Views (while the others show 4). SO I tried to = create the missing view's and I get this error message
"ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]There is = already an object named <name> already exists"
Thank You
--=_NextPart_000_0006_01C6531E.93D6CCD0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
I have 7 SQL Servers
They all sync once every = hour.
One of my servers shows 2 Views (while = the others show 4). SO I tried to create the missing view's and I get this error message
"ODBC error: [Microsoft][ODBC = SQL Server Driver][SQL Server]There is already an object named already = exists"
Thank You
--=_NextPart_000_0006_01C6531E.93D6CCD0--Try refreshing enterprise manger.
Regards
Amish Shah|||I used the right mouse button and clicked REFRESH.
and nothing happened.
Anything else I can try?
Thanks
"amish" <shahamishm@.gmail.com> wrote in message
news:1143649651.420463.246200@.v46g2000cwv.googlegroups.com...
> Try refreshing enterprise manger.
>
> Regards
> Amish Shah
>|||I have found disconnecting from the server and/or shutting down EM helps.
--
Joseph R.P. Maloney, CSP,CCP,CDP
"Shayaan Siddiqui" wrote:
> I used the right mouse button and clicked REFRESH.
> and nothing happened.
> Anything else I can try?
> Thanks
> "amish" <shahamishm@.gmail.com> wrote in message
> news:1143649651.420463.246200@.v46g2000cwv.googlegroups.com...
> > Try refreshing enterprise manger.
> >
> >
> > Regards
> > Amish Shah
> >
>
>|||How do you do this?
Do you click the "X" or is there another process?
Shayaan
"jrpm" <jrpm@.discussions.microsoft.com> wrote in message
news:9576EDFF-5EF4-4944-8B59-EF4422D1A05F@.microsoft.com...
>I have found disconnecting from the server and/or shutting down EM helps.
> --
> Joseph R.P. Maloney, CSP,CCP,CDP
>
> "Shayaan Siddiqui" wrote:
>> I used the right mouse button and clicked REFRESH.
>> and nothing happened.
>> Anything else I can try?
>> Thanks
>> "amish" <shahamishm@.gmail.com> wrote in message
>> news:1143649651.420463.246200@.v46g2000cwv.googlegroups.com...
>> > Try refreshing enterprise manger.
>> >
>> >
>> > Regards
>> > Amish Shah
>> >
>>|||This is a multi-part message in MIME format.
--=_NextPart_000_0008_01C653E0.B89F5FB0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Any suggestions?
Thanks
"Shayaan Siddiqui" <givethis@.mac.com> wrote in message =news:e2hL$h0UGHA.5884@.TK2MSFTNGP14.phx.gbl...
I have 7 SQL Servers
They all sync once every hour.
One of my servers shows 2 Views (while the others show 4). SO I tried =to create the missing view's and I get this error message
"ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]There is =already an object named <name> already exists"
Thank You
--=_NextPart_000_0008_01C653E0.B89F5FB0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Any suggestions?
Thanks
"Shayaan Siddiqui"
I have 7 SQL Servers
They all sync once every =hour.
One of my servers shows 2 Views =(while the others show 4). SO I tried to create the missing view's and I get this error message
"ODBC error: [Microsoft][ODBC =SQL Server Driver][SQL Server]There is already an object named =already exists"
Thank =You
--=_NextPart_000_0008_01C653E0.B89F5FB0--
error message!
Today a user just called me and said she got an SQL error
message when she tried to run a batch.
I changed the dex.ini file (found in the application root)
to log error messages.
Change the following statements from FALSE to TRUE.
SQLLogSQLStmt=TRUE
SQLLogODBCMessages=TRUE
SQLLogAllODBCMessages=TRUE
and a file called dexsql.log is created in the same
directory.
The errors that appeared in the log file where:
--
/* Date: 01/12/2004 Time: 11:07:45
stmt(26501640):*/
DELETE payrolldb.dbo.CPY30160
SELECT COUNT(*) FROM payrolldb.dbo.CPY30160
/*
/* Date: 01/12/2004 Time: 11:08:28
SQLSTATE:(S1T00) Native Err:(0) stmt(26501640):*/
[Microsoft][ODBC SQL Server Driver]Timeout expired*/
/*
/* Date: 01/12/2004 Time: 11:08:28
SQLSTATE:(00000) Native Err:(0) stmt(26501640):*/
*/
/*
/* Date: 01/12/2004 Time: 11:08:28
SQLSTATE:(00000) Native Err:(0) status(55):*/
SWSTATUS DUMP*/
/*
--
/* Date: 01/12/2004 Time: 11:08:34
stmt(26519888):*/
DELETE payrolldb.dbo.CPY30161
SELECT COUNT(*) FROM payrolldb.dbo.CPY30161
/*
/* Date: 01/12/2004 Time: 11:09:05
SQLSTATE:(S1T00) Native Err:(0) stmt(26519888):*/
[Microsoft][ODBC SQL Server Driver]Timeout expired*/
/*
/* Date: 01/12/2004 Time: 11:09:05
SQLSTATE:(00000) Native Err:(0) stmt(26519888):*/
*/
/*
/* Date: 01/12/2004 Time: 11:09:05
SQLSTATE:(00000) Native Err:(0) status(55):*/
SWSTATUS DUMP*/
---
I went into SQL Query analyzer and ran the statements
interactively and they both worked.
then she re-started the Batch Calculation and everything
ran fine.
Does anyone know why we got this errors?
Thanks in advance-RobYou are seeing a timeout error. You can find some general info on this at:
http://vyaskn.tripod.com/sql_odbc_timeout_expired.htm
http://vyaskn.tripod.com/watch_your_timeouts.htm
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Rob" <rob@.nul.ca> wrote in message
news:012301c3d93a$f2ebb510$a401280a@.phx.gbl...
Today a user just called me and said she got an SQL error
message when she tried to run a batch.
I changed the dex.ini file (found in the application root)
to log error messages.
Change the following statements from FALSE to TRUE.
SQLLogSQLStmt=TRUE
SQLLogODBCMessages=TRUE
SQLLogAllODBCMessages=TRUE
and a file called dexsql.log is created in the same
directory.
The errors that appeared in the log file where:
--
/* Date: 01/12/2004 Time: 11:07:45
stmt(26501640):*/
DELETE payrolldb.dbo.CPY30160
SELECT COUNT(*) FROM payrolldb.dbo.CPY30160
/*
/* Date: 01/12/2004 Time: 11:08:28
SQLSTATE:(S1T00) Native Err:(0) stmt(26501640):*/
[Microsoft][ODBC SQL Server Driver]Timeout expired*/
/*
/* Date: 01/12/2004 Time: 11:08:28
SQLSTATE:(00000) Native Err:(0) stmt(26501640):*/
*/
/*
/* Date: 01/12/2004 Time: 11:08:28
SQLSTATE:(00000) Native Err:(0) status(55):*/
SWSTATUS DUMP*/
/*
--
/* Date: 01/12/2004 Time: 11:08:34
stmt(26519888):*/
DELETE payrolldb.dbo.CPY30161
SELECT COUNT(*) FROM payrolldb.dbo.CPY30161
/*
/* Date: 01/12/2004 Time: 11:09:05
SQLSTATE:(S1T00) Native Err:(0) stmt(26519888):*/
[Microsoft][ODBC SQL Server Driver]Timeout expired*/
/*
/* Date: 01/12/2004 Time: 11:09:05
SQLSTATE:(00000) Native Err:(0) stmt(26519888):*/
*/
/*
/* Date: 01/12/2004 Time: 11:09:05
SQLSTATE:(00000) Native Err:(0) status(55):*/
SWSTATUS DUMP*/
---
I went into SQL Query analyzer and ran the statements
interactively and they both worked.
then she re-started the Batch Calculation and everything
ran fine.
Does anyone know why we got this errors?
Thanks in advance-Rob|||Hi Rob,
My name is Michael and I would like to thank you for using Microsoft
newsgroup.
Before we go any further, I would like to collect more information from you:
1. Can you please tell me how you run this batch? Do you run it in an ADO
application?
2. What is the connection string? Which provider you use to connect to SQL
Server?
3. When does the timeout error occur? Are you sure that the timeout error
occurred when your customer performed the batch?
In the following situations I agree with Vyas:
1. If you ran the batch in an ADO application
2. If the timeout error occurred, when your customer was running the batch
but not when they were connected to SQL Serer.
3. If the batch works fine using Query Analyzer.
As we know, there are two kinds of timeout in ADO: connection timeout and
query timeout. The default connectiontimeout is 15 seconds. The default
commandtimeout is 30 seconds. If the system is overloaded, the default
value may be too small, please increase these value to see if the problem
still occur.
con.connectiontimeout=150
con.commandtimeout=300
Also, the root solution is that you can improve the query performance to
decrease the execution time.
Thanks for using Microsoft newsgroup.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.|||Hi Michael,
I dont know how to increase the timeout?
where is the following settings?
con.connectiontimeout=150
con.commandtimeout=300
Thanks-Rob
>--Original Message--
>Hi Rob,
>My name is Michael and I would like to thank you for
using Microsoft
>newsgroup.
>Before we go any further, I would like to collect more
information from you:
>1. Can you please tell me how you run this batch? Do you
run it in an ADO
>application?
>2. What is the connection string? Which provider you use
to connect to SQL
>Server?
>3. When does the timeout error occur? Are you sure that
the timeout error
>occurred when your customer performed the batch?
>In the following situations I agree with Vyas:
>1. If you ran the batch in an ADO application
>2. If the timeout error occurred, when your customer was
running the batch
>but not when they were connected to SQL Serer.
>3. If the batch works fine using Query Analyzer.
>As we know, there are two kinds of timeout in ADO:
connection timeout and
>query timeout. The default connectiontimeout is 15
seconds. The default
>commandtimeout is 30 seconds. If the system is
overloaded, the default
>value may be too small, please increase these value to
see if the problem
>still occur.
>con.connectiontimeout=150
>con.commandtimeout=300
>Also, the root solution is that you can improve the query
performance to
>decrease the execution time.
>Thanks for using Microsoft newsgroup.
>Regards,
>Michael Shao
>Microsoft Online Partner Support
>Get Secure! - www.microsoft.com/security
>This posting is provided "as is" with no warranties and
confers no rights.
>.
>|||Hi Rob,
Thanks for your feedback. CommandTimeout Property in ADO indicates how long
to wait while executing a command before terminating the attempt and
generating an error.
CommandTimeout Property
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/
mdapro02_5.asp
Thanks for using Microsoft newsgroup.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
message when she tried to run a batch.
I changed the dex.ini file (found in the application root)
to log error messages.
Change the following statements from FALSE to TRUE.
SQLLogSQLStmt=TRUE
SQLLogODBCMessages=TRUE
SQLLogAllODBCMessages=TRUE
and a file called dexsql.log is created in the same
directory.
The errors that appeared in the log file where:
--
/* Date: 01/12/2004 Time: 11:07:45
stmt(26501640):*/
DELETE payrolldb.dbo.CPY30160
SELECT COUNT(*) FROM payrolldb.dbo.CPY30160
/*
/* Date: 01/12/2004 Time: 11:08:28
SQLSTATE:(S1T00) Native Err:(0) stmt(26501640):*/
[Microsoft][ODBC SQL Server Driver]Timeout expired*/
/*
/* Date: 01/12/2004 Time: 11:08:28
SQLSTATE:(00000) Native Err:(0) stmt(26501640):*/
*/
/*
/* Date: 01/12/2004 Time: 11:08:28
SQLSTATE:(00000) Native Err:(0) status(55):*/
SWSTATUS DUMP*/
/*
--
/* Date: 01/12/2004 Time: 11:08:34
stmt(26519888):*/
DELETE payrolldb.dbo.CPY30161
SELECT COUNT(*) FROM payrolldb.dbo.CPY30161
/*
/* Date: 01/12/2004 Time: 11:09:05
SQLSTATE:(S1T00) Native Err:(0) stmt(26519888):*/
[Microsoft][ODBC SQL Server Driver]Timeout expired*/
/*
/* Date: 01/12/2004 Time: 11:09:05
SQLSTATE:(00000) Native Err:(0) stmt(26519888):*/
*/
/*
/* Date: 01/12/2004 Time: 11:09:05
SQLSTATE:(00000) Native Err:(0) status(55):*/
SWSTATUS DUMP*/
---
I went into SQL Query analyzer and ran the statements
interactively and they both worked.
then she re-started the Batch Calculation and everything
ran fine.
Does anyone know why we got this errors?
Thanks in advance-RobYou are seeing a timeout error. You can find some general info on this at:
http://vyaskn.tripod.com/sql_odbc_timeout_expired.htm
http://vyaskn.tripod.com/watch_your_timeouts.htm
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Rob" <rob@.nul.ca> wrote in message
news:012301c3d93a$f2ebb510$a401280a@.phx.gbl...
Today a user just called me and said she got an SQL error
message when she tried to run a batch.
I changed the dex.ini file (found in the application root)
to log error messages.
Change the following statements from FALSE to TRUE.
SQLLogSQLStmt=TRUE
SQLLogODBCMessages=TRUE
SQLLogAllODBCMessages=TRUE
and a file called dexsql.log is created in the same
directory.
The errors that appeared in the log file where:
--
/* Date: 01/12/2004 Time: 11:07:45
stmt(26501640):*/
DELETE payrolldb.dbo.CPY30160
SELECT COUNT(*) FROM payrolldb.dbo.CPY30160
/*
/* Date: 01/12/2004 Time: 11:08:28
SQLSTATE:(S1T00) Native Err:(0) stmt(26501640):*/
[Microsoft][ODBC SQL Server Driver]Timeout expired*/
/*
/* Date: 01/12/2004 Time: 11:08:28
SQLSTATE:(00000) Native Err:(0) stmt(26501640):*/
*/
/*
/* Date: 01/12/2004 Time: 11:08:28
SQLSTATE:(00000) Native Err:(0) status(55):*/
SWSTATUS DUMP*/
/*
--
/* Date: 01/12/2004 Time: 11:08:34
stmt(26519888):*/
DELETE payrolldb.dbo.CPY30161
SELECT COUNT(*) FROM payrolldb.dbo.CPY30161
/*
/* Date: 01/12/2004 Time: 11:09:05
SQLSTATE:(S1T00) Native Err:(0) stmt(26519888):*/
[Microsoft][ODBC SQL Server Driver]Timeout expired*/
/*
/* Date: 01/12/2004 Time: 11:09:05
SQLSTATE:(00000) Native Err:(0) stmt(26519888):*/
*/
/*
/* Date: 01/12/2004 Time: 11:09:05
SQLSTATE:(00000) Native Err:(0) status(55):*/
SWSTATUS DUMP*/
---
I went into SQL Query analyzer and ran the statements
interactively and they both worked.
then she re-started the Batch Calculation and everything
ran fine.
Does anyone know why we got this errors?
Thanks in advance-Rob|||Hi Rob,
My name is Michael and I would like to thank you for using Microsoft
newsgroup.
Before we go any further, I would like to collect more information from you:
1. Can you please tell me how you run this batch? Do you run it in an ADO
application?
2. What is the connection string? Which provider you use to connect to SQL
Server?
3. When does the timeout error occur? Are you sure that the timeout error
occurred when your customer performed the batch?
In the following situations I agree with Vyas:
1. If you ran the batch in an ADO application
2. If the timeout error occurred, when your customer was running the batch
but not when they were connected to SQL Serer.
3. If the batch works fine using Query Analyzer.
As we know, there are two kinds of timeout in ADO: connection timeout and
query timeout. The default connectiontimeout is 15 seconds. The default
commandtimeout is 30 seconds. If the system is overloaded, the default
value may be too small, please increase these value to see if the problem
still occur.
con.connectiontimeout=150
con.commandtimeout=300
Also, the root solution is that you can improve the query performance to
decrease the execution time.
Thanks for using Microsoft newsgroup.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.|||Hi Michael,
I dont know how to increase the timeout?
where is the following settings?
con.connectiontimeout=150
con.commandtimeout=300
Thanks-Rob
>--Original Message--
>Hi Rob,
>My name is Michael and I would like to thank you for
using Microsoft
>newsgroup.
>Before we go any further, I would like to collect more
information from you:
>1. Can you please tell me how you run this batch? Do you
run it in an ADO
>application?
>2. What is the connection string? Which provider you use
to connect to SQL
>Server?
>3. When does the timeout error occur? Are you sure that
the timeout error
>occurred when your customer performed the batch?
>In the following situations I agree with Vyas:
>1. If you ran the batch in an ADO application
>2. If the timeout error occurred, when your customer was
running the batch
>but not when they were connected to SQL Serer.
>3. If the batch works fine using Query Analyzer.
>As we know, there are two kinds of timeout in ADO:
connection timeout and
>query timeout. The default connectiontimeout is 15
seconds. The default
>commandtimeout is 30 seconds. If the system is
overloaded, the default
>value may be too small, please increase these value to
see if the problem
>still occur.
>con.connectiontimeout=150
>con.commandtimeout=300
>Also, the root solution is that you can improve the query
performance to
>decrease the execution time.
>Thanks for using Microsoft newsgroup.
>Regards,
>Michael Shao
>Microsoft Online Partner Support
>Get Secure! - www.microsoft.com/security
>This posting is provided "as is" with no warranties and
confers no rights.
>.
>|||Hi Rob,
Thanks for your feedback. CommandTimeout Property in ADO indicates how long
to wait while executing a command before terminating the attempt and
generating an error.
CommandTimeout Property
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/
mdapro02_5.asp
Thanks for using Microsoft newsgroup.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
error message!
Today a user just called me and said she got an SQL error
message when she tried to run a batch.
I changed the dex.ini file (found in the application root)
to log error messages.
Change the following statements from FALSE to TRUE.
SQLLogSQLStmt=TRUE
SQLLogODBCMessages=TRUE
SQLLogAllODBCMessages=TRUE
and a file called dexsql.log is created in the same
directory.
The errors that appeared in the log file where:
/* Date: 01/12/2004 Time: 11:07:45
stmt(26501640):*/
DELETE payrolldb.dbo.CPY30160
SELECT COUNT(*) FROM payrolldb.dbo.CPY30160
/*
/* Date: 01/12/2004 Time: 11:08:28
SQLSTATE
S1T00) Native Err0) stmt(26501640):*/
[Microsoft][ODBC SQL Server Driver]Timeout expired*/
/*
/* Date: 01/12/2004 Time: 11:08:28
SQLSTATE00000) Native Err0) stmt(26501640):*/
*/
/*
/* Date: 01/12/2004 Time: 11:08:28
SQLSTATE00000) Native Err0) status(55):*/
SWSTATUS DUMP*/
/*
--
/* Date: 01/12/2004 Time: 11:08:34
stmt(26519888):*/
DELETE payrolldb.dbo.CPY30161
SELECT COUNT(*) FROM payrolldb.dbo.CPY30161
/*
/* Date: 01/12/2004 Time: 11:09:05
SQLSTATES1T00) Native Err0) stmt(26519888):*/
[Microsoft][ODBC SQL Server Driver]Timeout expired*/
/*
/* Date: 01/12/2004 Time: 11:09:05
SQLSTATE00000) Native Err0) stmt(26519888):*/
*/
/*
/* Date: 01/12/2004 Time: 11:09:05
SQLSTATE00000) Native Err0) status(55):*/
SWSTATUS DUMP*/
---
I went into SQL Query analyzer and ran the statements
interactively and they both worked.
then she re-started the Batch Calculation and everything
ran fine.
Does anyone know why we got this errors?
Thanks in advance-RobYou are seeing a timeout error. You can find some general info on this at:
http://vyaskn.tripod.com/sql_odbc_timeout_expired.htm
http://vyaskn.tripod.com/watch_your_timeouts.htm
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Rob" <rob@.nul.ca> wrote in message
news:012301c3d93a$f2ebb510$a401280a@.phx.gbl...
Today a user just called me and said she got an SQL error
message when she tried to run a batch.
I changed the dex.ini file (found in the application root)
to log error messages.
Change the following statements from FALSE to TRUE.
SQLLogSQLStmt=TRUE
SQLLogODBCMessages=TRUE
SQLLogAllODBCMessages=TRUE
and a file called dexsql.log is created in the same
directory.
The errors that appeared in the log file where:
/* Date: 01/12/2004 Time: 11:07:45
stmt(26501640):*/
DELETE payrolldb.dbo.CPY30160
SELECT COUNT(*) FROM payrolldb.dbo.CPY30160
/*
/* Date: 01/12/2004 Time: 11:08:28
SQLSTATES1T00) Native Err0) stmt(26501640):*/
[Microsoft][ODBC SQL Server Driver]Timeout expired*/
/*
/* Date: 01/12/2004 Time: 11:08:28
SQLSTATE00000) Native Err0) stmt(26501640):*/
*/
/*
/* Date: 01/12/2004 Time: 11:08:28
SQLSTATE00000) Native Err0) status(55):*/
SWSTATUS DUMP*/
/*
--
/* Date: 01/12/2004 Time: 11:08:34
stmt(26519888):*/
DELETE payrolldb.dbo.CPY30161
SELECT COUNT(*) FROM payrolldb.dbo.CPY30161
/*
/* Date: 01/12/2004 Time: 11:09:05
SQLSTATES1T00) Native Err0) stmt(26519888):*/
[Microsoft][ODBC SQL Server Driver]Timeout expired*/
/*
/* Date: 01/12/2004 Time: 11:09:05
SQLSTATE00000) Native Err0) stmt(26519888):*/
*/
/*
/* Date: 01/12/2004 Time: 11:09:05
SQLSTATE00000) Native Err0) status(55):*/
SWSTATUS DUMP*/
---
I went into SQL Query analyzer and ran the statements
interactively and they both worked.
then she re-started the Batch Calculation and everything
ran fine.
Does anyone know why we got this errors?
Thanks in advance-Rob|||Hi Rob,
My name is Michael and I would like to thank you for using Microsoft
newsgroup.
Before we go any further, I would like to collect more information from you:
1. Can you please tell me how you run this batch? Do you run it in an ADO
application?
2. What is the connection string? Which provider you use to connect to SQL
Server?
3. When does the timeout error occur? Are you sure that the timeout error
occurred when your customer performed the batch?
In the following situations I agree with Vyas:
1. If you ran the batch in an ADO application
2. If the timeout error occurred, when your customer was running the batch
but not when they were connected to SQL Serer.
3. If the batch works fine using Query Analyzer.
As we know, there are two kinds of timeout in ADO: connection timeout and
query timeout. The default connectiontimeout is 15 seconds. The default
commandtimeout is 30 seconds. If the system is overloaded, the default
value may be too small, please increase these value to see if the problem
still occur.
con.connectiontimeout=150
con.commandtimeout=300
Also, the root solution is that you can improve the query performance to
decrease the execution time.
Thanks for using Microsoft newsgroup.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.|||Hi Michael,
I dont know how to increase the timeout?
where is the following settings?
con.connectiontimeout=150
con.commandtimeout=300
Thanks-Rob
using Microsoft
information from you:
run it in an ADO
to connect to SQL
the timeout error
running the batch
connection timeout and
seconds. The default
overloaded, the default
see if the problem
performance to
confers no rights.
Thanks for your feedback. CommandTimeout Property in ADO indicates how long
to wait while executing a command before terminating the attempt and
generating an error.
CommandTimeout Property
http://msdn.microsoft.com/library/d...-us/ado270/htm/
mdapro02_5.asp
Thanks for using Microsoft newsgroup.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
message when she tried to run a batch.
I changed the dex.ini file (found in the application root)
to log error messages.
Change the following statements from FALSE to TRUE.
SQLLogSQLStmt=TRUE
SQLLogODBCMessages=TRUE
SQLLogAllODBCMessages=TRUE
and a file called dexsql.log is created in the same
directory.
The errors that appeared in the log file where:
/* Date: 01/12/2004 Time: 11:07:45
stmt(26501640):*/
DELETE payrolldb.dbo.CPY30160
SELECT COUNT(*) FROM payrolldb.dbo.CPY30160
/*
/* Date: 01/12/2004 Time: 11:08:28
SQLSTATE
S1T00) Native Err0) stmt(26501640):*/[Microsoft][ODBC SQL Server Driver]Timeout expired*/
/*
/* Date: 01/12/2004 Time: 11:08:28
SQLSTATE
00000) Native Err0) stmt(26501640):*/*/
/*
/* Date: 01/12/2004 Time: 11:08:28
SQLSTATE
00000) Native Err0) status(55):*/SWSTATUS DUMP*/
/*
--
/* Date: 01/12/2004 Time: 11:08:34
stmt(26519888):*/
DELETE payrolldb.dbo.CPY30161
SELECT COUNT(*) FROM payrolldb.dbo.CPY30161
/*
/* Date: 01/12/2004 Time: 11:09:05
SQLSTATE
S1T00) Native Err0) stmt(26519888):*/[Microsoft][ODBC SQL Server Driver]Timeout expired*/
/*
/* Date: 01/12/2004 Time: 11:09:05
SQLSTATE
00000) Native Err0) stmt(26519888):*/*/
/*
/* Date: 01/12/2004 Time: 11:09:05
SQLSTATE
00000) Native Err0) status(55):*/SWSTATUS DUMP*/
---
I went into SQL Query analyzer and ran the statements
interactively and they both worked.
then she re-started the Batch Calculation and everything
ran fine.
Does anyone know why we got this errors?
Thanks in advance-RobYou are seeing a timeout error. You can find some general info on this at:
http://vyaskn.tripod.com/sql_odbc_timeout_expired.htm
http://vyaskn.tripod.com/watch_your_timeouts.htm
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Rob" <rob@.nul.ca> wrote in message
news:012301c3d93a$f2ebb510$a401280a@.phx.gbl...
Today a user just called me and said she got an SQL error
message when she tried to run a batch.
I changed the dex.ini file (found in the application root)
to log error messages.
Change the following statements from FALSE to TRUE.
SQLLogSQLStmt=TRUE
SQLLogODBCMessages=TRUE
SQLLogAllODBCMessages=TRUE
and a file called dexsql.log is created in the same
directory.
The errors that appeared in the log file where:
/* Date: 01/12/2004 Time: 11:07:45
stmt(26501640):*/
DELETE payrolldb.dbo.CPY30160
SELECT COUNT(*) FROM payrolldb.dbo.CPY30160
/*
/* Date: 01/12/2004 Time: 11:08:28
SQLSTATE
S1T00) Native Err0) stmt(26501640):*/[Microsoft][ODBC SQL Server Driver]Timeout expired*/
/*
/* Date: 01/12/2004 Time: 11:08:28
SQLSTATE
00000) Native Err0) stmt(26501640):*/*/
/*
/* Date: 01/12/2004 Time: 11:08:28
SQLSTATE
00000) Native Err0) status(55):*/SWSTATUS DUMP*/
/*
--
/* Date: 01/12/2004 Time: 11:08:34
stmt(26519888):*/
DELETE payrolldb.dbo.CPY30161
SELECT COUNT(*) FROM payrolldb.dbo.CPY30161
/*
/* Date: 01/12/2004 Time: 11:09:05
SQLSTATE
S1T00) Native Err0) stmt(26519888):*/[Microsoft][ODBC SQL Server Driver]Timeout expired*/
/*
/* Date: 01/12/2004 Time: 11:09:05
SQLSTATE
00000) Native Err0) stmt(26519888):*/*/
/*
/* Date: 01/12/2004 Time: 11:09:05
SQLSTATE
00000) Native Err0) status(55):*/SWSTATUS DUMP*/
---
I went into SQL Query analyzer and ran the statements
interactively and they both worked.
then she re-started the Batch Calculation and everything
ran fine.
Does anyone know why we got this errors?
Thanks in advance-Rob|||Hi Rob,
My name is Michael and I would like to thank you for using Microsoft
newsgroup.
Before we go any further, I would like to collect more information from you:
1. Can you please tell me how you run this batch? Do you run it in an ADO
application?
2. What is the connection string? Which provider you use to connect to SQL
Server?
3. When does the timeout error occur? Are you sure that the timeout error
occurred when your customer performed the batch?
In the following situations I agree with Vyas:
1. If you ran the batch in an ADO application
2. If the timeout error occurred, when your customer was running the batch
but not when they were connected to SQL Serer.
3. If the batch works fine using Query Analyzer.
As we know, there are two kinds of timeout in ADO: connection timeout and
query timeout. The default connectiontimeout is 15 seconds. The default
commandtimeout is 30 seconds. If the system is overloaded, the default
value may be too small, please increase these value to see if the problem
still occur.
con.connectiontimeout=150
con.commandtimeout=300
Also, the root solution is that you can improve the query performance to
decrease the execution time.
Thanks for using Microsoft newsgroup.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.|||Hi Michael,
I dont know how to increase the timeout?
where is the following settings?
con.connectiontimeout=150
con.commandtimeout=300
Thanks-Rob
quote:
>--Original Message--
>Hi Rob,
>My name is Michael and I would like to thank you for
using Microsoft
quote:
>newsgroup.
>Before we go any further, I would like to collect more
information from you:
quote:
>1. Can you please tell me how you run this batch? Do you
run it in an ADO
quote:
>application?
>2. What is the connection string? Which provider you use
to connect to SQL
quote:
>Server?
>3. When does the timeout error occur? Are you sure that
the timeout error
quote:
>occurred when your customer performed the batch?
>In the following situations I agree with Vyas:
>1. If you ran the batch in an ADO application
>2. If the timeout error occurred, when your customer was
running the batch
quote:
>but not when they were connected to SQL Serer.
>3. If the batch works fine using Query Analyzer.
>As we know, there are two kinds of timeout in ADO:
connection timeout and
quote:
>query timeout. The default connectiontimeout is 15
seconds. The default
quote:
>commandtimeout is 30 seconds. If the system is
overloaded, the default
quote:
>value may be too small, please increase these value to
see if the problem
quote:
>still occur.
>con.connectiontimeout=150
>con.commandtimeout=300
>Also, the root solution is that you can improve the query
performance to
quote:
>decrease the execution time.
>Thanks for using Microsoft newsgroup.
>Regards,
>Michael Shao
>Microsoft Online Partner Support
>Get Secure! - www.microsoft.com/security
>This posting is provided "as is" with no warranties and
confers no rights.
quote:|||Hi Rob,
>.
>
Thanks for your feedback. CommandTimeout Property in ADO indicates how long
to wait while executing a command before terminating the attempt and
generating an error.
CommandTimeout Property
http://msdn.microsoft.com/library/d...-us/ado270/htm/
mdapro02_5.asp
Thanks for using Microsoft newsgroup.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Error message with stored procedure
This error message appears when you try to call a stored procedure and
supply more parameters than those declared for that procedure. Look at the
code where you call the UpdateResources procedure and check that you pass
the correct parameter list.
okay Thanks will try that.
supply more parameters than those declared for that procedure. Look at the
code where you call the UpdateResources procedure and check that you pass
the correct parameter list.
HTH,
Plamen Ratchev
http://www.SQLStudio.comI see only the definition for the update parameters, not the actual data
binding. Look at the asp:BoundField tags and make sure the DataField values
are correct and there is no duplication of names. Data bound fields
automatically are added to a collection that gets submitted as parameters.
See more details here:
http://msdn2.microsoft.com/en-us/library/ms228051.aspx
Also, make sure that ConflictDetection (a property of the data source) is
not set to CompareAllValues (it is set to OverwriteChanges by default). If
you have it set to CompareAllValues then two sets of parameters are passed,
one for the updated and one for the original values.
HTH,
Plamen Ratchev
http://www.SQLStudio.com|||Forgot to say - a good way to troubleshoot something like this is to use SQL
Profiler to see what SQL statements actually get submitted.
Plamen Ratchev
http://www.SQLStudio.com|||On Oct 29, 4:19 pm, "Plamen Ratchev" <Pla...@.SQLStudio.comwrote:
Quote:
Originally Posted by
Forgot to say - a good way to troubleshoot something like this is to use SQL
Profiler to see what SQL statements actually get submitted.
>
Plamen Ratchevhttp://www.SQLStudio.com
okay Thanks will try that.
Error Message with seemingly no effect!
Below is 2 lines from my error log.
These 2 lines occure every now and then. There seem to be no system in the
occurence and it doesnt seem to have any effect on the server what so ever.
But if someone knew why and what to do in order to get rid of them?
- 2004-08-05 09:30:51.01 spid84 Error: 15457, Severity: 0, State: 1
- 2004-08-05 09:30:51.01 spid84 Configuration option 'show advanced
options' changed from 1 to 1. Run the RECONFIGURE statement to install..
Thanks.
Regards
Jonas
Possibly someone right-clicking the server in EM and select properties. A lot of option in that dialog are
sp_configure parameters.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jonas Larsen" <Jonas.Larsen@.Alcan.com> wrote in message news:eLKtg6neEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Below is 2 lines from my error log.
> These 2 lines occure every now and then. There seem to be no system in the
> occurence and it doesnt seem to have any effect on the server what so ever.
> But if someone knew why and what to do in order to get rid of them?
> - 2004-08-05 09:30:51.01 spid84 Error: 15457, Severity: 0, State: 1
> - 2004-08-05 09:30:51.01 spid84 Configuration option 'show advanced
> options' changed from 1 to 1. Run the RECONFIGURE statement to install..
> Thanks.
> Regards
> Jonas
>
These 2 lines occure every now and then. There seem to be no system in the
occurence and it doesnt seem to have any effect on the server what so ever.
But if someone knew why and what to do in order to get rid of them?
- 2004-08-05 09:30:51.01 spid84 Error: 15457, Severity: 0, State: 1
- 2004-08-05 09:30:51.01 spid84 Configuration option 'show advanced
options' changed from 1 to 1. Run the RECONFIGURE statement to install..
Thanks.
Regards
Jonas
Possibly someone right-clicking the server in EM and select properties. A lot of option in that dialog are
sp_configure parameters.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jonas Larsen" <Jonas.Larsen@.Alcan.com> wrote in message news:eLKtg6neEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Below is 2 lines from my error log.
> These 2 lines occure every now and then. There seem to be no system in the
> occurence and it doesnt seem to have any effect on the server what so ever.
> But if someone knew why and what to do in order to get rid of them?
> - 2004-08-05 09:30:51.01 spid84 Error: 15457, Severity: 0, State: 1
> - 2004-08-05 09:30:51.01 spid84 Configuration option 'show advanced
> options' changed from 1 to 1. Run the RECONFIGURE statement to install..
> Thanks.
> Regards
> Jonas
>
Error Message with seemingly no effect!
Below is 2 lines from my error log.
These 2 lines occure every now and then. There seem to be no system in the
occurence and it doesnt seem to have any effect on the server what so ever.
But if someone knew why and what to do in order to get rid of them?
- 2004-08-05 09:30:51.01 spid84 Error: 15457, Severity: 0, State: 1
- 2004-08-05 09:30:51.01 spid84 Configuration option 'show advanced
options' changed from 1 to 1. Run the RECONFIGURE statement to install..
Thanks.
Regards
JonasPossibly someone right-clicking the server in EM and select properties. A lo
t of option in that dialog are
sp_configure parameters.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jonas Larsen" <Jonas.Larsen@.Alcan.com> wrote in message news:eLKtg6neEHA.1656@.TK2MSFTNGP09.
phx.gbl...
> Below is 2 lines from my error log.
> These 2 lines occure every now and then. There seem to be no system in the
> occurence and it doesnt seem to have any effect on the server what so ever
.
> But if someone knew why and what to do in order to get rid of them?
> - 2004-08-05 09:30:51.01 spid84 Error: 15457, Severity: 0, State: 1
> - 2004-08-05 09:30:51.01 spid84 Configuration option 'show advanced
> options' changed from 1 to 1. Run the RECONFIGURE statement to install..
> Thanks.
> Regards
> Jonas
>
These 2 lines occure every now and then. There seem to be no system in the
occurence and it doesnt seem to have any effect on the server what so ever.
But if someone knew why and what to do in order to get rid of them?
- 2004-08-05 09:30:51.01 spid84 Error: 15457, Severity: 0, State: 1
- 2004-08-05 09:30:51.01 spid84 Configuration option 'show advanced
options' changed from 1 to 1. Run the RECONFIGURE statement to install..
Thanks.
Regards
JonasPossibly someone right-clicking the server in EM and select properties. A lo
t of option in that dialog are
sp_configure parameters.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jonas Larsen" <Jonas.Larsen@.Alcan.com> wrote in message news:eLKtg6neEHA.1656@.TK2MSFTNGP09.
phx.gbl...
> Below is 2 lines from my error log.
> These 2 lines occure every now and then. There seem to be no system in the
> occurence and it doesnt seem to have any effect on the server what so ever
.
> But if someone knew why and what to do in order to get rid of them?
> - 2004-08-05 09:30:51.01 spid84 Error: 15457, Severity: 0, State: 1
> - 2004-08-05 09:30:51.01 spid84 Configuration option 'show advanced
> options' changed from 1 to 1. Run the RECONFIGURE statement to install..
> Thanks.
> Regards
> Jonas
>
Error Message with seemingly no effect!
Below is 2 lines from my error log.
These 2 lines occure every now and then. There seem to be no system in the
occurence and it doesnt seem to have any effect on the server what so ever.
But if someone knew why and what to do in order to get rid of them?
- 2004-08-05 09:30:51.01 spid84 Error: 15457, Severity: 0, State: 1
- 2004-08-05 09:30:51.01 spid84 Configuration option 'show advanced
options' changed from 1 to 1. Run the RECONFIGURE statement to install..
Thanks.
Regards
JonasPossibly someone right-clicking the server in EM and select properties. A lot of option in that dialog are
sp_configure parameters.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jonas Larsen" <Jonas.Larsen@.Alcan.com> wrote in message news:eLKtg6neEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Below is 2 lines from my error log.
> These 2 lines occure every now and then. There seem to be no system in the
> occurence and it doesnt seem to have any effect on the server what so ever.
> But if someone knew why and what to do in order to get rid of them?
> - 2004-08-05 09:30:51.01 spid84 Error: 15457, Severity: 0, State: 1
> - 2004-08-05 09:30:51.01 spid84 Configuration option 'show advanced
> options' changed from 1 to 1. Run the RECONFIGURE statement to install..
> Thanks.
> Regards
> Jonas
>
These 2 lines occure every now and then. There seem to be no system in the
occurence and it doesnt seem to have any effect on the server what so ever.
But if someone knew why and what to do in order to get rid of them?
- 2004-08-05 09:30:51.01 spid84 Error: 15457, Severity: 0, State: 1
- 2004-08-05 09:30:51.01 spid84 Configuration option 'show advanced
options' changed from 1 to 1. Run the RECONFIGURE statement to install..
Thanks.
Regards
JonasPossibly someone right-clicking the server in EM and select properties. A lot of option in that dialog are
sp_configure parameters.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jonas Larsen" <Jonas.Larsen@.Alcan.com> wrote in message news:eLKtg6neEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Below is 2 lines from my error log.
> These 2 lines occure every now and then. There seem to be no system in the
> occurence and it doesnt seem to have any effect on the server what so ever.
> But if someone knew why and what to do in order to get rid of them?
> - 2004-08-05 09:30:51.01 spid84 Error: 15457, Severity: 0, State: 1
> - 2004-08-05 09:30:51.01 spid84 Configuration option 'show advanced
> options' changed from 1 to 1. Run the RECONFIGURE statement to install..
> Thanks.
> Regards
> Jonas
>
Error Message with Recordset.Update
Hi,
I am converting a VB6 application to C# using ADO. I have the following code:
private ADODB.Connection cn = new ADODB.Connection();
private ADODB.Recordset rs = new ADODB.Recordset();
private connectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data source= " + stdDir;
strClientSQL = "SELECT * FROM Client ORDER BY casename, renldate, product, fundingcode";
cn.CursorLocation = ADODB.CursorLocationEnum.adUseClient;
cn.Open(Utilities.connectionString,null,null,0);
rs.CursorLocation = ADODB.CursorLocationEnum.adUseServer;
rs.Open(strClientSQL,cn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic,-1);
rs.Fields["CaseNo"].Value = this.txtCaseNumber.Text;
rs.Update();
When I try to compile and run it I get the following error message:
"No overload for method 'Update' takes '0' arguments"
I am not sure if I need to enter information in the update command or do something else. This seems pretty straight forward but I can't figure out how to do it. Can someone please help me?
Thanks,
Mark
The thing is that you have to place the fieldas and its values in the function, like this:rsMsg.Update("Field1,Field2,Field3", "Value1,Value2,Value3");
But i supossed that you want to update the whole recordset, am i rigth?
That's a good question.... give me some time to answer that.
Hugo|||try without the parenthesis
rs.Update
Error Message with Recordset.Update
Hi,
I am converting a VB6 application to C# using ADO. I have the following code:
private ADODB.Connection cn = new ADODB.Connection();
private ADODB.Recordset rs = new ADODB.Recordset();
private connectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data source= " + stdDir;
strClientSQL = "SELECT * FROM Client ORDER BY casename, renldate, product, fundingcode";
cn.CursorLocation = ADODB.CursorLocationEnum.adUseClient;
cn.Open(Utilities.connectionString,null,null,0);
rs.CursorLocation = ADODB.CursorLocationEnum.adUseServer;
rs.Open(strClientSQL,cn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic,-1);
rs.Fields["CaseNo"].Value = this.txtCaseNumber.Text;
rs.Update();
When I try to compile and run it I get the following error message:
"No overload for method 'Update' takes '0' arguments"
I am not sure if I need to enter information in the update command or do something else. This seems pretty straight forward but I can't figure out how to do it. Can someone please help me?
Thanks,
Mark
The thing is that you have to place the fieldas and its values in the function, like this:rsMsg.Update("Field1,Field2,Field3", "Value1,Value2,Value3");
But i supossed that you want to update the whole recordset, am i rigth?
That's a good question.... give me some time to answer that.
Hugo|||try without the parenthesis
rs.Update
error message while retrieving table from database
well i have got a form which displays some result from the databasse, it runs fi9 in webmatrix, but when i try to run it from my main page and when i click on that button which should displays the aspx page, it gives me this error:
############################################################
Server Error in '/' Application.
------------------------
Login failed for user 'MUFADDAL\ASPNET'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'MUFADDAL\ASPNET'.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException: Login failed for user 'MUFADDAL\ASPNET'.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +472
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +36
Microsoft.Matrix.Framework.Web.UI.SqlDataSourceControl.PopulateDataSet(DataSet dataSet, String listName) +494
Microsoft.Matrix.Framework.Web.UI.SqlDataSourceControl.GetDataSource(String listName) +51
Microsoft.Matrix.Framework.Web.UI.DataBoundControl.ResolveDataSource() +95
Microsoft.Matrix.Framework.Web.UI.DataBoundControl.DataBind() +59
Microsoft.Matrix.Framework.Web.UI.MxDataGrid.DataBind() +10
Microsoft.Matrix.Framework.Web.UI.MxDataGrid.OnPreRender(EventArgs e) +62
System.Web.UI.Control.PreRenderRecursiveInternal() +62
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Page.ProcessRequestMain() +1489
------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
############################################################
i have kept no passwords in my mssql server 2000 database
can anyone help me out with this problemWeb Matrix runs as a normal application, and so runs under your user credentials. When run in IIS, you are running under different credentials (generally the user ASPNET on your machine).
Your connection string likely is using integrated securtiy (that is, you are not passing a SQL username and password). You must:
Add the 'MUFADDAL\ASPNET' user as a user in SQL Server (easy if SQL is on the same machine as the Web server, more difficult otherwise) or you could use SQL security and pass a username and password.|||i did create a user and gave him all of the permissions.
but still it is not working
error message while creating table in the database
Hi
I created database using SQL server and runs under Cassini. The creation of database is ok but I have a problem when I am creating the table in database. Whenever I execute the code to create the tables, it shows the error message like 'Server not found' or just hang there. Does anybody know why it hang while I am creating the table? Is it because of the code or it's the time out error. Pls help as I am very new to this area.
MZAre you tying to create tables in SQL Server (Query Analyzer or Enterprise Manager), or in Web Matrix, or in your web application code, or...? If you can clarify where you are experiencing problems we should be able to help.
Terri
Error message when using SQLCE on WM2005 - ERROR MSG: Not enough storage is available to complet
Hi All,
I got this Message from my SQLCE.
I have a loop that insert rows into the DB,
Once in a few times I get this error message on one of the rows.
But, after that the next row is insert with no problem 
Any one knows this reason?
The message is:
ERROR MSG: Not enough storage is available to complete this operation
The SQL was:
SQL Insert ERROR->
INSERT INTO OrderDetails (fileTimeStamp,orderPPCNum,storeID,itemID,itemName,quantityToPick,colorDescription,colorDetails,bases,diameter,axis,referenceNum,remarks,quantityPicked,quantityOrdered,status,datetime) VALUES('08211640','000121','0001','65700300000','-300 ????? ??????','1','','','','','0','143145','','','',0,getdate())
ERROR MSG: Not enough storage is available to complete this operation.
This error means: An out of memory condition occurred.
|||Thanks for your answer..
The wierd thing is that I continue to insert many rows into the DB with no problem.
Once in few days I get a problem of one row. I have no problem with the data entry since I insert it again after the problem, while running the procedure again without any change and with no error.
What else can couse that?
If I have this error, is it means that I don't have enough storage and I was assuming that all other rows on that senario were not suppose to enter the DB, but they did.
|||Another question,
If its the only reason the server send this error message, what should I do before starting to insert records into the DB?
Is there a way to clean the available storage area?
error message when using SQL Server 7 Enterprise Manager
I have a question, that I could not find a solution for by searching the web
and this news group. Hopefully someone can make sense of this error I have
been receiving for the last few months.
Anyways, when I startup the enteprise manager on a SQL server 7 database
that is running on a windows 2000 advanced server, I get the following error
message when I click on the database icon and begin the connect process to
the databases that reside on this server:
SQL server \\srv2000 is not known to be running. Are you sure you wish to
connect?
The icon that represents the databases has a red lightening bolt through it.
When I do say yes to this question, the icon still has the lightening bolt,
but I can see the databases. I can connect and see the data. The clients
that access these databases can connect with no problems. I only see the
above error message when I connect through enterprise manager. The other
tools (DTS services and Query Analyser) has not problems connecting to the
same databases either locally or over the network.
What is causing this error message to pop up and what can I do about this
problem?
Edward Letenrdre.
make sure your connecting to srv2000 and not \\srv2000 , also re-register a
sql server maybe even trying the ip address in stead.
Michael Evanchik.
www.michaelevanchik.com
"Edward Letendre" wrote:
> I have a question, that I could not find a solution for by searching the web
> and this news group. Hopefully someone can make sense of this error I have
> been receiving for the last few months.
> Anyways, when I startup the enteprise manager on a SQL server 7 database
> that is running on a windows 2000 advanced server, I get the following error
> message when I click on the database icon and begin the connect process to
> the databases that reside on this server:
> SQL server \\srv2000 is not known to be running. Are you sure you wish to
> connect?
> The icon that represents the databases has a red lightening bolt through it.
> When I do say yes to this question, the icon still has the lightening bolt,
> but I can see the databases. I can connect and see the data. The clients
> that access these databases can connect with no problems. I only see the
> above error message when I connect through enterprise manager. The other
> tools (DTS services and Query Analyser) has not problems connecting to the
> same databases either locally or over the network.
> What is causing this error message to pop up and what can I do about this
> problem?
> Edward Letenrdre.
>
and this news group. Hopefully someone can make sense of this error I have
been receiving for the last few months.
Anyways, when I startup the enteprise manager on a SQL server 7 database
that is running on a windows 2000 advanced server, I get the following error
message when I click on the database icon and begin the connect process to
the databases that reside on this server:
SQL server \\srv2000 is not known to be running. Are you sure you wish to
connect?
The icon that represents the databases has a red lightening bolt through it.
When I do say yes to this question, the icon still has the lightening bolt,
but I can see the databases. I can connect and see the data. The clients
that access these databases can connect with no problems. I only see the
above error message when I connect through enterprise manager. The other
tools (DTS services and Query Analyser) has not problems connecting to the
same databases either locally or over the network.
What is causing this error message to pop up and what can I do about this
problem?
Edward Letenrdre.
make sure your connecting to srv2000 and not \\srv2000 , also re-register a
sql server maybe even trying the ip address in stead.
Michael Evanchik.
www.michaelevanchik.com
"Edward Letendre" wrote:
> I have a question, that I could not find a solution for by searching the web
> and this news group. Hopefully someone can make sense of this error I have
> been receiving for the last few months.
> Anyways, when I startup the enteprise manager on a SQL server 7 database
> that is running on a windows 2000 advanced server, I get the following error
> message when I click on the database icon and begin the connect process to
> the databases that reside on this server:
> SQL server \\srv2000 is not known to be running. Are you sure you wish to
> connect?
> The icon that represents the databases has a red lightening bolt through it.
> When I do say yes to this question, the icon still has the lightening bolt,
> but I can see the databases. I can connect and see the data. The clients
> that access these databases can connect with no problems. I only see the
> above error message when I connect through enterprise manager. The other
> tools (DTS services and Query Analyser) has not problems connecting to the
> same databases either locally or over the network.
> What is causing this error message to pop up and what can I do about this
> problem?
> Edward Letenrdre.
>
error message when using SQL Server 7 Enterprise Manager
I have a question, that I could not find a solution for by searching the web
and this news group. Hopefully someone can make sense of this error I have
been receiving for the last few months.
Anyways, when I startup the enteprise manager on a SQL server 7 database
that is running on a Windows 2000 advanced server, I get the following error
message when I click on the database icon and begin the connect process to
the databases that reside on this server:
SQL server \\srv2000 is not known to be running. Are you sure you wish to
connect?
The icon that represents the databases has a red lightening bolt through it.
When I do say yes to this question, the icon still has the lightening bolt,
but I can see the databases. I can connect and see the data. The clients
that access these databases can connect with no problems. I only see the
above error message when I connect through enterprise manager. The other
tools (DTS services and Query Analyser) has not problems connecting to the
same databases either locally or over the network.
What is causing this error message to pop up and what can I do about this
problem?
Edward Letenrdre.make sure your connecting to srv2000 and not \\srv2000 , also re-register a
sql server maybe even trying the ip address in stead.
Michael Evanchik.
www.michaelevanchik.com
"Edward Letendre" wrote:
> I have a question, that I could not find a solution for by searching the w
eb
> and this news group. Hopefully someone can make sense of this error I hav
e
> been receiving for the last few months.
> Anyways, when I startup the enteprise manager on a SQL server 7 database
> that is running on a Windows 2000 advanced server, I get the following err
or
> message when I click on the database icon and begin the connect process to
> the databases that reside on this server:
> SQL server \\srv2000 is not known to be running. Are you sure you wish to
> connect?
> The icon that represents the databases has a red lightening bolt through i
t.
> When I do say yes to this question, the icon still has the lightening bol
t,
> but I can see the databases. I can connect and see the data. The clients
> that access these databases can connect with no problems. I only see the
> above error message when I connect through enterprise manager. The other
> tools (DTS services and Query Analyser) has not problems connecting to the
> same databases either locally or over the network.
> What is causing this error message to pop up and what can I do about this
> problem?
> Edward Letenrdre.
>
and this news group. Hopefully someone can make sense of this error I have
been receiving for the last few months.
Anyways, when I startup the enteprise manager on a SQL server 7 database
that is running on a Windows 2000 advanced server, I get the following error
message when I click on the database icon and begin the connect process to
the databases that reside on this server:
SQL server \\srv2000 is not known to be running. Are you sure you wish to
connect?
The icon that represents the databases has a red lightening bolt through it.
When I do say yes to this question, the icon still has the lightening bolt,
but I can see the databases. I can connect and see the data. The clients
that access these databases can connect with no problems. I only see the
above error message when I connect through enterprise manager. The other
tools (DTS services and Query Analyser) has not problems connecting to the
same databases either locally or over the network.
What is causing this error message to pop up and what can I do about this
problem?
Edward Letenrdre.make sure your connecting to srv2000 and not \\srv2000 , also re-register a
sql server maybe even trying the ip address in stead.
Michael Evanchik.
www.michaelevanchik.com
"Edward Letendre" wrote:
> I have a question, that I could not find a solution for by searching the w
eb
> and this news group. Hopefully someone can make sense of this error I hav
e
> been receiving for the last few months.
> Anyways, when I startup the enteprise manager on a SQL server 7 database
> that is running on a Windows 2000 advanced server, I get the following err
or
> message when I click on the database icon and begin the connect process to
> the databases that reside on this server:
> SQL server \\srv2000 is not known to be running. Are you sure you wish to
> connect?
> The icon that represents the databases has a red lightening bolt through i
t.
> When I do say yes to this question, the icon still has the lightening bol
t,
> but I can see the databases. I can connect and see the data. The clients
> that access these databases can connect with no problems. I only see the
> above error message when I connect through enterprise manager. The other
> tools (DTS services and Query Analyser) has not problems connecting to the
> same databases either locally or over the network.
> What is causing this error message to pop up and what can I do about this
> problem?
> Edward Letenrdre.
>
error message when using SQL Server 7 Enterprise Manager
I have a question, that I could not find a solution for by searching the web
and this news group. Hopefully someone can make sense of this error I have
been receiving for the last few months.
Anyways, when I startup the enteprise manager on a SQL server 7 database
that is running on a windows 2000 advanced server, I get the following error
message when I click on the database icon and begin the connect process to
the databases that reside on this server:
SQL server \\srv2000 is not known to be running. Are you sure you wish to
connect?
The icon that represents the databases has a red lightening bolt through it.
When I do say yes to this question, the icon still has the lightening bolt,
but I can see the databases. I can connect and see the data. The clients
that access these databases can connect with no problems. I only see the
above error message when I connect through enterprise manager. The other
tools (DTS services and Query Analyser) has not problems connecting to the
same databases either locally or over the network.
What is causing this error message to pop up and what can I do about this
problem?
Edward Letenrdre.make sure your connecting to srv2000 and not \\srv2000 , also re-register a
sql server maybe even trying the ip address in stead.
Michael Evanchik.
www.michaelevanchik.com
"Edward Letendre" wrote:
> I have a question, that I could not find a solution for by searching the web
> and this news group. Hopefully someone can make sense of this error I have
> been receiving for the last few months.
> Anyways, when I startup the enteprise manager on a SQL server 7 database
> that is running on a windows 2000 advanced server, I get the following error
> message when I click on the database icon and begin the connect process to
> the databases that reside on this server:
> SQL server \\srv2000 is not known to be running. Are you sure you wish to
> connect?
> The icon that represents the databases has a red lightening bolt through it.
> When I do say yes to this question, the icon still has the lightening bolt,
> but I can see the databases. I can connect and see the data. The clients
> that access these databases can connect with no problems. I only see the
> above error message when I connect through enterprise manager. The other
> tools (DTS services and Query Analyser) has not problems connecting to the
> same databases either locally or over the network.
> What is causing this error message to pop up and what can I do about this
> problem?
> Edward Letenrdre.
>
and this news group. Hopefully someone can make sense of this error I have
been receiving for the last few months.
Anyways, when I startup the enteprise manager on a SQL server 7 database
that is running on a windows 2000 advanced server, I get the following error
message when I click on the database icon and begin the connect process to
the databases that reside on this server:
SQL server \\srv2000 is not known to be running. Are you sure you wish to
connect?
The icon that represents the databases has a red lightening bolt through it.
When I do say yes to this question, the icon still has the lightening bolt,
but I can see the databases. I can connect and see the data. The clients
that access these databases can connect with no problems. I only see the
above error message when I connect through enterprise manager. The other
tools (DTS services and Query Analyser) has not problems connecting to the
same databases either locally or over the network.
What is causing this error message to pop up and what can I do about this
problem?
Edward Letenrdre.make sure your connecting to srv2000 and not \\srv2000 , also re-register a
sql server maybe even trying the ip address in stead.
Michael Evanchik.
www.michaelevanchik.com
"Edward Letendre" wrote:
> I have a question, that I could not find a solution for by searching the web
> and this news group. Hopefully someone can make sense of this error I have
> been receiving for the last few months.
> Anyways, when I startup the enteprise manager on a SQL server 7 database
> that is running on a windows 2000 advanced server, I get the following error
> message when I click on the database icon and begin the connect process to
> the databases that reside on this server:
> SQL server \\srv2000 is not known to be running. Are you sure you wish to
> connect?
> The icon that represents the databases has a red lightening bolt through it.
> When I do say yes to this question, the icon still has the lightening bolt,
> but I can see the databases. I can connect and see the data. The clients
> that access these databases can connect with no problems. I only see the
> above error message when I connect through enterprise manager. The other
> tools (DTS services and Query Analyser) has not problems connecting to the
> same databases either locally or over the network.
> What is causing this error message to pop up and what can I do about this
> problem?
> Edward Letenrdre.
>
Error message when trying to save modified maintenance plan?
I have a maintenance plan created that have been running for a few months.
Now I want to modify the plan and selected Modify on the plan and got into
an editor with the different steps. I selected "Edit" on the Backup step and
changed the name of the destination folder and clicked OK in that dialog.
When I try to save the modified maintenance plan, I only get an error dialog
with "No description found".
What is the problem?
OlavHi
I am not sure about the error, you may want to use SQL Profiler to find the
statement causing the error and try to run this manually. The quickest
solution may be to drop the maintenance plan and re-create it from scratch.
John
"Olav" wrote:
> I have a maintenance plan created that have been running for a few months.
> Now I want to modify the plan and selected Modify on the plan and got into
> an editor with the different steps. I selected "Edit" on the Backup step a
nd
> changed the name of the destination folder and clicked OK in that dialog.
> When I try to save the modified maintenance plan, I only get an error dial
og
> with "No description found".
> What is the problem?
> Olav
>
>|||I have the same problem when I try to modify a maintenance plan and then sav
e
the changes I get an error message saying "No description found" - this even
happens when I try to rename the maintenance plan. The changes are not save
d
and the maintenance plan executes ok.
I can create new plans using the wizard but not from scratch. I have
upgraded to SP1 (9.00.2047.00, SP1, Standard Edition running on Win2003 SP1)
Recreating maintenance plans each time I want to modify them is not an optio
n.
Does any one have a solution ?
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> I am not sure about the error, you may want to use SQL Profiler to find th
e
> statement causing the error and try to run this manually. The quickest
> solution may be to drop the maintenance plan and re-create it from scratch
.
> John
> "Olav" wrote:
>|||Hi
Are you seeing this error? http://tinyurl.com/mj88y
John
"Bridgepark" wrote:
[vbcol=seagreen]
> I have the same problem when I try to modify a maintenance plan and then s
ave
> the changes I get an error message saying "No description found" - this ev
en
> happens when I try to rename the maintenance plan. The changes are not sa
ved
> and the maintenance plan executes ok.
> I can create new plans using the wizard but not from scratch. I have
> upgraded to SP1 (9.00.2047.00, SP1, Standard Edition running on Win2003 SP
1)
> Recreating maintenance plans each time I want to modify them is not an opt
ion.
> Does any one have a solution ?
> "John Bell" wrote:
>|||I see the "No description found" message but I have plans without Cleanup
tasks in them. I tried creating a new plan without using the wizard and whe
n
I try and save it I get the error. If I create a plan using the Wizard its
fine (even if it has a clean up task) However if I then try and alter the
plan I get the message.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> Are you seeing this error? http://tinyurl.com/mj88y
> John
> "Bridgepark" wrote:
>|||Hi
You may have to log a call with PSS.
John
"Bridgepark" wrote:
[vbcol=seagreen]
> I see the "No description found" message but I have plans without Cleanup
> tasks in them. I tried creating a new plan without using the wizard and w
hen
> I try and save it I get the error. If I create a plan using the Wizard it
s
> fine (even if it has a clean up task) However if I then try and alter the
> plan I get the message.
> "John Bell" wrote:
>
Now I want to modify the plan and selected Modify on the plan and got into
an editor with the different steps. I selected "Edit" on the Backup step and
changed the name of the destination folder and clicked OK in that dialog.
When I try to save the modified maintenance plan, I only get an error dialog
with "No description found".
What is the problem?
OlavHi
I am not sure about the error, you may want to use SQL Profiler to find the
statement causing the error and try to run this manually. The quickest
solution may be to drop the maintenance plan and re-create it from scratch.
John
"Olav" wrote:
> I have a maintenance plan created that have been running for a few months.
> Now I want to modify the plan and selected Modify on the plan and got into
> an editor with the different steps. I selected "Edit" on the Backup step a
nd
> changed the name of the destination folder and clicked OK in that dialog.
> When I try to save the modified maintenance plan, I only get an error dial
og
> with "No description found".
> What is the problem?
> Olav
>
>|||I have the same problem when I try to modify a maintenance plan and then sav
e
the changes I get an error message saying "No description found" - this even
happens when I try to rename the maintenance plan. The changes are not save
d
and the maintenance plan executes ok.
I can create new plans using the wizard but not from scratch. I have
upgraded to SP1 (9.00.2047.00, SP1, Standard Edition running on Win2003 SP1)
Recreating maintenance plans each time I want to modify them is not an optio
n.
Does any one have a solution ?
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> I am not sure about the error, you may want to use SQL Profiler to find th
e
> statement causing the error and try to run this manually. The quickest
> solution may be to drop the maintenance plan and re-create it from scratch
.
> John
> "Olav" wrote:
>|||Hi
Are you seeing this error? http://tinyurl.com/mj88y
John
"Bridgepark" wrote:
[vbcol=seagreen]
> I have the same problem when I try to modify a maintenance plan and then s
ave
> the changes I get an error message saying "No description found" - this ev
en
> happens when I try to rename the maintenance plan. The changes are not sa
ved
> and the maintenance plan executes ok.
> I can create new plans using the wizard but not from scratch. I have
> upgraded to SP1 (9.00.2047.00, SP1, Standard Edition running on Win2003 SP
1)
> Recreating maintenance plans each time I want to modify them is not an opt
ion.
> Does any one have a solution ?
> "John Bell" wrote:
>|||I see the "No description found" message but I have plans without Cleanup
tasks in them. I tried creating a new plan without using the wizard and whe
n
I try and save it I get the error. If I create a plan using the Wizard its
fine (even if it has a clean up task) However if I then try and alter the
plan I get the message.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> Are you seeing this error? http://tinyurl.com/mj88y
> John
> "Bridgepark" wrote:
>|||Hi
You may have to log a call with PSS.
John
"Bridgepark" wrote:
[vbcol=seagreen]
> I see the "No description found" message but I have plans without Cleanup
> tasks in them. I tried creating a new plan without using the wizard and w
hen
> I try and save it I get the error. If I create a plan using the Wizard it
s
> fine (even if it has a clean up task) However if I then try and alter the
> plan I get the message.
> "John Bell" wrote:
>
Error message when trying to save modified maintenance plan?
I have a maintenance plan created that have been running for a few months.
Now I want to modify the plan and selected Modify on the plan and got into
an editor with the different steps. I selected "Edit" on the Backup step and
changed the name of the destination folder and clicked OK in that dialog.
When I try to save the modified maintenance plan, I only get an error dialog
with "No description found".
What is the problem?
OlavHi
I am not sure about the error, you may want to use SQL Profiler to find the
statement causing the error and try to run this manually. The quickest
solution may be to drop the maintenance plan and re-create it from scratch.
John
"Olav" wrote:
> I have a maintenance plan created that have been running for a few months.
> Now I want to modify the plan and selected Modify on the plan and got into
> an editor with the different steps. I selected "Edit" on the Backup step and
> changed the name of the destination folder and clicked OK in that dialog.
> When I try to save the modified maintenance plan, I only get an error dialog
> with "No description found".
> What is the problem?
> Olav
>
>|||I have the same problem when I try to modify a maintenance plan and then save
the changes I get an error message saying "No description found" - this even
happens when I try to rename the maintenance plan. The changes are not saved
and the maintenance plan executes ok.
I can create new plans using the wizard but not from scratch. I have
upgraded to SP1 (9.00.2047.00, SP1, Standard Edition running on Win2003 SP1)
Recreating maintenance plans each time I want to modify them is not an option.
Does any one have a solution ?
"John Bell" wrote:
> Hi
> I am not sure about the error, you may want to use SQL Profiler to find the
> statement causing the error and try to run this manually. The quickest
> solution may be to drop the maintenance plan and re-create it from scratch.
> John
> "Olav" wrote:
> > I have a maintenance plan created that have been running for a few months.
> >
> > Now I want to modify the plan and selected Modify on the plan and got into
> > an editor with the different steps. I selected "Edit" on the Backup step and
> > changed the name of the destination folder and clicked OK in that dialog.
> >
> > When I try to save the modified maintenance plan, I only get an error dialog
> > with "No description found".
> >
> > What is the problem?
> >
> > Olav
> >
> >
> >|||Hi
Are you seeing this error? http://tinyurl.com/mj88y
John
"Bridgepark" wrote:
> I have the same problem when I try to modify a maintenance plan and then save
> the changes I get an error message saying "No description found" - this even
> happens when I try to rename the maintenance plan. The changes are not saved
> and the maintenance plan executes ok.
> I can create new plans using the wizard but not from scratch. I have
> upgraded to SP1 (9.00.2047.00, SP1, Standard Edition running on Win2003 SP1)
> Recreating maintenance plans each time I want to modify them is not an option.
> Does any one have a solution ?
> "John Bell" wrote:
> > Hi
> >
> > I am not sure about the error, you may want to use SQL Profiler to find the
> > statement causing the error and try to run this manually. The quickest
> > solution may be to drop the maintenance plan and re-create it from scratch.
> >
> > John
> >
> > "Olav" wrote:
> >
> > > I have a maintenance plan created that have been running for a few months.
> > >
> > > Now I want to modify the plan and selected Modify on the plan and got into
> > > an editor with the different steps. I selected "Edit" on the Backup step and
> > > changed the name of the destination folder and clicked OK in that dialog.
> > >
> > > When I try to save the modified maintenance plan, I only get an error dialog
> > > with "No description found".
> > >
> > > What is the problem?
> > >
> > > Olav
> > >
> > >
> > >|||I see the "No description found" message but I have plans without Cleanup
tasks in them. I tried creating a new plan without using the wizard and when
I try and save it I get the error. If I create a plan using the Wizard its
fine (even if it has a clean up task) However if I then try and alter the
plan I get the message.
"John Bell" wrote:
> Hi
> Are you seeing this error? http://tinyurl.com/mj88y
> John
> "Bridgepark" wrote:
> > I have the same problem when I try to modify a maintenance plan and then save
> > the changes I get an error message saying "No description found" - this even
> > happens when I try to rename the maintenance plan. The changes are not saved
> > and the maintenance plan executes ok.
> > I can create new plans using the wizard but not from scratch. I have
> > upgraded to SP1 (9.00.2047.00, SP1, Standard Edition running on Win2003 SP1)
> > Recreating maintenance plans each time I want to modify them is not an option.
> >
> > Does any one have a solution ?
> >
> > "John Bell" wrote:
> >
> > > Hi
> > >
> > > I am not sure about the error, you may want to use SQL Profiler to find the
> > > statement causing the error and try to run this manually. The quickest
> > > solution may be to drop the maintenance plan and re-create it from scratch.
> > >
> > > John
> > >
> > > "Olav" wrote:
> > >
> > > > I have a maintenance plan created that have been running for a few months.
> > > >
> > > > Now I want to modify the plan and selected Modify on the plan and got into
> > > > an editor with the different steps. I selected "Edit" on the Backup step and
> > > > changed the name of the destination folder and clicked OK in that dialog.
> > > >
> > > > When I try to save the modified maintenance plan, I only get an error dialog
> > > > with "No description found".
> > > >
> > > > What is the problem?
> > > >
> > > > Olav
> > > >
> > > >
> > > >|||Hi
You may have to log a call with PSS.
John
"Bridgepark" wrote:
> I see the "No description found" message but I have plans without Cleanup
> tasks in them. I tried creating a new plan without using the wizard and when
> I try and save it I get the error. If I create a plan using the Wizard its
> fine (even if it has a clean up task) However if I then try and alter the
> plan I get the message.
> "John Bell" wrote:
> > Hi
> >
> > Are you seeing this error? http://tinyurl.com/mj88y
> >
> > John
> >
> > "Bridgepark" wrote:
> >
> > > I have the same problem when I try to modify a maintenance plan and then save
> > > the changes I get an error message saying "No description found" - this even
> > > happens when I try to rename the maintenance plan. The changes are not saved
> > > and the maintenance plan executes ok.
> > > I can create new plans using the wizard but not from scratch. I have
> > > upgraded to SP1 (9.00.2047.00, SP1, Standard Edition running on Win2003 SP1)
> > > Recreating maintenance plans each time I want to modify them is not an option.
> > >
> > > Does any one have a solution ?
> > >
> > > "John Bell" wrote:
> > >
> > > > Hi
> > > >
> > > > I am not sure about the error, you may want to use SQL Profiler to find the
> > > > statement causing the error and try to run this manually. The quickest
> > > > solution may be to drop the maintenance plan and re-create it from scratch.
> > > >
> > > > John
> > > >
> > > > "Olav" wrote:
> > > >
> > > > > I have a maintenance plan created that have been running for a few months.
> > > > >
> > > > > Now I want to modify the plan and selected Modify on the plan and got into
> > > > > an editor with the different steps. I selected "Edit" on the Backup step and
> > > > > changed the name of the destination folder and clicked OK in that dialog.
> > > > >
> > > > > When I try to save the modified maintenance plan, I only get an error dialog
> > > > > with "No description found".
> > > > >
> > > > > What is the problem?
> > > > >
> > > > > Olav
> > > > >
> > > > >
> > > > >
Now I want to modify the plan and selected Modify on the plan and got into
an editor with the different steps. I selected "Edit" on the Backup step and
changed the name of the destination folder and clicked OK in that dialog.
When I try to save the modified maintenance plan, I only get an error dialog
with "No description found".
What is the problem?
OlavHi
I am not sure about the error, you may want to use SQL Profiler to find the
statement causing the error and try to run this manually. The quickest
solution may be to drop the maintenance plan and re-create it from scratch.
John
"Olav" wrote:
> I have a maintenance plan created that have been running for a few months.
> Now I want to modify the plan and selected Modify on the plan and got into
> an editor with the different steps. I selected "Edit" on the Backup step and
> changed the name of the destination folder and clicked OK in that dialog.
> When I try to save the modified maintenance plan, I only get an error dialog
> with "No description found".
> What is the problem?
> Olav
>
>|||I have the same problem when I try to modify a maintenance plan and then save
the changes I get an error message saying "No description found" - this even
happens when I try to rename the maintenance plan. The changes are not saved
and the maintenance plan executes ok.
I can create new plans using the wizard but not from scratch. I have
upgraded to SP1 (9.00.2047.00, SP1, Standard Edition running on Win2003 SP1)
Recreating maintenance plans each time I want to modify them is not an option.
Does any one have a solution ?
"John Bell" wrote:
> Hi
> I am not sure about the error, you may want to use SQL Profiler to find the
> statement causing the error and try to run this manually. The quickest
> solution may be to drop the maintenance plan and re-create it from scratch.
> John
> "Olav" wrote:
> > I have a maintenance plan created that have been running for a few months.
> >
> > Now I want to modify the plan and selected Modify on the plan and got into
> > an editor with the different steps. I selected "Edit" on the Backup step and
> > changed the name of the destination folder and clicked OK in that dialog.
> >
> > When I try to save the modified maintenance plan, I only get an error dialog
> > with "No description found".
> >
> > What is the problem?
> >
> > Olav
> >
> >
> >|||Hi
Are you seeing this error? http://tinyurl.com/mj88y
John
"Bridgepark" wrote:
> I have the same problem when I try to modify a maintenance plan and then save
> the changes I get an error message saying "No description found" - this even
> happens when I try to rename the maintenance plan. The changes are not saved
> and the maintenance plan executes ok.
> I can create new plans using the wizard but not from scratch. I have
> upgraded to SP1 (9.00.2047.00, SP1, Standard Edition running on Win2003 SP1)
> Recreating maintenance plans each time I want to modify them is not an option.
> Does any one have a solution ?
> "John Bell" wrote:
> > Hi
> >
> > I am not sure about the error, you may want to use SQL Profiler to find the
> > statement causing the error and try to run this manually. The quickest
> > solution may be to drop the maintenance plan and re-create it from scratch.
> >
> > John
> >
> > "Olav" wrote:
> >
> > > I have a maintenance plan created that have been running for a few months.
> > >
> > > Now I want to modify the plan and selected Modify on the plan and got into
> > > an editor with the different steps. I selected "Edit" on the Backup step and
> > > changed the name of the destination folder and clicked OK in that dialog.
> > >
> > > When I try to save the modified maintenance plan, I only get an error dialog
> > > with "No description found".
> > >
> > > What is the problem?
> > >
> > > Olav
> > >
> > >
> > >|||I see the "No description found" message but I have plans without Cleanup
tasks in them. I tried creating a new plan without using the wizard and when
I try and save it I get the error. If I create a plan using the Wizard its
fine (even if it has a clean up task) However if I then try and alter the
plan I get the message.
"John Bell" wrote:
> Hi
> Are you seeing this error? http://tinyurl.com/mj88y
> John
> "Bridgepark" wrote:
> > I have the same problem when I try to modify a maintenance plan and then save
> > the changes I get an error message saying "No description found" - this even
> > happens when I try to rename the maintenance plan. The changes are not saved
> > and the maintenance plan executes ok.
> > I can create new plans using the wizard but not from scratch. I have
> > upgraded to SP1 (9.00.2047.00, SP1, Standard Edition running on Win2003 SP1)
> > Recreating maintenance plans each time I want to modify them is not an option.
> >
> > Does any one have a solution ?
> >
> > "John Bell" wrote:
> >
> > > Hi
> > >
> > > I am not sure about the error, you may want to use SQL Profiler to find the
> > > statement causing the error and try to run this manually. The quickest
> > > solution may be to drop the maintenance plan and re-create it from scratch.
> > >
> > > John
> > >
> > > "Olav" wrote:
> > >
> > > > I have a maintenance plan created that have been running for a few months.
> > > >
> > > > Now I want to modify the plan and selected Modify on the plan and got into
> > > > an editor with the different steps. I selected "Edit" on the Backup step and
> > > > changed the name of the destination folder and clicked OK in that dialog.
> > > >
> > > > When I try to save the modified maintenance plan, I only get an error dialog
> > > > with "No description found".
> > > >
> > > > What is the problem?
> > > >
> > > > Olav
> > > >
> > > >
> > > >|||Hi
You may have to log a call with PSS.
John
"Bridgepark" wrote:
> I see the "No description found" message but I have plans without Cleanup
> tasks in them. I tried creating a new plan without using the wizard and when
> I try and save it I get the error. If I create a plan using the Wizard its
> fine (even if it has a clean up task) However if I then try and alter the
> plan I get the message.
> "John Bell" wrote:
> > Hi
> >
> > Are you seeing this error? http://tinyurl.com/mj88y
> >
> > John
> >
> > "Bridgepark" wrote:
> >
> > > I have the same problem when I try to modify a maintenance plan and then save
> > > the changes I get an error message saying "No description found" - this even
> > > happens when I try to rename the maintenance plan. The changes are not saved
> > > and the maintenance plan executes ok.
> > > I can create new plans using the wizard but not from scratch. I have
> > > upgraded to SP1 (9.00.2047.00, SP1, Standard Edition running on Win2003 SP1)
> > > Recreating maintenance plans each time I want to modify them is not an option.
> > >
> > > Does any one have a solution ?
> > >
> > > "John Bell" wrote:
> > >
> > > > Hi
> > > >
> > > > I am not sure about the error, you may want to use SQL Profiler to find the
> > > > statement causing the error and try to run this manually. The quickest
> > > > solution may be to drop the maintenance plan and re-create it from scratch.
> > > >
> > > > John
> > > >
> > > > "Olav" wrote:
> > > >
> > > > > I have a maintenance plan created that have been running for a few months.
> > > > >
> > > > > Now I want to modify the plan and selected Modify on the plan and got into
> > > > > an editor with the different steps. I selected "Edit" on the Backup step and
> > > > > changed the name of the destination folder and clicked OK in that dialog.
> > > > >
> > > > > When I try to save the modified maintenance plan, I only get an error dialog
> > > > > with "No description found".
> > > > >
> > > > > What is the problem?
> > > > >
> > > > > Olav
> > > > >
> > > > >
> > > > >
Error Message when trying to open AdventureWorksDB in vbexpress
I get the following error message when trying to open the AdventureWordsDB in VBExpress: "Failed to generate a user instance of SQL Server dut to failure in starting the process for the user instance. The connection will be closed." Can someone tell me what the problem is and how to solve it? Thanks, Ray Holt
hi,
you seemed to open a database in User Instace mode.. User Instances are available in SQLExpress edition only and they have to be enabled.. at installation time of SQLExpress a kind of message asks you to enable this feature or not, but you can enable it even later executing the sp_configure system stored procedure with the 'user instances enabled' parameter..
regards
|||How do I execute the sp_configure? Thanks, Ray Holt|||hi Ray,
for your convenience, you can download and install SQL Server Management Studio Express... you can then execute it, "open a new query", and execute the sp_configure call..
regards
Error message when trying to do a maintenance plan
Hi all,
As far as I can tell I have installed all features of SQL2005 but when I try to setup a maintenance plan I am receiving this message:
TITLE: Microsoft SQL Server Management Studio
The action you attempted to perform on a remote instance of SQL Server has failed because the action requires a SQL Server component that is not installed on the remote computer. To proceed, install SQL Server 2005 Management Tools on the remote computer, and then try again. For more information, see "How to: Install SQL Server 2005 (Setup)" in SQL Server 2005 Books Online, or find the article on MSDN at http://go.microsoft.com/fwlink/?LinkID=57083 . (ObjectExplorer)
For help, click: http://go.microsoft.com/fwlink/?LinkID=57083
BUTTONS:
OK
Any ideas on why this is happening?
first of all you must apply sp2 of Mar
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=19624
There are many problems related to MP solved in this version. Check whether you have installed Integration services and the services is running
Madhu
|||First things first, have you applied any service pack after you have installed the SQL 2005 components on thsi machine?
If not try as suggested to take care of such issues with maintenance plans.
error message when trying to create any query
I am trying to run a query on my sql server and get the following error message:
"An error occurred while executing batch. Error message is: The directory name is invalid."
how do I fix?
Simple -Use a valid folder name!
If you were to post your code, and the complete error message, perhaps we could give you more directed assistance.
|||I am experiencing the same problem.There are no directories or code involved.
The error occurs in SQL server management studio on a simple sql statement like
select * from table_name;
Regards
Zlatko
|||It is resolved in meantime.
Our sysadm changed some user rights on the domain controller - and that was causing the error.
After he returned the old setting - everything went back to normal.
Z.
Error Message when starting SQL
This application has failed to start because MSVCXP71.dll was not found.
Re-installing the application may fix this problem.
I have tried reinstalling SQL and it did not resolve the problem, also
tried uninstalling but the uninstalltion did not uninstall everything.AZ,
I don't think that is a SQL Server file. And Google has nothing for that
file name. Are you sure the name is correct? Have you checked the
application event log to see if any other events/errors were reported?
HTH
Jerry
"AZ" <AZ@.discussions.microsoft.com> wrote in message
news:CF97F012-F80A-43D3-8043-91238838F685@.microsoft.com...
> This application has failed to start because MSVCXP71.dll was not found.
> Re-installing the application may fix this problem.
> I have tried reinstalling SQL and it did not resolve the problem, also
> tried uninstalling but the uninstalltion did not uninstall everything.
>|||When i try to start the sqlserveragent the first message i get is the service
did not respond to the start or control request in a timely fashion
When i click ok then i get
An error 1053 - (The service did not respond to the start or control request
in a timely fashion) occurred while performing this service operation on the
MSSQLServer service
The other message is when i open the enterprise manager and try to open the
database from there
"Jerry Spivey" wrote:
> AZ,
> I don't think that is a SQL Server file. And Google has nothing for that
> file name. Are you sure the name is correct? Have you checked the
> application event log to see if any other events/errors were reported?
> HTH
> Jerry
> "AZ" <AZ@.discussions.microsoft.com> wrote in message
> news:CF97F012-F80A-43D3-8043-91238838F685@.microsoft.com...
> > This application has failed to start because MSVCXP71.dll was not found.
> > Re-installing the application may fix this problem.
> >
> > I have tried reinstalling SQL and it did not resolve the problem, also
> > tried uninstalling but the uninstalltion did not uninstall everything.
> >
>
>|||As for event logs under application i get the following three logs
Event Type: Error
Event Source:
Event Category: Alert Engine
Event ID: 318
Date: 21/10/2005
Time: 11:44:54 AM
User: N/A
Computer:
Description:
Unable to read local eventlog (reason: The event log file has changed
between read operations).
Then
Event Type: Information
Event Source:
Event Category: Alert Engine
Event ID: 311
Date: 21/10/2005
Time: 11:44:54 AM
User: N/A
Computer: K
Description:
Attempting to to re-open the local eventlog...
and finally
Event Type: Warning
Event Source:
Event Category: Alert Engine
Event ID: 312
Date: 21/10/2005
Time: 11:44:54 AM
User: N/A
Computer:
Description:
Successfully re-opened the local eventlog - NOTE: Some events may have been
missed.
In under system event log i get the following 2 messages:
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7009
Date: 21/10/2005
Time: 11:45:00 AM
User: N/A
Computer:
Description:
Timeout (30000 milliseconds) waiting for the MSSQLSERVER service to connect.
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7000
Date: 21/10/2005
Time: 11:45:00 AM
User: N/A
Computer:
Description:
The MSSQLSERVER service failed to start due to the following error:
The service did not respond to the start or control request in a timely
fashion.
Thanks!
"Jerry Spivey" wrote:
> AZ,
> I don't think that is a SQL Server file. And Google has nothing for that
> file name. Are you sure the name is correct? Have you checked the
> application event log to see if any other events/errors were reported?
> HTH
> Jerry
> "AZ" <AZ@.discussions.microsoft.com> wrote in message
> news:CF97F012-F80A-43D3-8043-91238838F685@.microsoft.com...
> > This application has failed to start because MSVCXP71.dll was not found.
> > Re-installing the application may fix this problem.
> >
> > I have tried reinstalling SQL and it did not resolve the problem, also
> > tried uninstalling but the uninstalltion did not uninstall everything.
> >
>
>|||Ok...test box? if so let's cut to the chase and change the startup account
for the services to the local system account and see if they start then.
HTH
Jerry
"AZ" <AZ@.discussions.microsoft.com> wrote in message
news:7DD97CE8-0F33-4D46-99C1-6BEA0B7AE0C7@.microsoft.com...
> As for event logs under application i get the following three logs
> Event Type: Error
> Event Source:
> Event Category: Alert Engine
> Event ID: 318
> Date: 21/10/2005
> Time: 11:44:54 AM
> User: N/A
> Computer:
> Description:
> Unable to read local eventlog (reason: The event log file has changed
> between read operations).
> Then
> Event Type: Information
> Event Source:
> Event Category: Alert Engine
> Event ID: 311
> Date: 21/10/2005
> Time: 11:44:54 AM
> User: N/A
> Computer: K
> Description:
> Attempting to to re-open the local eventlog...
> and finally
> Event Type: Warning
> Event Source:
> Event Category: Alert Engine
> Event ID: 312
> Date: 21/10/2005
> Time: 11:44:54 AM
> User: N/A
> Computer:
> Description:
> Successfully re-opened the local eventlog - NOTE: Some events may have
> been
> missed.
>
> In under system event log i get the following 2 messages:
> Event Type: Error
> Event Source: Service Control Manager
> Event Category: None
> Event ID: 7009
> Date: 21/10/2005
> Time: 11:45:00 AM
> User: N/A
> Computer:
> Description:
> Timeout (30000 milliseconds) waiting for the MSSQLSERVER service to
> connect.
> Event Type: Error
> Event Source: Service Control Manager
> Event Category: None
> Event ID: 7000
> Date: 21/10/2005
> Time: 11:45:00 AM
> User: N/A
> Computer:
> Description:
> The MSSQLSERVER service failed to start due to the following error:
> The service did not respond to the start or control request in a timely
> fashion.
> Thanks!
> "Jerry Spivey" wrote:
>> AZ,
>> I don't think that is a SQL Server file. And Google has nothing for that
>> file name. Are you sure the name is correct? Have you checked the
>> application event log to see if any other events/errors were reported?
>> HTH
>> Jerry
>> "AZ" <AZ@.discussions.microsoft.com> wrote in message
>> news:CF97F012-F80A-43D3-8043-91238838F685@.microsoft.com...
>> > This application has failed to start because MSVCXP71.dll was not
>> > found.
>> > Re-installing the application may fix this problem.
>> >
>> > I have tried reinstalling SQL and it did not resolve the problem, also
>> > tried uninstalling but the uninstalltion did not uninstall everything.
>> >
>>
Re-installing the application may fix this problem.
I have tried reinstalling SQL and it did not resolve the problem, also
tried uninstalling but the uninstalltion did not uninstall everything.AZ,
I don't think that is a SQL Server file. And Google has nothing for that
file name. Are you sure the name is correct? Have you checked the
application event log to see if any other events/errors were reported?
HTH
Jerry
"AZ" <AZ@.discussions.microsoft.com> wrote in message
news:CF97F012-F80A-43D3-8043-91238838F685@.microsoft.com...
> This application has failed to start because MSVCXP71.dll was not found.
> Re-installing the application may fix this problem.
> I have tried reinstalling SQL and it did not resolve the problem, also
> tried uninstalling but the uninstalltion did not uninstall everything.
>|||When i try to start the sqlserveragent the first message i get is the service
did not respond to the start or control request in a timely fashion
When i click ok then i get
An error 1053 - (The service did not respond to the start or control request
in a timely fashion) occurred while performing this service operation on the
MSSQLServer service
The other message is when i open the enterprise manager and try to open the
database from there
"Jerry Spivey" wrote:
> AZ,
> I don't think that is a SQL Server file. And Google has nothing for that
> file name. Are you sure the name is correct? Have you checked the
> application event log to see if any other events/errors were reported?
> HTH
> Jerry
> "AZ" <AZ@.discussions.microsoft.com> wrote in message
> news:CF97F012-F80A-43D3-8043-91238838F685@.microsoft.com...
> > This application has failed to start because MSVCXP71.dll was not found.
> > Re-installing the application may fix this problem.
> >
> > I have tried reinstalling SQL and it did not resolve the problem, also
> > tried uninstalling but the uninstalltion did not uninstall everything.
> >
>
>|||As for event logs under application i get the following three logs
Event Type: Error
Event Source:
Event Category: Alert Engine
Event ID: 318
Date: 21/10/2005
Time: 11:44:54 AM
User: N/A
Computer:
Description:
Unable to read local eventlog (reason: The event log file has changed
between read operations).
Then
Event Type: Information
Event Source:
Event Category: Alert Engine
Event ID: 311
Date: 21/10/2005
Time: 11:44:54 AM
User: N/A
Computer: K
Description:
Attempting to to re-open the local eventlog...
and finally
Event Type: Warning
Event Source:
Event Category: Alert Engine
Event ID: 312
Date: 21/10/2005
Time: 11:44:54 AM
User: N/A
Computer:
Description:
Successfully re-opened the local eventlog - NOTE: Some events may have been
missed.
In under system event log i get the following 2 messages:
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7009
Date: 21/10/2005
Time: 11:45:00 AM
User: N/A
Computer:
Description:
Timeout (30000 milliseconds) waiting for the MSSQLSERVER service to connect.
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7000
Date: 21/10/2005
Time: 11:45:00 AM
User: N/A
Computer:
Description:
The MSSQLSERVER service failed to start due to the following error:
The service did not respond to the start or control request in a timely
fashion.
Thanks!
"Jerry Spivey" wrote:
> AZ,
> I don't think that is a SQL Server file. And Google has nothing for that
> file name. Are you sure the name is correct? Have you checked the
> application event log to see if any other events/errors were reported?
> HTH
> Jerry
> "AZ" <AZ@.discussions.microsoft.com> wrote in message
> news:CF97F012-F80A-43D3-8043-91238838F685@.microsoft.com...
> > This application has failed to start because MSVCXP71.dll was not found.
> > Re-installing the application may fix this problem.
> >
> > I have tried reinstalling SQL and it did not resolve the problem, also
> > tried uninstalling but the uninstalltion did not uninstall everything.
> >
>
>|||Ok...test box? if so let's cut to the chase and change the startup account
for the services to the local system account and see if they start then.
HTH
Jerry
"AZ" <AZ@.discussions.microsoft.com> wrote in message
news:7DD97CE8-0F33-4D46-99C1-6BEA0B7AE0C7@.microsoft.com...
> As for event logs under application i get the following three logs
> Event Type: Error
> Event Source:
> Event Category: Alert Engine
> Event ID: 318
> Date: 21/10/2005
> Time: 11:44:54 AM
> User: N/A
> Computer:
> Description:
> Unable to read local eventlog (reason: The event log file has changed
> between read operations).
> Then
> Event Type: Information
> Event Source:
> Event Category: Alert Engine
> Event ID: 311
> Date: 21/10/2005
> Time: 11:44:54 AM
> User: N/A
> Computer: K
> Description:
> Attempting to to re-open the local eventlog...
> and finally
> Event Type: Warning
> Event Source:
> Event Category: Alert Engine
> Event ID: 312
> Date: 21/10/2005
> Time: 11:44:54 AM
> User: N/A
> Computer:
> Description:
> Successfully re-opened the local eventlog - NOTE: Some events may have
> been
> missed.
>
> In under system event log i get the following 2 messages:
> Event Type: Error
> Event Source: Service Control Manager
> Event Category: None
> Event ID: 7009
> Date: 21/10/2005
> Time: 11:45:00 AM
> User: N/A
> Computer:
> Description:
> Timeout (30000 milliseconds) waiting for the MSSQLSERVER service to
> connect.
> Event Type: Error
> Event Source: Service Control Manager
> Event Category: None
> Event ID: 7000
> Date: 21/10/2005
> Time: 11:45:00 AM
> User: N/A
> Computer:
> Description:
> The MSSQLSERVER service failed to start due to the following error:
> The service did not respond to the start or control request in a timely
> fashion.
> Thanks!
> "Jerry Spivey" wrote:
>> AZ,
>> I don't think that is a SQL Server file. And Google has nothing for that
>> file name. Are you sure the name is correct? Have you checked the
>> application event log to see if any other events/errors were reported?
>> HTH
>> Jerry
>> "AZ" <AZ@.discussions.microsoft.com> wrote in message
>> news:CF97F012-F80A-43D3-8043-91238838F685@.microsoft.com...
>> > This application has failed to start because MSVCXP71.dll was not
>> > found.
>> > Re-installing the application may fix this problem.
>> >
>> > I have tried reinstalling SQL and it did not resolve the problem, also
>> > tried uninstalling but the uninstalltion did not uninstall everything.
>> >
>>
Error Message when starting SQL
This application has failed to start because MSVCXP71.dll was not found.
Re-installing the application may fix this problem.
I have tried reinstalling SQL and it did not resolve the problem, also
tried uninstalling but the uninstalltion did not uninstall everything.
AZ,
I don't think that is a SQL Server file. And Google has nothing for that
file name. Are you sure the name is correct? Have you checked the
application event log to see if any other events/errors were reported?
HTH
Jerry
"AZ" <AZ@.discussions.microsoft.com> wrote in message
news:CF97F012-F80A-43D3-8043-91238838F685@.microsoft.com...
> This application has failed to start because MSVCXP71.dll was not found.
> Re-installing the application may fix this problem.
> I have tried reinstalling SQL and it did not resolve the problem, also
> tried uninstalling but the uninstalltion did not uninstall everything.
>
|||When i try to start the sqlserveragent the first message i get is the service
did not respond to the start or control request in a timely fashion
When i click ok then i get
An error 1053 - (The service did not respond to the start or control request
in a timely fashion) occurred while performing this service operation on the
MSSQLServer service
The other message is when i open the enterprise manager and try to open the
database from there
"Jerry Spivey" wrote:
> AZ,
> I don't think that is a SQL Server file. And Google has nothing for that
> file name. Are you sure the name is correct? Have you checked the
> application event log to see if any other events/errors were reported?
> HTH
> Jerry
> "AZ" <AZ@.discussions.microsoft.com> wrote in message
> news:CF97F012-F80A-43D3-8043-91238838F685@.microsoft.com...
>
>
|||As for event logs under application i get the following three logs
Event Type:Error
Event Source:
Event Category:Alert Engine
Event ID:318
Date:21/10/2005
Time:11:44:54 AM
User:N/A
Computer:
Description:
Unable to read local eventlog (reason: The event log file has changed
between read operations).
Then
Event Type:Information
Event Source:
Event Category:Alert Engine
Event ID:311
Date:21/10/2005
Time:11:44:54 AM
User:N/A
Computer:K
Description:
Attempting to to re-open the local eventlog...
and finally
Event Type:Warning
Event Source:
Event Category:Alert Engine
Event ID:312
Date:21/10/2005
Time:11:44:54 AM
User:N/A
Computer:
Description:
Successfully re-opened the local eventlog - NOTE: Some events may have been
missed.
In under system event log i get the following 2 messages:
Event Type:Error
Event Source:Service Control Manager
Event Category:None
Event ID:7009
Date:21/10/2005
Time:11:45:00 AM
User:N/A
Computer:
Description:
Timeout (30000 milliseconds) waiting for the MSSQLSERVER service to connect.
Event Type:Error
Event Source:Service Control Manager
Event Category:None
Event ID:7000
Date:21/10/2005
Time:11:45:00 AM
User:N/A
Computer:
Description:
The MSSQLSERVER service failed to start due to the following error:
The service did not respond to the start or control request in a timely
fashion.
Thanks!
"Jerry Spivey" wrote:
> AZ,
> I don't think that is a SQL Server file. And Google has nothing for that
> file name. Are you sure the name is correct? Have you checked the
> application event log to see if any other events/errors were reported?
> HTH
> Jerry
> "AZ" <AZ@.discussions.microsoft.com> wrote in message
> news:CF97F012-F80A-43D3-8043-91238838F685@.microsoft.com...
>
>
|||Ok...test box? if so let's cut to the chase and change the startup account
for the services to the local system account and see if they start then.
HTH
Jerry
"AZ" <AZ@.discussions.microsoft.com> wrote in message
news:7DD97CE8-0F33-4D46-99C1-6BEA0B7AE0C7@.microsoft.com...[vbcol=seagreen]
> As for event logs under application i get the following three logs
> Event Type: Error
> Event Source:
> Event Category: Alert Engine
> Event ID: 318
> Date: 21/10/2005
> Time: 11:44:54 AM
> User: N/A
> Computer:
> Description:
> Unable to read local eventlog (reason: The event log file has changed
> between read operations).
> Then
> Event Type: Information
> Event Source:
> Event Category: Alert Engine
> Event ID: 311
> Date: 21/10/2005
> Time: 11:44:54 AM
> User: N/A
> Computer: K
> Description:
> Attempting to to re-open the local eventlog...
> and finally
> Event Type: Warning
> Event Source:
> Event Category: Alert Engine
> Event ID: 312
> Date: 21/10/2005
> Time: 11:44:54 AM
> User: N/A
> Computer:
> Description:
> Successfully re-opened the local eventlog - NOTE: Some events may have
> been
> missed.
>
> In under system event log i get the following 2 messages:
> Event Type: Error
> Event Source: Service Control Manager
> Event Category: None
> Event ID: 7009
> Date: 21/10/2005
> Time: 11:45:00 AM
> User: N/A
> Computer:
> Description:
> Timeout (30000 milliseconds) waiting for the MSSQLSERVER service to
> connect.
> Event Type: Error
> Event Source: Service Control Manager
> Event Category: None
> Event ID: 7000
> Date: 21/10/2005
> Time: 11:45:00 AM
> User: N/A
> Computer:
> Description:
> The MSSQLSERVER service failed to start due to the following error:
> The service did not respond to the start or control request in a timely
> fashion.
> Thanks!
> "Jerry Spivey" wrote:
Re-installing the application may fix this problem.
I have tried reinstalling SQL and it did not resolve the problem, also
tried uninstalling but the uninstalltion did not uninstall everything.
AZ,
I don't think that is a SQL Server file. And Google has nothing for that
file name. Are you sure the name is correct? Have you checked the
application event log to see if any other events/errors were reported?
HTH
Jerry
"AZ" <AZ@.discussions.microsoft.com> wrote in message
news:CF97F012-F80A-43D3-8043-91238838F685@.microsoft.com...
> This application has failed to start because MSVCXP71.dll was not found.
> Re-installing the application may fix this problem.
> I have tried reinstalling SQL and it did not resolve the problem, also
> tried uninstalling but the uninstalltion did not uninstall everything.
>
|||When i try to start the sqlserveragent the first message i get is the service
did not respond to the start or control request in a timely fashion
When i click ok then i get
An error 1053 - (The service did not respond to the start or control request
in a timely fashion) occurred while performing this service operation on the
MSSQLServer service
The other message is when i open the enterprise manager and try to open the
database from there
"Jerry Spivey" wrote:
> AZ,
> I don't think that is a SQL Server file. And Google has nothing for that
> file name. Are you sure the name is correct? Have you checked the
> application event log to see if any other events/errors were reported?
> HTH
> Jerry
> "AZ" <AZ@.discussions.microsoft.com> wrote in message
> news:CF97F012-F80A-43D3-8043-91238838F685@.microsoft.com...
>
>
|||As for event logs under application i get the following three logs
Event Type:Error
Event Source:
Event Category:Alert Engine
Event ID:318
Date:21/10/2005
Time:11:44:54 AM
User:N/A
Computer:
Description:
Unable to read local eventlog (reason: The event log file has changed
between read operations).
Then
Event Type:Information
Event Source:
Event Category:Alert Engine
Event ID:311
Date:21/10/2005
Time:11:44:54 AM
User:N/A
Computer:K
Description:
Attempting to to re-open the local eventlog...
and finally
Event Type:Warning
Event Source:
Event Category:Alert Engine
Event ID:312
Date:21/10/2005
Time:11:44:54 AM
User:N/A
Computer:
Description:
Successfully re-opened the local eventlog - NOTE: Some events may have been
missed.
In under system event log i get the following 2 messages:
Event Type:Error
Event Source:Service Control Manager
Event Category:None
Event ID:7009
Date:21/10/2005
Time:11:45:00 AM
User:N/A
Computer:
Description:
Timeout (30000 milliseconds) waiting for the MSSQLSERVER service to connect.
Event Type:Error
Event Source:Service Control Manager
Event Category:None
Event ID:7000
Date:21/10/2005
Time:11:45:00 AM
User:N/A
Computer:
Description:
The MSSQLSERVER service failed to start due to the following error:
The service did not respond to the start or control request in a timely
fashion.
Thanks!
"Jerry Spivey" wrote:
> AZ,
> I don't think that is a SQL Server file. And Google has nothing for that
> file name. Are you sure the name is correct? Have you checked the
> application event log to see if any other events/errors were reported?
> HTH
> Jerry
> "AZ" <AZ@.discussions.microsoft.com> wrote in message
> news:CF97F012-F80A-43D3-8043-91238838F685@.microsoft.com...
>
>
|||Ok...test box? if so let's cut to the chase and change the startup account
for the services to the local system account and see if they start then.
HTH
Jerry
"AZ" <AZ@.discussions.microsoft.com> wrote in message
news:7DD97CE8-0F33-4D46-99C1-6BEA0B7AE0C7@.microsoft.com...[vbcol=seagreen]
> As for event logs under application i get the following three logs
> Event Type: Error
> Event Source:
> Event Category: Alert Engine
> Event ID: 318
> Date: 21/10/2005
> Time: 11:44:54 AM
> User: N/A
> Computer:
> Description:
> Unable to read local eventlog (reason: The event log file has changed
> between read operations).
> Then
> Event Type: Information
> Event Source:
> Event Category: Alert Engine
> Event ID: 311
> Date: 21/10/2005
> Time: 11:44:54 AM
> User: N/A
> Computer: K
> Description:
> Attempting to to re-open the local eventlog...
> and finally
> Event Type: Warning
> Event Source:
> Event Category: Alert Engine
> Event ID: 312
> Date: 21/10/2005
> Time: 11:44:54 AM
> User: N/A
> Computer:
> Description:
> Successfully re-opened the local eventlog - NOTE: Some events may have
> been
> missed.
>
> In under system event log i get the following 2 messages:
> Event Type: Error
> Event Source: Service Control Manager
> Event Category: None
> Event ID: 7009
> Date: 21/10/2005
> Time: 11:45:00 AM
> User: N/A
> Computer:
> Description:
> Timeout (30000 milliseconds) waiting for the MSSQLSERVER service to
> connect.
> Event Type: Error
> Event Source: Service Control Manager
> Event Category: None
> Event ID: 7000
> Date: 21/10/2005
> Time: 11:45:00 AM
> User: N/A
> Computer:
> Description:
> The MSSQLSERVER service failed to start due to the following error:
> The service did not respond to the start or control request in a timely
> fashion.
> Thanks!
> "Jerry Spivey" wrote:
Error Message when starting SQL
This application has failed to start because MSVCXP71.dll was not found.
Re-installing the application may fix this problem.
I have tried reinstalling SQL and it did not resolve the problem, also
tried uninstalling but the uninstalltion did not uninstall everything.AZ,
I don't think that is a SQL Server file. And Google has nothing for that
file name. Are you sure the name is correct? Have you checked the
application event log to see if any other events/errors were reported?
HTH
Jerry
"AZ" <AZ@.discussions.microsoft.com> wrote in message
news:CF97F012-F80A-43D3-8043-91238838F685@.microsoft.com...
> This application has failed to start because MSVCXP71.dll was not found.
> Re-installing the application may fix this problem.
> I have tried reinstalling SQL and it did not resolve the problem, also
> tried uninstalling but the uninstalltion did not uninstall everything.
>|||When i try to start the sqlserveragent the first message i get is the servic
e
did not respond to the start or control request in a timely fashion
When i click ok then i get
An error 1053 - (The service did not respond to the start or control request
in a timely fashion) occurred while performing this service operation on the
MSSQLServer service
The other message is when i open the enterprise manager and try to open the
database from there
"Jerry Spivey" wrote:
> AZ,
> I don't think that is a SQL Server file. And Google has nothing for that
> file name. Are you sure the name is correct? Have you checked the
> application event log to see if any other events/errors were reported?
> HTH
> Jerry
> "AZ" <AZ@.discussions.microsoft.com> wrote in message
> news:CF97F012-F80A-43D3-8043-91238838F685@.microsoft.com...
>
>|||As for event logs under application i get the following three logs
Event Type: Error
Event Source:
Event Category: Alert Engine
Event ID: 318
Date: 21/10/2005
Time: 11:44:54 AM
User: N/A
Computer:
Description:
Unable to read local eventlog (reason: The event log file has changed
between read operations).
Then
Event Type: Information
Event Source:
Event Category: Alert Engine
Event ID: 311
Date: 21/10/2005
Time: 11:44:54 AM
User: N/A
Computer: K
Description:
Attempting to to re-open the local eventlog...
and finally
Event Type: Warning
Event Source:
Event Category: Alert Engine
Event ID: 312
Date: 21/10/2005
Time: 11:44:54 AM
User: N/A
Computer:
Description:
Successfully re-opened the local eventlog - NOTE: Some events may have been
missed.
In under system event log i get the following 2 messages:
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7009
Date: 21/10/2005
Time: 11:45:00 AM
User: N/A
Computer:
Description:
Timeout (30000 milliseconds) waiting for the MSSQLSERVER service to connect.
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7000
Date: 21/10/2005
Time: 11:45:00 AM
User: N/A
Computer:
Description:
The MSSQLSERVER service failed to start due to the following error:
The service did not respond to the start or control request in a timely
fashion.
Thanks!
"Jerry Spivey" wrote:
> AZ,
> I don't think that is a SQL Server file. And Google has nothing for that
> file name. Are you sure the name is correct? Have you checked the
> application event log to see if any other events/errors were reported?
> HTH
> Jerry
> "AZ" <AZ@.discussions.microsoft.com> wrote in message
> news:CF97F012-F80A-43D3-8043-91238838F685@.microsoft.com...
>
>|||Ok...test box? if so let's cut to the chase and change the startup account
for the services to the local system account and see if they start then.
HTH
Jerry
"AZ" <AZ@.discussions.microsoft.com> wrote in message
news:7DD97CE8-0F33-4D46-99C1-6BEA0B7AE0C7@.microsoft.com...[vbcol=seagreen]
> As for event logs under application i get the following three logs
> Event Type: Error
> Event Source:
> Event Category: Alert Engine
> Event ID: 318
> Date: 21/10/2005
> Time: 11:44:54 AM
> User: N/A
> Computer:
> Description:
> Unable to read local eventlog (reason: The event log file has changed
> between read operations).
> Then
> Event Type: Information
> Event Source:
> Event Category: Alert Engine
> Event ID: 311
> Date: 21/10/2005
> Time: 11:44:54 AM
> User: N/A
> Computer: K
> Description:
> Attempting to to re-open the local eventlog...
> and finally
> Event Type: Warning
> Event Source:
> Event Category: Alert Engine
> Event ID: 312
> Date: 21/10/2005
> Time: 11:44:54 AM
> User: N/A
> Computer:
> Description:
> Successfully re-opened the local eventlog - NOTE: Some events may have
> been
> missed.
>
> In under system event log i get the following 2 messages:
> Event Type: Error
> Event Source: Service Control Manager
> Event Category: None
> Event ID: 7009
> Date: 21/10/2005
> Time: 11:45:00 AM
> User: N/A
> Computer:
> Description:
> Timeout (30000 milliseconds) waiting for the MSSQLSERVER service to
> connect.
> Event Type: Error
> Event Source: Service Control Manager
> Event Category: None
> Event ID: 7000
> Date: 21/10/2005
> Time: 11:45:00 AM
> User: N/A
> Computer:
> Description:
> The MSSQLSERVER service failed to start due to the following error:
> The service did not respond to the start or control request in a timely
> fashion.
> Thanks!
> "Jerry Spivey" wrote:
>
Re-installing the application may fix this problem.
I have tried reinstalling SQL and it did not resolve the problem, also
tried uninstalling but the uninstalltion did not uninstall everything.AZ,
I don't think that is a SQL Server file. And Google has nothing for that
file name. Are you sure the name is correct? Have you checked the
application event log to see if any other events/errors were reported?
HTH
Jerry
"AZ" <AZ@.discussions.microsoft.com> wrote in message
news:CF97F012-F80A-43D3-8043-91238838F685@.microsoft.com...
> This application has failed to start because MSVCXP71.dll was not found.
> Re-installing the application may fix this problem.
> I have tried reinstalling SQL and it did not resolve the problem, also
> tried uninstalling but the uninstalltion did not uninstall everything.
>|||When i try to start the sqlserveragent the first message i get is the servic
e
did not respond to the start or control request in a timely fashion
When i click ok then i get
An error 1053 - (The service did not respond to the start or control request
in a timely fashion) occurred while performing this service operation on the
MSSQLServer service
The other message is when i open the enterprise manager and try to open the
database from there
"Jerry Spivey" wrote:
> AZ,
> I don't think that is a SQL Server file. And Google has nothing for that
> file name. Are you sure the name is correct? Have you checked the
> application event log to see if any other events/errors were reported?
> HTH
> Jerry
> "AZ" <AZ@.discussions.microsoft.com> wrote in message
> news:CF97F012-F80A-43D3-8043-91238838F685@.microsoft.com...
>
>|||As for event logs under application i get the following three logs
Event Type: Error
Event Source:
Event Category: Alert Engine
Event ID: 318
Date: 21/10/2005
Time: 11:44:54 AM
User: N/A
Computer:
Description:
Unable to read local eventlog (reason: The event log file has changed
between read operations).
Then
Event Type: Information
Event Source:
Event Category: Alert Engine
Event ID: 311
Date: 21/10/2005
Time: 11:44:54 AM
User: N/A
Computer: K
Description:
Attempting to to re-open the local eventlog...
and finally
Event Type: Warning
Event Source:
Event Category: Alert Engine
Event ID: 312
Date: 21/10/2005
Time: 11:44:54 AM
User: N/A
Computer:
Description:
Successfully re-opened the local eventlog - NOTE: Some events may have been
missed.
In under system event log i get the following 2 messages:
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7009
Date: 21/10/2005
Time: 11:45:00 AM
User: N/A
Computer:
Description:
Timeout (30000 milliseconds) waiting for the MSSQLSERVER service to connect.
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7000
Date: 21/10/2005
Time: 11:45:00 AM
User: N/A
Computer:
Description:
The MSSQLSERVER service failed to start due to the following error:
The service did not respond to the start or control request in a timely
fashion.
Thanks!
"Jerry Spivey" wrote:
> AZ,
> I don't think that is a SQL Server file. And Google has nothing for that
> file name. Are you sure the name is correct? Have you checked the
> application event log to see if any other events/errors were reported?
> HTH
> Jerry
> "AZ" <AZ@.discussions.microsoft.com> wrote in message
> news:CF97F012-F80A-43D3-8043-91238838F685@.microsoft.com...
>
>|||Ok...test box? if so let's cut to the chase and change the startup account
for the services to the local system account and see if they start then.
HTH
Jerry
"AZ" <AZ@.discussions.microsoft.com> wrote in message
news:7DD97CE8-0F33-4D46-99C1-6BEA0B7AE0C7@.microsoft.com...[vbcol=seagreen]
> As for event logs under application i get the following three logs
> Event Type: Error
> Event Source:
> Event Category: Alert Engine
> Event ID: 318
> Date: 21/10/2005
> Time: 11:44:54 AM
> User: N/A
> Computer:
> Description:
> Unable to read local eventlog (reason: The event log file has changed
> between read operations).
> Then
> Event Type: Information
> Event Source:
> Event Category: Alert Engine
> Event ID: 311
> Date: 21/10/2005
> Time: 11:44:54 AM
> User: N/A
> Computer: K
> Description:
> Attempting to to re-open the local eventlog...
> and finally
> Event Type: Warning
> Event Source:
> Event Category: Alert Engine
> Event ID: 312
> Date: 21/10/2005
> Time: 11:44:54 AM
> User: N/A
> Computer:
> Description:
> Successfully re-opened the local eventlog - NOTE: Some events may have
> been
> missed.
>
> In under system event log i get the following 2 messages:
> Event Type: Error
> Event Source: Service Control Manager
> Event Category: None
> Event ID: 7009
> Date: 21/10/2005
> Time: 11:45:00 AM
> User: N/A
> Computer:
> Description:
> Timeout (30000 milliseconds) waiting for the MSSQLSERVER service to
> connect.
> Event Type: Error
> Event Source: Service Control Manager
> Event Category: None
> Event ID: 7000
> Date: 21/10/2005
> Time: 11:45:00 AM
> User: N/A
> Computer:
> Description:
> The MSSQLSERVER service failed to start due to the following error:
> The service did not respond to the start or control request in a timely
> fashion.
> Thanks!
> "Jerry Spivey" wrote:
>
Subscribe to:
Posts (Atom)