From: "Ed Nixon" Subject: Re: Oracle ODBC and Office 97 Date: 1997/04/22 Message-ID: #1/1 Sender: news@mtnlake.com (Root) References: <3356FBE4.1FB2@spin.com.mx> <3357D9DD.38CD@consist.twinfo.nl> X-Mimeole: Produced By Microsoft MimeOLE Engine V4.71.0544.0 Organization: ENixon Newsgroups: comp.databases.oracle.tools,comp.databases.oracle.misc,comp.databases.oracle.server Odd, I'm having a similar problem. I've just downloaded and installed the ODBC drivers version 2.0.3.1.1 and I can't see an Oracle DSN from MSQuery97. When I try to define a new DSN via MSQuery97, I can find the Oracle73 driver but the connection fails. My situation is a bit different because I can see and use a DSN from other tools such as Borland BDE. I'm using Personal Oracle 7 with a 2: connect string. Any other thoughts would be appreciated. ...edn Victor Kroon wrote in article <3357D9DD.38CD@consist.twinfo.nl>... >Carlos Palomino wrote: >> >> Hi, >> I downloaded the ODBC driver for Windows 95 (32 bits) from the Oracle >> Site, and It just worked fine with VB 4.0 and Office 95. However when I >> installed Office 97 and tried to use Microsoft Query 97, the driver >> wouldn't load. Even with the testing tool provided with the Oracle ODBC >> driver I got the same results. >> I decided to replace the ODBC related files in the \WINDOWS\SYSTEM >> directory, that were updated when Office 97 installed, with the older >> ones that were there before that, and then the ODBC testing tool worked >> fine, but when I tried to access my Oracle database using Microsoft >> Query 97, I got the message: "Microsoft Query 97 won't work with an ODBC >> version prior to 3.0" (or something like that) >> >> Could anyone give me some advice? >> Thank you, >> >> Carlos > >Yes, download the new Oracle ODBC driver from there website (version >2.x) >The problem is the combination of the "old" Oracle ODBC drivers and the >"new" Microsoft ODBC driver (version 3.x). >I had the same problem and after installing the new Oracle ODBC driver >everything worked fin. The driver on the website is around 10 Mb. >Good lock. > >-- >Regards, > >Victor Kroon > _____________________________________________________ >| | >| E-mail : Victor.Kroon@consist.twinfo.nl | >| Webpage (Consist) : http://www.consist.nl | >| Telefoon (werk) : (030) 6026615 | >| (prive 1) : (0180) 621057 | >| (prive 2) (0180) 623222 | >|_____________________________________________________| >