473,327 Members | 2,118 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

How to isolate a DBTYPE_DBTIMESTAMP to datetime error?

Hi I am trying to extract data using SQL Server 2005 from a table on an ODBC linked server using the following syntax:

select *
from [Server]..[Schema].[Table]

When I run the query the following message appears:

'Error converting data type DBTYPE_DBTIMESTAMP to datetime'

I know that this is because a date or dates have been incorrectly input into the source database (e.g. 200-06-01 instead of 2008-06-01)

I would like to know how to locate/isolate this date field error via an SQL query in order to correct the date field in the source database.

Any ideas?

Thanks in advance
Sep 10 '08 #1
3 5357
ck9663
2,878 Expert 2GB
What's the source? What kind of data source are you getting the data from? Can you specify on the select to convert that datetime column to varchar instead? You just have to find which column is offending the t-sql and you also need to enumerate the column names on your select not just "*".

-- CK
Sep 10 '08 #2
What's the source? What kind of data source are you getting the data from? Can you specify on the select to convert that datetime column to varchar instead? You just have to find which column is offending the t-sql and you also need to enumerate the column names on your select not just "*".

-- CK
Hi

The source is a Progress database.

I've spoken to a colleague in the office and he suggested using a cursor to find the error, however when this employed, it returns a huge error message relating to various columns within the Progress database.

The error may be appearing because the Progress database (via the linked server) uses a different datestamp to SQL Server or because there is a problem with the link between the Progress database and SQL Server.

Not to worry. Thanks for your help.
Sep 11 '08 #3
ck9663
2,878 Expert 2GB
What error are you getting? Are you using OPENQUERY? Did you pass the query that will run in PROGRESS? Could you post what you have so far?

-- CK
Sep 11 '08 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Sorisio, Chris | last post by:
Ladies and gentlemen, I've imported some data from a MySQL database into a Python dictionary. I'm attempting to tidy up the date fields, but I'm receiving a 'mx.DateTime.Error: cannot convert...
0
by: fowlertrainer | last post by:
Hi ! I think that I have been found a bug in mx.DateTime... So: I use FireBird, and in this RDBMS the datetime fields are "doubles". So if I set them to 0, the values the fields are '1899-12-30...
2
by: .Net Sports | last post by:
I'm trying to initialize a variable inside a PageLoad in visualstudio.net : mytoday = DateTime.Now; ...and the error (or Build Task error) says : The name 'mytoday' does not exist in the...
8
by: Alan Silver | last post by:
Hello, I have a custom control that displays the date and time. I currently have properties for the day, month, year, hour and minute, which have to be set separately. This is inefficient. I...
5
by: I am Sam | last post by:
I have created this DateTime object and instanced it I think correctly DateTime myClubNow1=new...
11
by: Cor Ligthert | last post by:
Hello everybody, Jay and Herfried are telling me every time when I use CDate that using the datetime.parseexact is always the best way to do String to datetime conversions. They don't tell why...
11
by: Tim | last post by:
Hi, I am trying to do something simple. Convert a string date to datetime but it is not working and is giving me a baffling error! System.Convert.ToDateTime("Jan 30, 2006")...
3
by: pranesh.nayak | last post by:
I'm facing an error:"String was not recognized as a valid DateTime" whille accessing DateTime from webservice. And when I try to set DateTime to the same webservice it fails with error:"Date...
0
by: bluepiper | last post by:
Hi everyone. I have created a linked server on SQL Server 2005 to access data from visual foxpro database. I execute a query Select * from OpenQuery(members, 'Select * from memfile') but Im...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.