By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,245 Members | 884 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,245 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.