THANK YOU!! - that was my fix for not being forced to use the Oracle OleDB -
"Matt Man" <matt.mcdonnell.90_at_bc.edu> wrote in message
news:b4aef96e.0203280617.72be11fd_at_posting.google.com...
> Well.... This is why we kindly refer to MS as M$ and a bunch of other
> things that I'm not comfotable putting on a newsgroup.. :-P
>
> Turns out this is a known problem that actually has been posted here
> before.. I just couldn't find it until this morning. There were
> missing registry settings that the MDAC installer doesn't
> automatically add
(http://support.microsoft.com/default.aspx?scid=kb;en-us;Q264012)
>
> Furthermore, once the changes are made, the OLE DB won't work until
> you've connected at least once using ODBC. (I KNEW they were
> related!) Perhaps someone at M$ can explain THAT one!
>
> Thanks for all your help.
>
>
> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:<3ca2f97a$0$231$ed9e5944_at_reading.news.pipex.net>...
> > "Matt Man" <mattmcdonnell_at_directvinternet.com> wrote in message
> > news:3ca2f8ec$1_3_at_nopics.sjc...
> > > Well.. .that was sort of another question that I had. The code works
fine
> > > for an 8.0.5 server, so I'm wondering if there's something else...
but
> > I'm
> > > not sure where to look.
> >
> > The format for the connection string that TurkBear gave also works fine
for
> > an 8.1.7db I know because I use it. You can also substitute the oracle
oledb
> > provider name if you wish. what error message do you get?
> >
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> > *****************************************
> > Please include version and platform
> > and SQL where applicable
> > It makes life easier and increases the
> > likelihood of a good answer
> >
> > ******************************************
Received on Thu Mar 28 2002 - 12:11:01 CST
