CR2008 on 64 bit machine TNS connection error
I posted this in Business Objects General. Apparently that is the wrong place, so I am trying this again
I am running Windows Server 2003 64 bit and have installed Oracle 10.2.0 32 bit client as well as CR2008 w/SP0. I can TNS ping the database and I can log into the database with my program that accesses it, but when I try to connect with Crystal it gives me the TNS error "Could Not Resolve Connect Identifier Specified". So, I also tried setting up a 32 bit ODBC connection and I get the same error. I tried running with the 64 bit Oracle and get the same results. The database server is 32 bit Windows Server 2003.
Any help would be greatly appreciated.