I have an SDE database with a number of user schemas. I'm wanting to connect using different credentials for each and get information about the tables and datasets within.
I'm using arcpy, and have an .sde file for each user connection. Alone, all of these connections work fine set to arcpy.env.workspace. If I iterate through each one however, only the first one will work, the rest don't provide errors, but don't list datasets or feature classes, and have nothing in the connection properties of a Describe object run on the current workspace.
I've tried ClearWorkspaceCache_management, ClearEnvironment, ResetEnvironment. Nothing works... I'm stumped.
I'm using 10.1 pre on linux, and must be missing something about how env works in arcpy, but I have not found anything in the doc to help me out. Can someone help me find what I am missing?