Re: ADO Error 430 (automation) on some machines

From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 07/14/04 

Date: Wed, 14 Jul 2004 11:33:32 -0700

Ah the joys of DLL hell. Run component checker and verify that the registry
is setup correctly. 

-- 
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Simon Sunke" <REMOVE_THIS_TO_MAIL_simi@simitec.ch> wrote in message
news:2lk3jcFd8t9lU1@uni-berlin.de...
> Hi
>
> Thanks for your reply!
> Now I tried to install exactly the same MDAC version, on one workstation
it
> works now, on another, MDAC 2.8 RTM was already installed. I tried to
> reinstall it but it still does not work.
> I've re-programmed this code in a new workbook on this computer but this
> error still occurs!
>
> Simon
>
>
> "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> schrieb im
Newsbeitrag
> news:eyhEsUPaEHA.3012@tk2msftngp13.phx.gbl...
> > If they are not _exactly_ the same configuration, I think you'll
> experience
> > problems (like this). Run component checker on all systems to make sure
> > you're running the same MDAC stack. This utility can be found at
> > www.microsoft.com/data
> >
> >
> > -- 
> > ____________________________________
> > William (Bill) Vaughn
> > Author, Mentor, Consultant
> > Microsoft MVP
> > www.betav.com
> > Please reply only to the newsgroup so that others can benefit.
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > __________________________________
> >
> > "Simon Sunke" <REMOVE_THIS_TO_MAIL_simi@simitec.ch> wrote in message
> > news:2li23rFd86reU1@uni-berlin.de...
> > > Hello
> > >
> > > I'm using the following code to perform a SQL-Querry to a MSSQL
> database:
> > >
> > > ***
> > >     Dim oConn As ADODB.Connection
> > >     Dim oRS As ADODB.Recordset
> > >        Set oConn = New ADODB.Connection
> > >         oConn.CursorLocation = adUseClient
> > >         oConn.Open "Driver={SQL Server};" & _
> > >                    "Server=exchange;"
> > >
> > >         Set oRS = New ADODB.Recordset
> > >         oRS.Open "SELECT * FROM ...)", oConn, adOpenStatic,
> > adLockOptimistic
> > >
> > >         ...
> > > ***
> > >
> > > Now, on some Machine, an ADO 430 error (class does not support
> > > automation...) occurs, but on some other machines this code runs
through
> > > perfectly!
> > > Why is this? I think ADO reference ist set up correctly and all are
> about
> > > the same configuration (Office XP, MDAC 2.7)
> > >
> > > Can anyone help me on?
> > >
> > > Thanks
> > >  Simon
> > >
> > >
> >
> >
>
>

Relevant Pages