Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
alejo46
Posting Yak Master
157 Posts |
 Posted - 2010-05-20 : 20:38:48
|
| Good evening:I need your help pease.Using SLQ Server 2000 sometimes i tried to read an oracle table and then insert to a SQLSERVER 2000 table. The conexion to oracle table is already estabished by a linked server throuh an openquery statement.Sometimes executing this openquery yields wuth the following errormessage: "error converting datetime to timestamp."The solution up to know us restarting the instance, but sometimes you can't restart the instance because there are a lot of processes running.Why this kind of error yields when using an openquery to an oracle source?Is there any other way to figure out and so avoid restarting the instance every time the message comes up?.I'd appreciate your help, thanks |
|
|
|
|
|
error converting datetime to timestamp.