Last post Oct 02, 2012 04:34 PM by Lugnut
Oct 02, 2012 12:25 PM|Lugnut|LINK
Is there any reason I can not or should not use native oracle instead of ODBC?
Locally my reports loads fine, but once moved to Server I get DB Login failed. I confirmed that Oracle NetMgr on both machines mathc exactly with report. I can only assume there is a permission thing to Oracle that I dont know about. Has anyone else had
to deal with this?
Oct 02, 2012 04:28 PM|bcanonica|LINK
Did you try setting up and ODBC connection for Oracle. Please view answer in this thread for how to set that up.
Oct 02, 2012 04:34 PM|Lugnut|LINK
I have countless papers on how to do it, but remember I have it working locally just fine. I am checking AGAIN....my Oracle Client to see if there are any issues as to why it works locally but not Server Side. I did a test that might seem obvious to some
but not for me. I made a crystal report that had no data source, just a text box with "This is a Test' in it. I though that was a good idea to rule out that crystal was properly installed on Server and IIS was running good as well. Now I know it is the Oracle