Re: Conection with VB

"John Bester" <johnb_at_iconnect.co.za> wrote:

>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
>
>
>

For Rdo this works for me....

Dim RdoEnvironment As RdoEnvironment

Set RdoEnvironment = rdoEnvironments(0) Set RdoDatabase =
RdoEnvironment.OpenConnection("",rdDriverNoPrompt,False,"DSN=Oracle7;UID=SCOTT;PWD=TIGER;")

Hope it gives you an idea about yours.... Received on Fri Jul 17 1998 - 09:08:05 CDT