I tried putting garbage in for the ROLENAME and ROLEPWD and the connection opened with S_OK. HUH?

Apparently setting the role in the connect string isn't enough. The session is openrf without error, but when I try to open a recordset in which the role is...

Thank you Paul.

I don't need to create a role, only enable one, and I believe this can be done with the connection string, with the arguments ROLENAME and ROLEPWD.

I was...