Re: Error using JET_SCHEMA_USERROSTER

From: Val Mazur (group51a_at_hotmail.com)
Date: 10/11/04 

Date: Sun, 10 Oct 2004 22:55:37 -0400

Hi,

I would say that if your application is able to open connection, then it
looks like Jet 4.0 is installed. But it is possible that version of the Jet
4.0 (I mean actual version of DLL file) is different. You could check
msjet40.dll file to see what is the actual version. You could install Jet
4.0 separately. Check next link how to do it

http://support.microsoft.com/default.aspx?scid=kb;en-us;239114 

-- 
Val Mazur
Microsoft MVP
"M Smith" <msmith@avma.org> wrote in message 
news:ONondGUrEHA.1204@TK2MSFTNGP12.phx.gbl...
> So are you saying that the Microsoft Jet 4.0 OLE DB Provider might not be
> installed on the production machine?  If not, how do I distribute the
> Microsoft Jet 4.0 OLE DB Provider.  If I remember correctly, it's no 
> longer
> included in anything above MDAC 2.1.
>
> "Val Mazur" <group51a@hotmail.com> wrote in message
> news:%23rtEH8NrEHA.3428@TK2MSFTNGP11.phx.gbl...
>> Hi,
>>
>> Based on error message I would say that version of provider, which you
> have,
>> does not support this functionality and does not return any information
> for
>> the specified SchemaID. Another potential issue is the SchemaID is
> different
>> for this version of provider. The issue here is the
> adSchemaProviderSpecific
>> is not a required option, which each OLEDB provider suppose to support 
>> and
>> it is not a reliable way.
>>
>> -- 
>> Val Mazur
>> Microsoft MVP
>>
>>
>> "M Smith" <msmith@avma.org> wrote in message
>> news:%23iIKaiHrEHA.536@TK2MSFTNGP11.phx.gbl...
>> >I want to count the number of users who are currently connected to a
>> > specific Access 2000 database.  I'm using the code below in a form
> inside
>> > the database.  It works on my development machine but it does not work
>> > when
>> > I try to implement it at a different location.
>> >
>> > Dim intUsers As Integer
>> > Dim rst As ADODB.Recordset
>> > Const JET_SCHEMA_USERROSTER = "{947bb102-5d43-11d1-bdbf-00c04fb92675}"
>> >
>> > Set rst = CurrentProject.Connection.OpenSchema(
> adSchemaProviderSpecific,
>> > ,
>> > JET_SCHEMA_USERROSTER)
>> >
>> > Do Until rst.EOF
>> >    intUsers = intUsers + 1
>> >    rst.MoveNext
>> > Loop
>> > rst.close
>> > Set rst = Nothing
>> >
>> > When I try to run it in production at a different location I get an
> error
>> > that says: "3251 Object or Provider is not capable of performing
> requested
>> > operation".  My development machine is Win 2000 and production is XP 
>> > SP2
>> > with Access 2000 already loaded on it.  Does anyone have any insight on
>> > this.
>> >
>> > Thanks
>> >
>> >
>>
>>
>
>

Relevant Pages

  • Re: Missing MS Jet OLE DB Provider
    ... Yup, I tried to install this Jet 4 update, but the installation states my ... > How to obtain the latest service pack for the Microsoft Jet 4.0 Database ... >> Jet OLE DB Provider listed yet if I download the latest Jet update or MDAC ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Application using Jet provider
    ... Just looking at the latest Installshield module for Jet ... Is there a different provider inside the MDAC 2.7 or ... stop including the Jet drivers in the Data Access Components install? ... variations of Jet which is probably why they removed it from the MDAC package a few versions ago. ...
    (microsoft.public.vb.database)
  • Re: Application using Jet provider
    ... Just looking at the latest Installshield module for Jet ... Is there a different provider inside the MDAC 2.7 or ... stop including the Jet drivers in the Data Access Components install? ... variations of Jet which is probably why they removed it from the MDAC package a few versions ago. ...
    (microsoft.public.vb.database.ado)
  • Re: Provider cannot found
    ... When I check the install log for the Jet SP8.0 install, it's full of errors, so I assume that it doesn't work ... The Jet provider is in the registry and I can register and unregister the MSJETOLEDB40.DLL file OK ...
    (microsoft.public.data.ado)
  • Re: Application deployment with Jet Database 4.0
    ... Basically you would install Jet in the same way as MDAC: ... exe that will launch the Jet setup before launching your msi. ...
    (microsoft.public.dotnet.framework.setup)