How to set Oracle-roles from VB

From: Joerg Schmiedle <joerg.schmiedle_at_roche.com>
Date: Fri, 8 Jul 1994 13:55:31 GMT
Message-ID: <1994Jul8.135531.6248_at_roche.com>

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?

Joerg Schmiedle                         Email:
joerg.schmiedle_at_roche.com
PRST Pharma Research Technologies       Tel:   0041 61 68 88096
Bldg.71/114                             Fax:   0041 61 68 82355

"It's more than typing MAKE..."

Hoffmann La Roche AG/ Grenzacherstr.124/ CH-4002 Basel/ Switzerland Received on Fri Jul 08 1994 - 15:55:31 CEST