|
Michael -> Database Adapter for Oracle on 64bit Windows (29 June 2006)
|
Hi
I'm trying to get the Database Adapter for Oracle (version 3.1.3) to work in BizTalk 2006 on a Windows Server 2003 Standard x64 Edition. I'm using the Microsoft .NET Data Provider for Oracle Version 2.0.0 as data provider and a 32bit Oracle client. The installation of the Adapter seems to be okay. It is installed in the x86 program files folder, so I suppose it runs in 32bit using WOW64.
When I add a receive location in a 32bit only host using the BizTalk Administration Console everything seems okay, and the test connection succeeds. But when I add a generated item in Visual Studio the test connction in Data Link properties dialog fails saying:
"Test connection failed because of an error in initializing Provider. ORA-06413: Connection not open."
When I run an application that uses the Database Adapter I get the error listed below in the event log.
Have anyone got the Database Adapter working on a 64bit Windows either in 32bit or 64bit mode?
Regards
Michael
---
BTSUtils.Core.EnterpriseInstrumentation.Schema.ErrorMessageEvent
{
String Message = "An Exception occurred attempting to submit a Message to the Database Transport.
System.Data.OracleClient.OracleException
ORA-12154: TNS:could not resolve the connect identifier specified
"
|
|
|
|
