Re: MSDAORA and Oracle 8.1.7 - problems establishing connection

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 - 08:17:47 CST