sql server odbc: 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.

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