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 ***

Tim Groulx (timgru@hotmail.com) writes:
[quoted text, click to view]

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, esquel@sommarskog.se

Books Online for SQL Server SP3 at