locked
asp.net app + Oracle + Win Authentcation RRS feed

  • Question

  • User-39953368 posted

    Hi,

    I have donea bunch of apps with asp.net and SQL sever but now I have to do one using Oracle (11g) in conjunction with Windows authentication (an Intranet app). Can someone point me  in the right direction on how this can be accomplished (articles, How-Tos, ...), speifying prviders, etc.?

    Thanks.

    Tuesday, August 23, 2011 10:17 PM

Answers

  • User269602965 posted

    sometimes some minor modification of the queries and ODP.NET code is required as there are some minor differences between Oracle and MSSQL.

    For example

    WHERE MYKEY = :MYKEY

    Oracle used COLON symbol for the bind parameter designation.

    Intellitype in the .net code section usually helps with some Oracle ODP.NET specific ways of doing things.

    You might need some examples to get more acquainted.

    http://download.oracle.com/docs/cd/E11882_01/appdev.112/e10767.pdf

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, August 25, 2011 1:53 PM

All replies

  • User269602965 posted

    Forms authentication against the OS users you put into an application group

    to control their privileges.

    One step further is roles for app users

    and use the role for privileges.

    Pretty much in the same in Oracle as it is in MSSQL.

    http://download.oracle.com/docs/cd/E11882_01/win.112/e18737.pdf

    Wednesday, August 24, 2011 2:12 PM
  • User-39953368 posted

    Thanks Lannie. Is Windows authentication handles the same way? Do I need anythingelse aside from specifying authentication type in config file and setting up IIS properly?

    Wednesday, August 24, 2011 3:41 PM
  • User269602965 posted

    sometimes some minor modification of the queries and ODP.NET code is required as there are some minor differences between Oracle and MSSQL.

    For example

    WHERE MYKEY = :MYKEY

    Oracle used COLON symbol for the bind parameter designation.

    Intellitype in the .net code section usually helps with some Oracle ODP.NET specific ways of doing things.

    You might need some examples to get more acquainted.

    http://download.oracle.com/docs/cd/E11882_01/appdev.112/e10767.pdf

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, August 25, 2011 1:53 PM