Runtime Error: [Microsoft][ODBC SQL Server Driver]Invalid time format

[Tim Groulx]

Hello All,

I am getting the following error when attemping to open a table in
SQL2kSP3a.
________________________________________
SQL Server Enterprise Manager

Database Server: Microsoft SQL Server
Version: 08.00.0760
Runtime Error: [Microsoft][ODBC SQL Server Driver]Invalid time format
_________________________________________

I cannot find it in sysmessages, or on the web.

Any ideas about how to resolve this? And how it occured...

Thanks,

TGru

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Erland Sommarskog]

Tim Groulx (ti****@hotmail.com) writes:

I am getting the following error when attemping to open a table in
SQL2kSP3a.
________________________________________
SQL Server Enterprise Manager

Database Server: Microsoft SQL Server
Version: 08.00.0760
Runtime Error: [Microsoft][ODBC SQL Server Driver]Invalid time format
_________________________________________

I cannot find it in sysmessages, or on the web.

The reason you can't find it sysmessages is that the message does not
come from SQL Server, but from the ODBC driver.

Really why that would happen, I don't really know. I can think of two
possibilities:

o ODBC does not like your regional settings. In such case you would
get the error as you tried to open an table that has a datetime column.

o There is a corrupt value in one or more rows in a datetime column
in this particular table.

Both these guesses may be wrong, and the cause is something else. I would
narrow it down by using SELECT statements in the table from Query Analyzer.
I would expect QA produce the same error if you say SELECT * FROM tbl
without WHERE condition.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp