Having problem with SQLConnection.ChangeDatabase() method.

K

Ken Varn

I have multiple databases in which I want to traverse. Each database is
secured using Applicaiton Roles. I use the SQLConnection object to connect
to the first database. I run the sp_setapprole procedure and I can access
the tables with no problem. However, when I try to call the ChangeDatabase
method on my connection object, I get an exception thrown stating that my
application role user is not a valid user in the database. If I connect to
the same database using Open, it works fine. I don't quite understand what
is going on here. Can anyone help?

--
-----------------------------------
Ken Varn
Senior Software Engineer
Diebold Inc.

EmailID = varnk
Domain = Diebold.com
-----------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help with connect string for using Application Roles in SQL Server. 7
How do I connect to SQL database using applicaiton roles and ado.net? 3
Need info on comparrision between OleDBConnection and SqlConnection objects. 1
Distinct on a DataSet. 3
Need explanation on calling Close() from finalizer. 8
Questions about Prepare() method. 1
Connection to SQL Server only. 4
How can I OR all the values in a particular column across multiple rows? 5

Top