Conection with VB

From: John Bester <johnb_at_iconnect.co.za>
Date: Fri, 17 Jul 1998 15:12:48 +0200
Message-ID: <35afcca8.0@informer.hixnet.co.za>

I have a local Oracle 7 database on my NT workstation which I want to connect to using VB5 via ODBC (Using "Microsoft ODBC Driver for Oracle" v2.00.006325, ODBC manager v 3.0.28.22). If I use a Data Form Wizard, I get an "ODBC Database Open Failed" message, and if I try to connect using rdoEnvironment.OpenConnection(

    dsName:="MyDSN",
    Prompt:=rdDriverNoPrompt,
    Connect:="DSN=MyDSN;UID=MyUsr;PWD=MyPwd;"), I get an exception with the following msg:
"S0002: [Microsoft][ODBC driver for Oracle][Oracle]ORA-00942: table or view does not exist"

Any suggestions are most welcome. (Since I have problems with Visual InterDev if I install a newer version of ODBC Driver, I don't really have the option of upgrading my ODBC)

Rgds
---
John Bester
johnb_at_iconnect.co.za Received on Fri Jul 17 1998 - 08:12:48 CDT