Re: jro.CompactDatabase stopped working

Tech-Archive recommends: Fix windows errors by optimizing your registry

It may be but I can't find anyway to download a new one or fix it.

"William (Bill) Vaughn" wrote:

> Nope, sorry. But isn't the JRO a separate DLL?
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com/blog/billva
> www.betav.com
> www.sqlreportingservices.net
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> __________________________________
>
>
> "PHanna" <phanna@xxxxxxxxxxxxx> wrote in message
> news:20636A6C-2AA6-4E02-962E-1CE011DC43BD@xxxxxxxxxxxxxxxx
> >I have run ComponentChecker and it says that it found MDAC 2.8 RTM and does
> > not show any errors. I have re-installed MDAC 2.8 and Jet 4.0 again today
> > just in case but to no avail. Any more ideas?
> >
> > Thanks
> >
> > "William (Bill) Vaughn" wrote:
> >
> >> Sounds like your MDAC stack has been updated somehow. I can only think of
> >> about a dozen ways this could happen if it's any consolation. Run
> >> ComponentChecker to see...
> >>
> >> --
> >> ____________________________________
> >> William (Bill) Vaughn
> >> Author, Mentor, Consultant
> >> Microsoft MVP
> >> www.betav.com/blog/billva
> >> www.betav.com
> >> www.sqlreportingservices.net
> >> Please reply only to the newsgroup so that others can benefit.
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >> __________________________________
> >>
> >>
> >> "PHanna" <phanna@xxxxxxxxxxxxx> wrote in message
> >> news:15603F22-4545-459B-8B63-7A1D0A2C84D0@xxxxxxxxxxxxxxxx
> >> >I have been using jro.compactdatabase in my VB.net application to
> >> >compact
> >> >my
> >> > access databases for some time. Two weeks ago i started getting the
> >> > following error on the CompactDatabase call:
> >> > System NullReferenceException
> >> > additional Information: Object reference not set to an instance of an
> >> > object.
> >> >
> >> > Here is the code that I am running:
> >> >
> >> > Dim jro As JRO.JetEngine
> >> > jro = New JRO.JetEngine
> >> > If File.Exists(FilePath.Split(".")(0) & ".CMP") Then
> >> > File.Delete(FilePath.Split(".")(0) & ".CMP")
> >> > End If
> >> > jro.CompactDatabase("Provider=Microsoft.Jet.OLEDB.4.0;
> >> > Password='';
> >> > User ID=Admin;
> >> > Data Source='P:\DemoDatabases\Carson LTD\MFG.mdb';
> >> > Mode=Share Deny None;
> >> > Extended Properties='';
> >> > Jet OLEDB:System database='';
> >> > Jet OLEDB:Registry Path='';
> >> > Jet OLEDB:Database Password='';
> >> > Jet OLEDB:Engine Type=5;
> >> > Jet OLEDB:Database Locking Mode=1;
> >> > Jet OLEDB:Global Partial Bulk Ops=2;
> >> > Jet OLEDB:Global Bulk Transactions=1;
> >> > Jet OLEDB:New Database Password='';
> >> > Jet OLEDB:Create System Database=False;
> >> > Jet OLEDB:Encrypt Database=False;
> >> > Jet OLEDB:Don't Copy Locale on Compact=False;
> >> > Jet OLEDB:Compact Without Replica Repair=False;
> >> > Jet OLEDB:SFP=False", _
> >> > "Provider=Microsoft.Jet.OLEDB.4.0;
> >> > Password='';
> >> > User ID=Admin;
> >> > Data Source='P:\DemoDatabases\Carson LTD\MFG.CMP';
> >> > Mode=Share Deny None;
> >> > Extended Properties='';
> >> > Jet OLEDB:System database='';
> >> > Jet OLEDB:Registry Path='';
> >> > Jet OLEDB:Database Password='';
> >> > Jet OLEDB:Engine Type=5;
> >> > Jet OLEDB:Database Locking Mode=1;
> >> > Jet OLEDB:Global Partial Bulk Ops=2;
> >> > Jet OLEDB:Global Bulk Transactions=1;
> >> > Jet OLEDB:New Database Password='';
> >> > Jet OLEDB:Create System Database=False;
> >> > Jet OLEDB:Encrypt Database=False;
> >> > Jet OLEDB:Don't Copy Locale on Compact=False;
> >> > Jet OLEDB:Compact Without Replica Repair=False;
> >> > Jet OLEDB:SFP=False"
> >> >
> >> > File.Delete("P:\DemoDatabases\Carson LTD\MFG.mdb")
> >> > File.Move("P:\DemoDatabases\Carson LTD\MFG.CMP", _
> >> > "P:\DemoDatabases\Carson LTD\MFG.mdb")
> >> >
> >> > I have tried changing out the ADODB reference from 2.8 to 2.7 and 2.6
> >> > with
> >> > no change. Any idea what has gone wrong?
> >> >
> >> > Thanks
> >> >
> >>
> >>
> >>
>
>
>
.

Relevant Pages