Query read-only connection with ODBC using DAO? 
Author Message
 Query read-only connection with ODBC using DAO?

Is this possible?

I have a VB app which connects to an Oracle database through ODBC using
DAO.  I am using Intersolv's ODBC drivers.  I have a login screen where the
user enters an Oracle userid and password to sign on.  Since Oracle has the
capability of assigning 'read-only' userids, I was wonder if, after I make
the connection, there was a way I can query the Connection object (or
something else) to find out the user has read-only access.

What I'd like to do is disable some screen fields if the user connects with
a read-only userid.  I am quite certain doing this would be much easier if
I had used the ODBC API, but since I am using DAO I am wondering if anyone
has tried this or has any recommendations.

By the way, the flag you can specify while opening a connection which
indicates the connection should be read-only *does not* work.  You are
still allowed to make updates.  Even if it did, I'd rather query the DAO
object to see if the user is connected read-only as opposed to hard-coding
a special userid into my login screen that will make a read-only connection
explicitly.
--
Regards,
Jim



Sun, 27 Feb 2000 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Help Connection to Access thru ODBC using DAO

2. ODBC connections using ODBC

3. ODBC and DAO connection problem

4. Connection DAO with ODBC

5. Question on ODBC Connection with DAO

6. Connection to ODBC with DAO

7. DAO and ADO connection for ODBC Oracle Databases

8. disconnecting DAO-ODBC Connection to SQL Server

9. DAO, ODBC, CreateQueryDef, Pass Through Query, Form Population Problem

10. DAO Queries & ODBC

11. ODBC and DAO Read Only problem

12. DAO/ODBC read only?

 

 
Powered by phpBB® Forum Software