Cannot connect to Oracle using the database adapter: Requested value true was not found

BizTalk Utilities

Xselerator XSLT IDE

Forum main page

Most active member

Search page

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

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

Cannot connect to Oracle using the database adapter: Requested value true was not found

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 >> Cannot connect to Oracle using the database adapter: Requested value true was not found

Page: [1]

Message

<< Older Topic Newer Topic >>

Cannot connect to Oracle using the database adapter: Re... - 25 February 2008

mikaelsand

Posts: 3
Score: 0
Joined: 25 February 2008
Status: offline

In my organization, we use the Adapter for databases to access data on Oracle databases. This works fine for my coworkers but when I installed the newer version, new problems occured and noone can help me. "Works on my box".

I had to install a newer version because of recommendation from Enabler, since .net framwork 2.0 is installed on the machine.

In june 2006 another Top XML user had the exact same problem and posted about it: http://www.topxml.com/forum/m.asp?m=4288&mpage=1&key= but "he" did not receive any reply.

The problem is this. Whenever the adapeter tries to access data on the database I get the following error:
BTSUtils.Core.EnterpriseInstrumentation.Schema.ErrorMessageEvent
{
String Message = "An Exception occurred attempting to start an EndPoint. The Uri is 'database://Microsoft .NET Data Provider for Oracle/Persist Security Info=True;Password=xxx;User ID=xxx;Data Source=XXX;/YYY'

System.ArgumentException

Requested value true was not found."
Exception InnerException = {
     String HelpLink = ""
     String Message = ""
     String Source = ""
     String StackTrace = ""
     String TargetSite = ""
}
String ErrorCode = ""
Int32 Severity = 0
Int32 ProcessID = 5392
String ProcessName = "C:\Program Files\Microsoft BizTalk Server 2004\BTSNTSvc.exe"
String ThreadName = ""
ComPlusInfo ComPlus = {
     String ActivityID = ""
     String ApplicationID = ""
     String TransactionID = ""
     String DirectCaller = ""
     String OriginalCaller = ""
}
WindowsSecurityInfo WindowsSecurity = {
     String CurrentAccountName = "DOM\BizTalkServiceUser"
     String ProcessAccountName = "BUILTIN\Administrators"
}
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.Start()
   at BTSUtils.Core.Adapters.Receive.Asynchronous.Receiver.AddReceiveEndpoint(String bstrURL, IPropertyBag pConfig, IPropertyBag pBizTalkConfig)
   at BTSUtils.Core.Adapters.Receive.Asynchronous.Receiver.UpdateEndpointConfig(String bstrURL, IPropertyBag pConfig, IPropertyBag pBizTalkConfig)"
String EventSourceInstance = "5be97feb-18bb-4ae5-9777-dea46c700ae2"
String EventSourceName = "BizTalk Utilities Adapter for Databases Receiver"
Int64 EventSequenceNumber = 7
String EventSchemaVersion = "2.0.171.0"
DateTime TimeStamp = 2008-02-22 14:58:06
String AppDomainName = "DefaultDomain"
String MachineName = "MYMACHINE"
String RootRequestName = ""
String RootRequestInstance = ""
String RequestInstance = ""
String RequestName = ""
Int64 RequestSequenceNumber = 0
Int32 EventLogEntryTypeID = 1
}

This is a seriuos problem for me and I really need to be able to connect to Oracle databases.

Ofcourse I have tried the obvious ones like veryfying user name, password, basic access and so forth.

Nothing but love
//Mikael Sand
Sweden

Post #: 1

RE: Cannot connect to Oracle using the database adapter... - 25 February 2008

mikaelsand

Posts: 3
Score: 0
Joined: 25 February 2008
Status: offline

Well, I managed to "solve" it by myself.
What I did was to change the URI from the setting that was given to me, to the setting mentioned in the documentation, i.e. database://Provider/RootElement/RowElement.

Well, it worked so just to test it I changed it back to the old setting and it still worked.

Now I do not file this under solved but the problem is no more. I do not know why though.
//Mikael Sand
Sweden

(in reply to mikaelsand)

Post #: 2

RE: Cannot connect to Oracle using the database adapter... - 25 February 2008

Pieter

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline

You should not specify the connection string as part of the Uri, there are other properties for this.

_____________________________

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

(in reply to mikaelsand)

Post #: 3

RE: Cannot connect to Oracle using the database adapter... - 26 February 2008

mikaelsand

Posts: 3
Score: 0
Joined: 25 February 2008
Status: offline

That, is not for me to decide since I am just a simple consultant

but I have tried anyway.
However I will pass it on.

(in reply to Pieter)

Post #: 4

Page: [1]

All Forums >> [BizTalk Utilities] >> BizTalk 2004/2006 Utilities and Adapters >> Cannot connect to Oracle using the database adapter: Requested value true was not found

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