Microsoft KB Archive/139804

{|
 * width="100%"|

MSQuery: Cannot Open Saved Query for Oracle Data Source

 * }

-

The information in this article applies to:


 * Microsoft Query for Windows, version 1.0

-

SYMPTOMS
In Microsoft Query, if you attempt to open a saved query that uses an Oracle data source, you may receive the following error message:

ORA-09301: osncon: local kernel only supported in standard mode

CAUSE
This error occurs if you attempt to open a query for an Oracle database and Microsoft Query has not yet logged you on to that data source.

WORKAROUND
To work around this problem, use the following steps to log on to the server before you open the query (*.qry) file:


 * 1) Start Microsoft Query.
 * 2) On the File menu, click New Query.
 * 3) Click your Oracle data source and click the Use button.
 * 4) You will be prompted to log in. Type your user id and password and click OK.
 * 5) Click Close in the Add Tables dialog box.
 * 6) On the File menu, click Close Query. If you are prompted to save the query, click No.
 * 7) On the File menu, click Open Query. Click your .qry file and click OK.

STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

Additional query words: MSQuery ODBC

Keywords : xlquery

Version : WINDOWS:1.0

Platform : WINDOWS

Issue type :

Technology :