Subject | How can I connect to a database with a connection string and a role? |
---|---|
Author | W O |
Post date | 2011-05-18T00:48:31Z |
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]
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]