M
Magnus Strandberg
Hello,
We are developing a WEB - application in .NET to be hosted on a Windows 2000
Server platform.
Internally we need to create and use an (Interop) ADODB.Recordset. We do
this with the following code:
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
using ADODB;
......
ADODB.Recordset oRS = new Recordset();
.....
oRS.Fields.Append(...)
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
(we have tried ADODB.RecorsetClass oRS = new RecordsetClass() as well -
works fine on the development machine, not on the server)
When we try to access the fields collection with the Append method, we get
the following error: "object reference not set to an instance of an object".
The code works just fine on the development machine (Windows XP Prof. SP2
with MDAC 2.8 SP1, Framework 1.1.4322, VS.NET 2003) but generates the above
error on the webserver (Windows 2000 SP4 with MDAC 2.8 RTM, Framework
1.1.4322).
We noted that the ADODB.dll PIA (7.0.3300.0) was installed in the GAC on the
development machine; this assembly was not registered in the GAC on the
server. We tried installing the assembly to the server GAC, but that did not
help (although it removed error messages stating that the assembly ADODB.dll
could not be found).
Any ideas why we can't create and use the Recordset on the server?
Thanks!
/Magnus Strandberg and Peter Stenhjelm
We are developing a WEB - application in .NET to be hosted on a Windows 2000
Server platform.
Internally we need to create and use an (Interop) ADODB.Recordset. We do
this with the following code:
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
using ADODB;
......
ADODB.Recordset oRS = new Recordset();
.....
oRS.Fields.Append(...)
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
(we have tried ADODB.RecorsetClass oRS = new RecordsetClass() as well -
works fine on the development machine, not on the server)
When we try to access the fields collection with the Append method, we get
the following error: "object reference not set to an instance of an object".
The code works just fine on the development machine (Windows XP Prof. SP2
with MDAC 2.8 SP1, Framework 1.1.4322, VS.NET 2003) but generates the above
error on the webserver (Windows 2000 SP4 with MDAC 2.8 RTM, Framework
1.1.4322).
We noted that the ADODB.dll PIA (7.0.3300.0) was installed in the GAC on the
development machine; this assembly was not registered in the GAC on the
server. We tried installing the assembly to the server GAC, but that did not
help (although it removed error messages stating that the assembly ADODB.dll
could not be found).
Any ideas why we can't create and use the Recordset on the server?
Thanks!
/Magnus Strandberg and Peter Stenhjelm