Hi,I have BizTalk application which calls a .net assemblly. This .NET assembly using OracleDataAccess to connect to database. I am getting the folliwng error when I drop the file in the receive port location.Oracle.DataAccess.Client.OracleException ORA-12154: TNS:could not resolve the connect identifier specified at Oracle.DataAccess.Client.OracleException.HandleErrorHelperI thought it is TNS/Oracle issue. However it is not oracle issue. I wrote a small .net app to call the same assembly and same method. It works fine no issue atall. This biztalk application works fine in development server. Development server has VS 2005 that where I developed this biz app. I created MSI file of this biztalk application and installed on prod. It is not working there. I have all dll in right places. My development and prod servers are similar except prod doesn't have VS 2005. It just have BizTalkI am running Windows 2003 R2 64 bit. BizTalk is 2006 R2 -32 bit. Oracle client is 32 bit. .NET application Platfrom target : x86There is no issue in using OracleAdaptor in biztalk send port. In GAC, Processor Architecture for BizTalk Application dlls is MSIL and .NET is x86. Please help me to fix this issue.
Hi,
When you installed BizTalk on your production server, VS 2005 should have been one of the components installed, as part of the installation process, I don't understand why it was bypassed.
The other thing is check to see if you have the correct version of ODP adapter installed on that machine.
Daniel.
"Google skills are more important than your coding skills."
You don't need VS2005 installed on a production server. It is generally considered a bad idea to have development software on your production servers.
You should be able to use TNSPing to check the TNS config on the production server (http://www.orafaq.com/wiki/Tnsping)
If this works then you need to check the versions of ODP.NET on the development and production servers