469,903 Members | 2,034 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,903 developers. It's quick & easy.

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

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!
Jul 23 '05 #1
1 8573
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
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by sandman | last post: by
1 post views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.