Using direct connect with ArcGIS 9.3.1 and Oracle10g I'm getting an error stating my Server library could not be loaded. See attached word document. The connection using sqlplus works just not though ArcGIS.
Windows generates a "file not found message" when a DLL search returns the wrong bit-size library. Is your Oracle 64-bit? If so, you'll need a 32-bit install for ArcGIS. If 32-bit is installed, does it come *before* 64-bit in the PATH variable? Make sure you've got SP2 installed, or you may run into an issue with 32-bit and 64-bit connections on the same server. Those of us without Word on our home PCs would be able to see a JPEG or PNG attachment. - V
Sorry about the file type. I've attached a jpg version.
Yes the Server is Oracle64-bit on a Windows Server 2003 box. ArcGIS 9.3.1 and the Oracle 10.0.2client are installed on a 32-bit vista box. I have 20+ setups with the same configuration with no problems untill this happened. This just started happening to one PC the other day after running 24/7with no problems for 10 months.
I think I might just have a corrupt OCI.dll file on the PC. I would like to just re-register the dll, but it looks like I'll have to do a complete re-install of ArcGIS.