Thanks Stephen! 💡
You point out about authentication trusted property of the biztalk host, and i really think that causes my problem. I just read the documentation and it seems that the default host that i uses, is an untrusted host by intallation setting default. So i beleive that i need to create a seperate host in this case.
The Oracle Adapter uses a System DSN, but there’s only user name but no passwd setting in ODBC, the only place where i can set oracle passwd is at the tranportation properties of the send port. But here you have another choice to use a single sign-on user so theorically i don’t have to set a user name/passwd here.
Will let you know whether it works…