Tuesday, March 6, 2012
AdoMd.Net 9.0 and AS2000
I'm trying to connect to AS2000 using AdoMd.Net 9.0 and I get the following
error:
{"Retrieving the COM class factory for component with CLSID
{B9776FC2-70D8-4664-A0DF-998114524D67} failed due to the following error:
80040154."}
Trying to connect using AdoMd.Net 8.0 (same code, same connection string)
works just fine.
Runtime version: v2.0.50727
AdoMd.Net version: v9.0.242.0
AS2000 version: SP4
I've read that AdoMd.Net 9.0 should be able to connect to AS2000 with no
problem. Can someone point me in the right direction?
Thanks a lot in advance,
E
Ok, figured it out.
The file msadomdx.dll was not in the 90 sub-directory of the AdoMd.Net main
directory.
Thanks.
"Elad" <elad&&&7690@.hot&&&mail.com> wrote in message
news:OwRgmilmHHA.3996@.TK2MSFTNGP06.phx.gbl...
> Hi,
> I'm trying to connect to AS2000 using AdoMd.Net 9.0 and I get the
> following error:
> {"Retrieving the COM class factory for component with CLSID
> {B9776FC2-70D8-4664-A0DF-998114524D67} failed due to the following error:
> 80040154."}
> Trying to connect using AdoMd.Net 8.0 (same code, same connection string)
> works just fine.
> Runtime version: v2.0.50727
> AdoMd.Net version: v9.0.242.0
> AS2000 version: SP4
> I've read that AdoMd.Net 9.0 should be able to connect to AS2000 with no
> problem. Can someone point me in the right direction?
> Thanks a lot in advance,
> E
>
adodb.connection > DBMS Name property equivalent in ADO.NET ...
Hi,
One of my team member was porting a Visual Basic function into VB.NET. We were struck up while retrieving the DBMS Name property from the connection object. Actually in VB, the ADODB.connection object's properties will have an item called DBMS Name which will hold the database name like "Oracle" , "Access" , "SQL Server" like that based on the database that I connect.
I wonder if there is any equivalent property in ADO.NET. The Server Version property of ODBCConnection object returns "8.0...." in case of SQL Server and returns "09.01.0000 Oracle9i Enterprise Edition Release 9.2.0.1.0" in case of oracle. This is not as precise as it's ADODB counterpart.
I'm hardly in need of a solution or workaround for this scenario. Can anybody help.
Thanks in advance.
Hi Prathap,
The .Net Framework Data Access and Storage forum is the best forum with which to seek your answer (I see that you've already posted this question there).
Il-Sung.