BizTalk Utilities Xselerator XSLT IDE


Forum main page

Most active member

Login/out

Login page
Register
Log out

Search

Search page

Events

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

Your details

Profile editing page
Subscription list page
Address book page

Membership info

Member list page
View the most active member
User groups listing
Private message page
TopXML Discussion Forum TopXML Discussion Forum

Forums  Register  Login  My Profile  Inbox  Address Book  My Subscription  My Forums 

Photo Gallery  Member List  Search  Calendars  FAQ  Ticket List  Log Out

System.Data.OracleClient requires Oracle client software version 8.1.7 or greater

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
  Printable Version
All Forums >> [BizTalk Utilities] >> BizTalk 2004/2006 Utilities and Adapters >> System.Data.OracleClient requires Oracle client software version 8.1.7 or greater Page: [1]
Login
Message << Older Topic   Newer Topic >>
System.Data.OracleClient requires Oracle client softwar... - 2 June 2005   
kovesdan

 

Posts: 5
Score: 0
Joined: 2 June 2005
Status: offline 		When I test the receive port walktrough scenario I get an error message:

Event Type: Error
Event Source: BizTalk Utilities Adapter for Databases Receiver
Event Category: None
Event ID: 0
Date:  6/2/2005
Time:  11:28:16 AM
User:  N/A
Computer: GYULAK03
Description:
BTSUtils.Core.EnterpriseInstrumentation.Schema.ErrorMessageEvent
{
  String Message = "An Exception Occurred attempting to retrieve Messages from the Uri 'database://Microsoft .NET Data Provider for Oracle/Adapterteszt/row'
System.Exception
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater."
  Exception InnerException = {
     String HelpLink = ""
     String Message = ""
     String Source = ""
     String StackTrace = ""
     String TargetSite = ""
  }
  String ErrorCode = ""
  Int32 Severity = 0
  Int32 ProcessID = 488
  String ProcessName = "D:\PROGRA~1\MICROS~4\BTSNTSvc.exe"
  String ThreadName = ""
  ComPlusInfo ComPlus = {
     String ActivityID = ""
     String ApplicationID = ""
     String TransactionID = ""
     String DirectCaller = ""
     String OriginalCaller = ""
  }
  WindowsSecurityInfo WindowsSecurity = {
     String CurrentAccountName = "GYULAK03\BTUser"
     String ProcessAccountName = "GYULAK03\BTUser"
  }
  ManagedSecurityInfo ManagedSecurity = {
     String IdentityName = ""
     String AuthenticationType = ""
     Boolean IsAuthenticated = False
  }
  String StackTrace = " at BTSUtils.Core.Adapters.EnterpriseInstrumentation.Helper.Error(EventSource EventSource, Exception Exception, String Message)
at BTSUtils.Adapters.Databases.Receive.EndPoint.Interval()
at BTSUtils.Core.Adapters.Receive.EndPoint.Base.Interval(Object State)"
  String EventSourceInstance = "18035e0c-a714-41ec-8fb7-d9cb82f4b80c"
  String EventSourceName = "BizTalk Utilities Adapter for Databases Receiver"
  Int64 EventSequenceNumber = 9
  String EventSchemaVersion = "2.0.102.0"
  DateTime TimeStamp = 2005.06.02. 11:28:16
  String AppDomainName = "DefaultDomain"
  String MachineName = "GYULAK03"
  String RootRequestName = ""
  String RootRequestInstance = ""
  String RequestInstance = ""
  String RequestName = ""
  Int64 RequestSequenceNumber = 0
  Int32 EventLogEntryTypeID = 1
}
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Post #: 1
RE: System.Data.OracleClient requires Oracle client sof... - 2 June 2005   
kovesdan

 

Posts: 5
Score: 0
Joined: 2 June 2005
Status: offline 		Additional info: Oracle 9i client installed properly. Oracle connection works well.

(in reply to kovesdan)
Post #: 2
RE: System.Data.OracleClient requires Oracle client sof... - 2 June 2005   
Pieter

 

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline 		It seems that there is something wrong with your Oracle Client Installation.

What version of Oracle are you attempting to connect to?

Also do the ODP.NET providers give you the same error message.

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to kovesdan)
Post #: 3
RE: System.Data.OracleClient requires Oracle client sof... - 2 June 2005   
kovesdan

 

Posts: 5
Score: 0
Joined: 2 June 2005
Status: offline 		Hmmm... I'm not an oracle familiar. I just installed an oracle 9i client (administrator type installation) from an oracle 9i database install kit.

