Well, excuse me, the answer was very easy. Just adding the word "ROLE=" and
the user's role it works.

Greetings.

Walter.

On Tue, May 17, 2011 at 8:48 PM, W O <sistemas2000profesional@...>wrote:

> Hello everybody
>
> Is it possible to specify a role when connecting to a database with a
> driver ODBC?
>
> In my application I use a connection string like it:
>
> lcConnectionString = "DRIVER={" + cODBC_Driver + "};" ;
> + "SERVER=" + cServer + ";" ;
> + "USER=" + cUser + ";" ;
> + "PASSWORD=" + cPassword + ";" ;
> + "DATABASE=" + cDataBase + ";" ;
> + "OPTIONS=131329;"
>
> and it works fine, but now I want to add the user's role. Is it possible?
> How?
>
> Thanks in advance.
>
> Walter.
>
>


[Non-text portions of this message have been removed]