Microsoft KB Archive/150549

= PRB: Connecting to Oracle Server Fails with Several Files Open =

Article ID: 150549

Article Last Modified on 10/15/2003

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition
 * Microsoft Visual FoxPro 3.0b Standard Edition
 * Microsoft Data Access Components 2.5

-



This article was previously published under Q150549



SYMPTOMS
When using the 16-bit Oracle 7 ODBC driver (Sqora7.dll version 1.11.0000) that ships with Visual FoxPro to connect to an Oracle 7 server, the connection fails with the following error message:

Connectivity Error [Microsoft][ODBC DLL] Driver's SQLSetConnectOption failed



CAUSE
This error occurs because there are a lot of files (programs, projects, tables, and so on) open in Visual FoxPro when you attempt to establish a connection to the Oracle server.



RESOLUTION
Close some of the files prior to making the connection to the Oracle server. This problem does not occur in the 32-bit Oracle 7 driver provided by Visigenic Corporation.

NOTE: As of 12/9/98, Visigenic Corporation has been acquired by INPRISE, Inc.

For information about how to contact INPRISE, Inc., query in the Microsoft Knowledge Base for one of the following articles:

65416 Hardware and Software Third-Party Vendor Contact List, A-K

60781 Hardware and Software Third-Party Vendor Contact List, L-P

60782 Hardware and Software Third-Party Vendor Contact List, Q-Z



Steps to Reproduce Behavior
 Open several program files in Visual FoxPro. The actual number may vary, but typically between eight and ten files reproduces the error.  Type the following command in the Command window: ?SQLConnect   Choose the ODBC data source for the Oracle server, and click OK.

A -1 is displayed on the Visual FoxPro desktop, indicating that the connection failed. To see the actual error message, type the following commands in the Command window: ?AError(aerrs) DISPLAY MEMORY LIKE aerrs The text of the error message is displayed on the Visual FoxPro desktop. 

Additional query words: VFoxWin

Keywords: kbprb kb3rdparty KB150549

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.