Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Biz Talk General > WCF LOB adapter...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 13567 of 13845
Post > Topic >>

WCF LOB adapter for oracle ...woes

by "Mike R" <noreplay@[EMAIL PROTECTED] > Jul 24, 2008 at 03:23 PM

This is a multi-part message in MIME format.

------=_NextPart_000_0006_01C8EDA1.3D343B90
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi All,

I've followed all the examples and I suspect I may have something wrong =
in my environment. =20

I'm in dev mode currently and have running:

XP sp2 with Oracle Express Edition, Oracle Client 10g with ODAC, Biztalk =
2006 R2 with LOB (just Oracle), service packs and hotfixes. Copied =
Oracle.Dataaccess.dll to gac etc....

I have setup a Net Manager service called ROME, and created an ODBC =
connection called ROME.  Both pass on test connection.=20

I read somewhere that the WCF adapter uses the ODAC .net libraries, how =
can I test these are working correctly.

Using the simple MS supplied sample I get the following message in the =
event log:

The adapter failed to transmit message going to send ****t =
"Send****t_SelectAccTable" with URL "oracledb://ROME". It will be =
retransmitted after the retry interval specified for this Send ****t. =
Details:"Microsoft.ServiceModel.Channels.Common.ConnectionException: =
ORA-1017: invalid username/password; logon denied ---> =
Oracle.DataAccess.Client.OracleException ORA-1017: invalid =
username/password; logon denied at=20



Thanks Again



Mike





------=_NextPart_000_0006_01C8EDA1.3D343B90
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.6000.16674" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2>Hi All,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I've followed all the examples and I =
suspect I may=20
have something wrong in my environment.&nbsp; </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I'm in dev mode currently and have=20
running:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>XP sp2 with Oracle Express Edition, =
Oracle Client=20
10g with ODAC, Biztalk 2006 R2 with LOB (just Oracle), service packs and =

hotfixes. Copied Oracle.Dataaccess.dll to gac etc....</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I have setup a Net Manager service =
called ROME, and=20
created an ODBC connection called ROME.&nbsp; Both pass on test =
connection.=20
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I read somewhere that the WCF adapter =
uses the ODAC=20
..net libraries, how can I test these are working correctly.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Using the simple MS supplied sample I =
get the=20
following message in the event log:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV>
<P><FONT face=3DArial size=3D2>The adapter failed to transmit message =
going to send=20
****t "Send****t_SelectAccTable" with URL "oracledb://ROME". It will be=20
retransmitted after the retry interval specified for this Send ****t.=20
Details:"Microsoft.ServiceModel.Channels.Common.ConnectionException: =
ORA-1017:=20
invalid username/password; logon denied ---&gt;=20
Oracle.DataAccess.Client.OracleException ORA-1017: invalid =
username/password;=20
logon denied at </FONT></P>
<P><FONT face=3DArial size=3D2></FONT>&nbsp;</P>
<P><FONT face=3DArial size=3D2>Thanks Again</FONT></P>
<P><FONT face=3DArial size=3D2></FONT>&nbsp;</P>
<P><FONT face=3DArial size=3D2>Mike</FONT></P>
<P><FONT face=3DArial size=3D2></FONT>&nbsp;</P>
<P><FONT face=3DArial size=3D2></FONT>&nbsp;</P></DIV></BODY></HTML>

------=_NextPart_000_0006_01C8EDA1.3D343B90--
 




 1 Posts in Topic:
WCF LOB adapter for oracle ...woes
"Mike R" <no  2008-07-24 15:23:35 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Fri Nov 21 14:47:26 CST 2008.