Re: Oracle ODBC and Office 97

I had posted a similar query in another group. Larry Elkins was kind enough to mail me this link to a MS Knowledge base article: http://www.microsoft.com/kb/articles/q159/5/57.htm In effect the article says:
1. Define your Oracle DSN as a System DSN 2. Create a .dsn file using a text editor. (MSQuery only uses or sees file-type DSNs. The format/contents of the file:

          ODBC
DSN=theNameOfYourSystemDSN
3. Save the file as: "theNameOfYourSystemDSN.dsn". Use the quotes when saving, otherwise Windows95 will mangle the name and you'll loose the extention. Save the file, for convenience, in the default location under Program Files\Common Files\ODBC\DSN, although this is not likely required. 4. Bring up MSQuery and you should find the DSN listed by the create query wizard.
Thanks again to Larry; he went through a lot of pain and time to get this one. Regards. ...edn

 Carlos Palomino wrote in article <3356FBE4.1FB2_at_spin.com.mx>...
>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
>
Received on Tue Apr 22 1997 - 00:00:00 CDT