Enabling write access for PSC ODBC Driver.

Problem:
By default, the PSC ODBC driver has read only access.
Solution:

1. Set default isolation level in ODBC driver properties (Advanced tab) to "READ COMMITTED". Note that "READ UNCOMMITTED" (default state) implies read only.

2. In PSC SQL explorer, connect via Administrator credentials and issue the following SQL statement (one for each db table desired):

GRANT ALL ON PUB.tablename TO Administrator;

...

COMMIT;

Note: Be sure to prefix the table name with "PUB".

Article Details

Article ID:
36
Category:
Date added:
2011-01-10 20:02:58
Views:
415
Rating (Votes):
(525)