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
Additional query words: VFoxWin
Keywords: kbprb kb3rdparty KB150549