Roles not working

By: Quinn Wildman

Abstract: Older versions of InterBase SQL Links driver do not support roles

Q. I have created an application using InterBase Roles using BDE/SQL Links for InterBase. It works fine on my development system. However, when I deploy my application the roles are ignored. Why?

A. Check to make sure your deployment system has the same version of the InterBase SQL Links driver as your development system. Earlier versions of the InterBase SQL Links driver did not support roles and therefore any settings indicating roles will be ignored.

It is also recommended you test your roles with an InterBase specific tool, such as IBConsole or isql. If these work yet your application does not, you can be certain the problem is not on the InterBase side, but on the application or deployment side instead.

Server Response from: ETNASC04