i wrote a ASP.NET application which call a storeed procedure in Oracle 11G On my system, windows 10 that works perfect, the code to connect look like this:
Imports Oracle.DataAccess.Client
Dim s As String = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myserver)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl)));User Id=HR;Password=test;"
dim oradb as String = s
Dim conn As New OracleConnection
conn.ConnectionString = oradb
conn.Open()
When a distribute this to my customer, windows server 2008RS i get a System.NullReferenceException by conn.open()
For testing a wrote windowsapplication with exactly the same code and that's works fine.
Anybody a idea why it not work as a web application?
Thanks for help Dani