 Forum main
page
Most
active member
Login page
Register
Log out
Search page
Information Online
View our event calendar
Add general event such as an upcoming
software release or conference
View all birthdays
Public image gallery
Upload your images in your profile
Profile editing page
Subscription list page
Address book page
Member list page
View the
most active member
User groups listing
Private message page
|
|
Users viewing this topic: none
|
|
Login  | |
|
Database Adapter for Oracle on 64bit Windows - 29 June 2006
|
|
|
Michael
Posts: 3
Score: 0
Joined: 29 June 2006
Status: offline
|
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
"
|
|
|
|
|
RE: Database Adapter for Oracle on 64bit Windows - 2 July 2006
|
|
|
Pieter
Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline
|
The test connection functionality simply creates a new Oracle Connection object and attempts to connect.
This sounds strange.
Can you connect with anything else from the BizTalk Server?
_____________________________
Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.
|
|
|
|
RE: Database Adapter for Oracle on 64bit Windows - 5 July 2006
|
|
|
Michael
Posts: 3
Score: 0
Joined: 29 June 2006
Status: offline
|
This turned out to be a problem with the Oracle 32bit Client (version 10.2.0.1) when running an application from the folder "Program Files (x86)" that contains parenthesis. This issue is Oracle bug 3807408 and can be fixed by applying 10.2.0.1 Patch 6. This can be downloaded from MetaLink if you have an account:
http://updates.oracle.com/ARULink/PatchDetails/process_form?patch_num=5059238
Regards
Michael
< Message edited by Michael -- 6 July 2006 >
|
|
|
|
|
RE: Database Adapter for Oracle on 64bit Windows - 6 July 2006
|
|
|
Pieter
Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline
|
Is this patched in the 400 release of the driver?
_____________________________
Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.
|
|
|
|
|
RE: Database Adapter for Oracle on 64bit Windows - 6 July 2006
|
|
|
Michael
Posts: 3
Score: 0
Joined: 29 June 2006
Status: offline
|
I have not heard of any 400 release of the Oracle client, so I am not able to answer your question.
|
|
|
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version
Email TopXML