(in reply to Pieter)
Post #: 4
RE: System.Data.OracleClient requires Oracle client sof... - 2 June 2005   
kovesdan

 

Posts: 5
Score: 0
Joined: 2 June 2005
Status: offline 		ODP.NET adpater hasn't been installed. Is it necessary to install?

(in reply to Pieter)
Post #: 5
RE: System.Data.OracleClient requires Oracle client sof... - 2 June 2005   
Pieter

 

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline 		Only when using the "Oracle Data Provider for .NET" provider.

Otherwise the Oracle Client will be sufficient when using the Microsoft Provider

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to kovesdan)
Post #: 6
RE: System.Data.OracleClient requires Oracle client sof... - 7 June 2005   
Pieter

 

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline 		What is the Oracle Database Version that you're trying to connect to?

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to Pieter)
Post #: 7
RE: System.Data.OracleClient requires Oracle client sof... - 21 June 2005   
kovesdan

 

Posts: 5
Score: 0
Joined: 2 June 2005
Status: offline 		Full database server of Oracle 9.2.0.1.0 has been installed to the BizTalk Server where the TOPXML adapter also has been installed. All component on the same machine: MS SQL Server 2000, BizTalk 2004 SP1, TopXML database adapter package.

Situation is the same:  

Event Type: Error
Event Source: BizTalk Utilities Adapter for Databases Receiver
Event Category: None
Event ID: 0
Date:  6/21/2005
Time:  4:37:17 PM
User:  N/A
Computer: GYULAK03
Description:
BTSUtils.Core.EnterpriseInstrumentation.Schema.ErrorMessageEvent
{
  String Message = "An Exception Occurred attempting to retrieve Messages from the Uri 'database://Microsoft .NET Data Provider for Oracle/Adapterteszt/row'
System.Exception
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater."
  Exception InnerException = {
     String HelpLink = ""
     String Message = ""
     String Source = ""
     String StackTrace = ""
     String TargetSite = ""
  }
  String ErrorCode = ""
  Int32 Severity = 0
  Int32 ProcessID = 4760
  String ProcessName = "D:\PROGRA~1\MICROS~4\BTSNTSvc.exe"
  String ThreadName = ""
  ComPlusInfo ComPlus = {
     String ActivityID = ""
     String ApplicationID = ""
     String TransactionID = ""
     String DirectCaller = ""
     String OriginalCaller = ""
  }
  WindowsSecurityInfo WindowsSecurity = {
     String CurrentAccountName = "GYULAK03\BTUser"
     String ProcessAccountName = "GYULAK03\BTUser"
  }
  ManagedSecurityInfo ManagedSecurity = {
     String IdentityName = ""
     String AuthenticationType = ""
     Boolean IsAuthenticated = False
  }
  String StackTrace = " at BTSUtils.Core.Adapters.EnterpriseInstrumentation.Helper.Error(EventSource EventSource, Exception Exception, String Message)
at BTSUtils.Adapters.Databases.Receive.EndPoint.Interval()
at BTSUtils.Core.Adapters.Receive.EndPoint.Base.Interval(Object State)"
  String EventSourceInstance = "4259ddd0-77ae-42c7-9c7f-37acf3c79a04"
  String EventSourceName = "BizTalk Utilities Adapter for Databases Receiver"
  Int64 EventSequenceNumber = 9
  String EventSchemaVersion = "2.0.102.0"
  DateTime TimeStamp = 2005.06.21. 16:37:17
  String AppDomainName = "DefaultDomain"
  String MachineName = "GYULAK03"
  String RootRequestName = ""
  String RootRequestInstance = ""
  String RequestInstance = ""
  String RequestName = ""
  Int64 RequestSequenceNumber = 0
  Int32 EventLogEntryTypeID = 1
}
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

(in reply to Pieter)
Post #: 8
RE: System.Data.OracleClient requires Oracle client sof... - 21 June 2005   
Pieter

 

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline 		This is a common problem with the Oracle Provider.

http://dotnetjunkies.com/WebLog/rtgurskevik/archive/2005/01/19/45958.aspx

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to kovesdan)
Post #: 9
Page:   [1]
All Forums >> [BizTalk Utilities] >> BizTalk 2004/2006 Utilities and Adapters >> System.Data.OracleClient requires Oracle client software version 8.1.7 or greater Page: [1]
Jump to:





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



Email TopXML

Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.438