Arcpy.ListWorkspaces returns wrong results

Question

Hi, I am trying to get a list of database connections stored in the folder, the script runs successfully but it gives wrong results! For example, "inFolder=r'C:\1 est'" has only one database connection which is u'C:\1\test\Urbab.sde', but when I run the script it displays it 9 times every time! I tried to run the script from the python window in the ArcMap and I also used PyScripter and both of them gives the same result. import arcpy, sys, os inFolder=r'C:\1 est' outFolder=r'C:\1 est2' print "Connecting to geodatabase" arcpy.env.workspace=inFolder arcpy.env.overwriteOutput=True for DBConn in inFolder: x=arcpy.ListWorkspaces("*","SDE") print x ‍‍‍‍‍‍‍‍‍‍‍ What might be the issue here? Thanks, Ahmad

RebeccaStrauch__GISP · Accepted Answer

The reason it is displaying 9 times, it is most likely because your

for DBConn in inFolder

loops thru each character of the inFolder path.

That is, if you replace the print X with print DBConn you would get (this is why you are printing the same X 9 times)

C
:
\
1
\
t
e
s
t

So, you will want to populate "x" prior to the loop, then do something like

for DBConn in x:

print DBConn