Re: How to set Oracle-roles from VB

From: RSCary <rscary_at_aol.com>
Date: 10 Jul 1994 02:09:04 -0400
Message-ID: <2vo3a0$3nn_at_search01.news.aol.com>

In article <1994Jul8.135531.6248_at_roche.com>, joerg.schmiedle_at_roche.com (Joerg Schmiedle) writes:

Hi everybody,

I'm working on VB and ODBC to connect to a remote Oracle V7.0.15.4.1 database. I'm using SQLnet V1.1.7.9.1 and the Oracle 7 ODBC driver V1.10.0000.

After a sucessful connect to the remote database, I try to set a role from my VB-application. The SQL-syntax (which works fine with SQLplus) is
"SET ROLE ROLE_NAME;" The question is: How can I execute this SQL-statement from Visual Basic.
I tried to use the ExecuteSQL-method, but doesn't work.

Any comments?

Your problem is you are trying to execute a SQL*Plus command as SQL. It will only work in SQL*Plus.

Scott Cary Received on Sun Jul 10 1994 - 08:09:04 CEST

This message: [ Message body ]
Next message: Michael Rife: "Re: HELP:How to get list of tables in a database in Oracle?"
Previous message: Michael Haldey: "Re: Oracle-->Clipper API??"
In reply to: Joerg Schmiedle: "How to set Oracle-roles from VB"
Next in thread: Michael Rife: "Re: HELP:How to get list of tables in a database in Oracle?"
Reply: Jim Lane: "Re: How to set Oracle-roles from VB"
Reply: Barry Roomberg: "Re: How to set Oracle-roles from VB"
Reply: Bill Manry - IBM SBU: "Re: How to set Oracle-roles from VB"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message