Networks

Ask something
Discussion Locked

ODBC - Update capability?

0 helpful
4 replies

by jfreeman56

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Can an ODBC connection be used to update (write) a Microsoft 200 SQL database? or is it read only? If it can write, can it be confiugred to not allow writing?

4 replies

by jfreeman56

I guess I'm hearing that ODBC CAN update the database, but is there a practical way to prevent it.

We want to use BarTender (barcode label software) to print labels with static information from the database, ie. Customer name, address, item number, description, order no. etc. The vendor has stipulated that the software has no WRITE capability to the database.

Yet our business partner wants us to establish a new user with no write access to the database. My technical people say that ODBC would ignore that anyway. And anyone creating or printing labels would have to use this "label user id" rather than their own network sign-on.

It seems to me that is totally impractical and will not make any difference anyway.

by d_v ant

The ODBC connection is just that, a connection. It tells the application how to get to the database. All access rights are still handled by the OS and the database and must be set there.

by jfreeman56

Poster rated this answer.
I understand that the OS (Windows 2000?) does NOT control it - and the ODBC bypasses the application security and apparently can be controlled by the DSN - (Data Source Name). If that is the case, I am looking for some information on how to set up the DSN.

This discussion is closed to new replies.