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!

Jul 23 '05 #1

Subscribe Reply

9469

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****@sommarsk og.se

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

Jul 23 '05 #2

Similar topics

3988

Gettime ??? for displaying server time on browser

by: Matthew Ferri | last post by:

I'm trying to display the server time on the local browser, just as http://www.time.gov does it. Is there any sample code for JS or VB available? TIA,

ASP / Active Server Pages

20983

Help! SQL Server error - [Microsoft][ODBC SQL Server Driver][SQL Server] Invalid object name ...

by: FreeOperator | last post by:

Dear all, On Win2000 server with SP3, I am trying to access a SQL Server 7.0 database, "TestDB", from VB6 via a SQL Server ODBC system DSN using ADO 2.7. In SQL Server Enterprise Manager, there is a login named "Tester". In its property window, NO "Server Roles" was assigned but its "Database Access" was set to "TestDB". This login was also...

Microsoft SQL Server

2449

Server Time Revisited

by: sandman | last post by:

I've been testing my web app on another workstation to simulate using the server time. The test pc's time is an hour behind the server time and when the user processes a request, the server time is picked up. The problem is that I've got a "clock" on the web page that updates the "current time" every second since the app is time critical. ...

C# / C Sharp

40627

ERROR [IM002] [Microsoft][ODBC Driver Manager]

by: Dakkar | last post by:

I wrote a program with c# for connecting mysql and taking data from it but when someone without me try to execute the program they are taking this error ERROR Data source name not found and no default driver

C# / C Sharp

8322

ERROR: [ODBC Microsoft Access Driver]Invalid precision value

by: Reza Nabi | last post by:

Dear All: I have been developing ASP.NET application on MS Access database using ODBC. When I was trying to save more than 255 chars in a Memo field I got the following error. ERROR Invalid precision value Below is the code snippet of two function where it is breaking. Any advice on this would be greatly appreciated.

ASP.NET

5895

ERROR [HY104] [Microsoft][ODBC Microsoft Access Driver]Invalid precision value

by: jwtulp | last post by:

Hello all, I receive the following error when updating MSAccess2003 Memo fields using an ODBC connection in ASP.Net 1.1 when the length of the text to be updated exceeds 255 characters. Everything works fine when the length of the text stays below 255 characters. Does anyone have a clue?: ERROR Invalid precision value

ASP.NET

10023

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name

by: daxter | last post by:

hi i m connect to the sQL SERVER using system DSN in JREPORT but it is not working get the following error Invalid object name

Microsoft SQL Server

6589

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name on Linked Server

by: MrByte | last post by:

Hi Folks, I'm having a strange situation here between 2 Linked MS SQL 2K servers. One of the servers died recently and I rebuilt it. All seems to be working fine, except that when I create views that access tables on the other (linked) server, I can not modify any data, because I get the Invalid object name server.database.dbo.TableName...

Microsoft SQL Server

3871

Run-time error "7": Error executing statement! Error:[Microsoft][ODBC dBase Driver]

by: DontB3 | last post by:

Hi, I'm new in this forum, and i hope someone can help. I'm creating an automatic application that transfer a database from Access -> DBF -> Oracle. When My App try to execute Insert SQL statement from DBF to Oracle database i found an error like this {Run-time error "7": Error executing statement! Error: System resource exceeded.} ...

Visual Basic 4 / 5 / 6

7693

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...

General

7916

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...

C / C++

7962

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...

General

6275

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...

Career Advice

5217

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...

C# / C Sharp

3651

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...

Networking - Hardware / Configuration

3631

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2101

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

932

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

General