Microsoft KB Archive/295398

= PRB: Error in Remote View Wizard When Connecting to DB2 =

Article ID: 295398

Article Last Modified on 4/12/2001

-

APPLIES TO


 * Microsoft Visual FoxPro 6.0 Professional Edition

-



This article was previously published under Q295398



SYMPTOMS
When you use the Visual FoxPro Remote View Wizard to connect to a DB2 database using the DB2 Run-time Client driver version 7.01, the following error message may appear after choosing the DB2 ODBC data source:

The Remote View Wizard was unable to obtain column information for this remote table. This may be the result of an ODBC error or the remote table may not be owned by the current user or the table doesn't have columns.

Note that this error may also occur with the 7.01 versions of the Administration Client and the Application Development Client driver.



RESOLUTION
To work around this problem, use one of the following three options:
 * Create the remote view using the View Designer.
 * Create the remote view using SQLPassThrough code.
 * Use the 6.01 version of the DB2 driver.



Steps to Reproduce Behavior

 * 1) Install version 7.01 of the DB2 Run-time ODBC driver.
 * 2) Create a database container. Choose New Remote View from the Database menu pad.
 * 3) In the New Remote View dialog box, click View Wizard.
 * 4) In the Available Data Sources list box, select the ODBC data source for your DB2 Server and click Next.

The error listed in the &quot;Symptoms&quot; section appears. Although the Remote View Wizard continues to step 2, clicking any field causes the error to reappear.

