| Author |
Message
|
| kishoreraju |
 Posted: Mon Feb 13, 2006 8:25 am Post subject: Problem with oracle driver in 6.0 |
 |
|
Disciple
Joined: 30 Sep 2004
Posts: 156
|
Can any one throw some light on below problem
I have a problem when i am trying to execute complex queries on oracle
this is the environment setup.
i have oracle client on my mechine.
i am able to execute simple queries like select * from EMP.
but when i tried execute complex queries like the below one
ELECT DISTINCT SYSTEM_SEND_TRACK.SYSTEM "System", SYSTEM_SEND_TRACK.REFERENCENUMBER "ReferenceNumber", '||
'SYSTEM_SEND_TRACK.ENTRYTIME "EntryTime" FROM SYSTEM_SEND_TRACK,SYSTEM_TIMEOUT_CONFIGURATION '||
'WHERE SYSTEM_SEND_TRACK.ENTRYTIME + TO_DSINTERVAL(TIMEOUTPERIOD)< to_date(?, ''yyyy-mm-dd hh24:mi:ss'') '||
'AND ENTRYTIME=(SELECT MIN(ENTRYTIME) FROM SYSTEM_SEND_TRACK SST '||
'WHERE SST.SYSTEM = SYSTEM_SEND_TRACK.SYSTEM '||
'AND SST.SYSTEM NOT IN (SELECT DISTINCT SST2.SYSTEM '||
'FROM SYSTEM_SEND_TRACK SST2 WHERE SST2.AlertSent=''Y''
i am getting errors like
Database error: SQL State ''IM001''; Native Error Code '0'; Error Text ''[Microsoft][ODBC Driver Manager] Driver does not support this function''.
The error has the following diagnostic information: SQL State ''IM001'' SQL Native Error Code '0' SQL Error Text ''[Microsoft][ODBC Driver Manager] Driver does not support this function''
the above query is corret because it is executing at SQL editor
I am using passthru statement for executing the queries and I TRIED WITH ALL THE THREE DRIVERS FOR THE ORACLE. |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Mon Feb 13, 2006 8:31 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You have to use the Merant driver that comes with WBIMB.
Also, what VERSION of Oracle are you trying to use?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| mlafleur |
| Posted: Mon Feb 13, 2006 8:34 am Post subject: |
|
|
Acolyte
Joined: 19 Feb 2004
Posts: 73
|
| Use the DataDirect 5.0 Oracle Driver and Select "Enable SQLDescribeParam" on the ODBC Oracle Driver Setup, Advanced Tab |
|
| Back to top |
|
|
| JT |
| Posted: Mon Feb 13, 2006 8:45 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| I thought the DISTINCT keyword on the SELECT statement was not supported. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Mon Feb 13, 2006 9:00 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| JT wrote: |
| I thought the DISTINCT keyword on the SELECT statement was not supported. |
It's not, but
| kishoreraju wrote: |
| I am using passthru statement for executing the queries |
And it should be supported in PASSTHRU.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| kishoreraju |
| Posted: Mon Feb 13, 2006 9:16 am Post subject: issue resolved |
|
|
Disciple
Joined: 30 Sep 2004
Posts: 156
|
Thanks
issue is resolved. |
|
| Back to top |
|
|
| JT |
| Posted: Mon Feb 13, 2006 10:24 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| For the benefit of all, what was the resolution? |
|
| Back to top |
|
|
| kishoreraju |
| Posted: Tue Feb 14, 2006 1:23 am Post subject: |
|
|
Disciple
Joined: 30 Sep 2004
Posts: 156
|
Thanks mlafleur
The below is the solution
mlafleur wrote
| Code: |
| Use the DataDirect 5.0 Oracle Driver and Select "Enable SQLDescribeParam" on the ODBC Oracle Driver Setup, Advanced Tab |
|
|
| Back to top |
|
|
|
|
