1
Answer

oracle functions called from c# code

Administrator

Administrator

22y
5.3k
1
Hi, guys, as stated in the subject, I got some pl/sql - functions at an oracle database. that I should start. I do, of course, know, how to call a stored procedure or commit commands directly, but I really got no idea, how to use a function. I can neither find information on this subject at MSDN nor elsewhere. I also tried several drivers, but neither Microsoft Oracle Driver nor ODBC Driver made me happy. Any idea would be very appriciated from my side, as I´m quite stuck, and the work is urgent, as every in this job. Thank you, Gilthanas
Answers (1)
0
Thomas J

Thomas J

NA 21 15.5k 13y
I think it's 4.0. If i check the IIS manager the connection fails when I click test connection. Authentication passes but Authorization fails with the message,

The server is configured to use pass-through authentication with a built-in account to access the specified physical path. However, IIS Manager cannot verify whether the built-in account has access. Make sure that the application pool identity has Read access to the physical path.

I can't find any settings to change the read access for the application pool identity or anything similar to that, I've looked at advanced settings and basic settings of the application pool but don't understand them that well.
0
Praneeth Kumar

Praneeth Kumar

NA 832 43.4k 13y
Did you create a Asp.Net 4.0 website? If yes then have you enabled the deployed website to use the .Net 4.0 Framework. By default it will be .Net 2.0.

Regards,
Praneeth