Subject How can I connect to a database with a connection string and a role?
Author W O
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]