ADOCOnnection Failed with ASP.NET
Hi All,
I have some problem with ADOConnection and ASP.NET.
I am using the DLL files (created from C#.NET, Microsoft .NET Framework 1.0) in ASP.NET pages.
In one DLL file I am executing the EXE file through System.Diagnostics.ProcessStartInfo Class method.
The EXE is developed in VB6.0. In that EXE I am creating ADOConnection Object with Oracle Data base(Oracle 9i)
by using OraOLEDB.Oracle provider. In my development machine there is no any problem,ASP.NET page can able to
use the method in the DLL file and that DLL can successfully execute the VB6.0 exe file,every thing is working fine.
I deployed my DLLs,ASP.NET all related programs in production server.
The ASP.NET page failed to use the VB6.0 program. I found that VB6.0 exe failed to Open ADO Connection.
But If I use the VB6.0 exe in command prompt its working fine. Problem is it is not working when it is
used with ASP.NET pages.
Note: Execute privileges granted to ASPNET account has the on the dll, exe's .
Pls see the error when its used through ASP.NET pages ( in command prompt no error, working fine)
Error Number:-2147217915, Error Message : Object was open.
Used Connection parameters for ADO Connection
Provider = "OraOLEDB.Oracle"
Oracle Service,User name,Password
Then I tried to use Microsoft OLE DB Provider, but no use I am getting the following error.
Error : 2147467259-[Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed
If I use Oracle ODBC Driver from Microsoft-
Error : 2147467259-[Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed
But all these connection methods are working fine in my development machine (in ASP.NET pages).
Development Enviornment
=======================
Windows 2000 Professional SP 2
Microsoft Visual C# .NET
Microsoft .NET Framework 1.0 , Version 1.0.3705
SQL * Plus client - Release 8.1.7.0.0
Server: Oracle9i Release 9.2.0.1.0
Production Enviornment
=======================
Windows 2000 Advanced Server SP 2
Microsoft .NET Framework 1.0 , Version 1.0.3705
SQL * Plus client - Release 9.2.0.1.0
Server: Oracle9i Release 9.2.0.1.0
Help me to solve this issue.
Thanks in advance.
Sugumar
Email: [email protected]
