ArcPy.DA runs on 32 bit not 64

[EricFulcher1]

So the following script worked on Arcpy 32 bit but not on 64 bit IDLE. Any thoughts? 10.6.1 arcgis. 

ALSO - this works against an fgdb but not an enterprise geodatabase (Oracle).

Thanks,

Eric

arcpy scripting‌

--- Script

import arcpy

arcpy.env.workspace = "D:/WOBufferScripts/GLSVDEVL@GLS.sde"

arcpy.da.SearchCursor("GLS.MWO", ['SHAPE@'], "OBJECTID > 0")

print "It Worked"

--- 32 Bit Results

32 BIT

Python 2.7.14 (v2.7.14:84471935ed, Sep 16 2017, 20:19:30) [MSC v.1500 32 bit (Intel)] on win32

Type "copyright", "credits" or "license()" for more information.

>>>

================== RESTART: D:\WOBufferScripts64bit\test.py ==================

It Worked

>>> 

--- 64 Bit Results

64 bit

Python 2.7.14 (v2.7.14:84471935ed, Sep 16 2017, 20:25:58) [MSC v.1500 64 bit (AMD64)] on win32

Type "copyright", "credits" or "license()" for more information.

>>>

================== RESTART: D:\WOBufferScripts64bit\test.py ==================

Traceback (most recent call last):

  File "D:\WOBufferScripts64bit\test.py", line 4, in <module>

    arcpy.da.SearchCursor("GLS.MWO", ['SHAPE@'], "OBJECTID > 0")

RuntimeError: cannot open 'GLS.MWO'

[JoeBorgione]

I don't have an answer but when it comes to cursors, I like to set up a variable for the feature class or table name that you are cursoring through:

fc = r'D:/WOBufferScripts/GLSVDEVL@GLS.sde/GLS.WMO'
arcpy.da.SearchCursor(fc, ['SHAPE@'], "OBJECTID > 0")‍‍

[EricFulcher1]

um so do I. simplified the code to 3 lines to isolate the issue.

[DanPatterson_Retired]

It was a while ago, but didn't you have to install python for Background Geoprocessing to get 64 bit arcpy?

[EricFulcher1]

I have both 32 and 64 bit installed. the results are from each on the same server.

[JoshuaBixby · Accepted solution]

You likely have a configuration issue with your 64-bit Oracle client.  Make sure both your 32-bit and 64-bit Oracle clients are installed and configured properly.

[EricFulcher1]

Correct sir! - I had forgotten to put tnsnames in the 64 bit directory