Problems with [Microsoft][ODBC driver for Oracle][Oracle]

Hello all,
I have a VB application that is running fine in prod on a box without
the .net framework installed. The app queries a Oracle 8.1.7 64 bit
database. It uses the Microsoft ODBC Driver for Oracle and it works
like a champ. However I am adding some enhancements to this application
and on my local machine I have the the .NET framework installed of
course. And I am finding that my simple select statement below is
failing.
Select * From is_sec_ipass Where TO_CHAR(start_time,'yyyymm') =
'200505' And type = 'I'
I looked at the driver version on the production box as well as my box
and this is what I have found.
Prd driver = 2.573.7713.00
my box = 2.573.7713.00
Is there something I am missing here? I even stripped down the query to
this SELECT * FROM ISSEC_DB.IS_SEC_IPASS and it still bombs out.
Here is the error I get.
Error (-2147217900): [Microsoft][ODBC driver for
Oracle][Oracle]ORA-00900: invalid SQL statement
This is just killing me. Any insight you have would be great.
Thanks,
Pitdog
Sorry I messed up on the driver version numbers
Prd driver = 2.573.7713.00
my box = 2.573.9030.00
They are different.
|||I had the same problem for the past few days. I think it has to do more
with the Oracle client installed on the machine.
I had installed Orcale 9i client on the user machine and tried to run
the vb application. I was getting the same error. So I uninstalled the
Oracle 9i client and installed Oracle 8.0 client. And as I had guessed,
the application ran perfectly fine. Now I am installing Oracle 8.0
client on each user machine before distributing the application.
Looks like the Microsoft ODBC oracle driver cannot work in sync with
Oracle 9i client. I would recommend you try uninstalling Oracle 9i and
install a previous version.
*** Sent via Developersdex http://www.codecomments.com ***
|||Hey Lucky Thanks for the help. I will check it out tomorrow in the am.
Fingers crossed.
|||Hey Lucky no dice on this. The DB is a 8.1 db and that client I am
using is the correct one. I have opened a ticket with the DBA's here I
am hoping they can shed some light on this issue. I will post back if I
find an answer.
PD