Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Data Access

SQLSTATE 01000

Does anyone know how to suprime
the error message [SQLSTATE01000} that comes at the end of aPrint line?
Thank you.
M.-
[176 byte] By [Marcas] at [2008-2-6]
«« DataGridView with an AlternatingRowsDefaultCellStyle
»» Four Checkboxes of Bit Datatype in IIF() not working correctly
# 1
I'd need to know more about you application to give a complete answer, but getting SQLSTATE 01000 at the end of a result set is perfectly normal. This is simply the status that is returned when you try to fetch a row after the end of the result set has been reached, so there are no more rows to return.

The first two characters of SQLSTATE categorise the type of status. 00 means success, 01 means warning, other combinations mean error. The remaining three characters are the actual status within category.

ChrisLee at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Data Access...
# 2

This error generally occurs when the database is not opened. it may be due to invalid username or invalid password

by

dss

shasunder at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Data Access...
SQL Server
SQL Server Data Access

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified