|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
|
|||
|
|||
|
MSSQL Linked Server to Oracle
I am trying to run a query from inside MSSQL 7 to a linked Oracle server. I am using a where statement to limit the returns based on a date field in the Oracle database (8i). I cannot get it to recognize it at all. It always locks up my SQl server. Any help??
I've tried: where (TRANS_DT >= '01/01/2004') and where (TRANS_DT >= '01-01-2004') and where (TRANS_DT >= '01-FEB-2004') The query will only work when I access the Oracle db directly. |
|
#2
|
|||
|
|||
|
Have you tried using CONVERT to turn it into a DateTime? It looks to me like you are trying to compare a date to a string.
|
![]() |
| Viewing: Dev Shed Forums > Databases > MS SQL Development > MSSQL Linked Server to Oracle |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|