Read Only ODBC attachments to Servers

  • Thread starter Thread starter Dave Dawson
  • Start date Start date
D

Dave Dawson

This question concerns the set up of an ODBC driver for
SQL Server.

A couple of years ago, I set up an ODBC driver for a
client with an IBM AS400 backend. The driver allowed the
user to attach to the AS400 in "Read Only" mode. This
allowed me to set up an attachment for the Application I
developed using "Read/Write" and an attachment for a "Read
Only" database for building user queries and reports.

I can't seem to do this for SQL Server. Am I missing
something or did the IBM ODBC driver have this
functionality built in?

Dave
 
"Read-Only" was probably the limit of the ODBC driver you used with the IBM
AS4000 at that time. For most ODBC drivers, whether you can Read/Write or
Read-Only, this is the fuction of the Security / Permission of the database
server.
 
Back
Top