Bug #12785 ODBC Only Shows First Table
Submitted: 24 Aug 2005 14:07 Modified: 8 Mar 2007 1:17
Reporter: Aaron Edwards Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / ODBC Severity:S2 (Serious)
Version:3.51 OS:Windows (Windows)
Assigned to: Bogdan Degtyariov CPU Architecture:Any
Tags: ODBC5-RC

File: Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

[2 Sep 2005 15:50] Aaron Edwards
Bug 12785 Sample Data

Attachment: NNSampleData.txt (text/plain), 8.67 KiB.

[2 Sep 2005 16:08] Aaron Edwards
Screenshot of view in Query Browser

Attachment: 1. vw_Proposals in Query Browser.jpg (image/pjpeg, text), 95.02 KiB.

[2 Sep 2005 16:09] Aaron Edwards
Screenshot of view in Access/ODBC - Broken (Bug 12785)

Attachment: 2. vw_Proposals in Access-ODBC.jpg (image/pjpeg, text), 154.42 KiB.

[14 Sep 2005 13:18] Bogdan Degtyariov
DB dump creates a database db12785, tables and views

Attachment: dump12785.sql (text/plain), 15.43 KiB.

[16 Sep 2005 14:32] Aaron Edwards
ODBC info for a linked view.  The last pair, TABLE=tblopportunities is what I think is causing the problem.

Attachment: Access showing ODBC info.jpg (image/pjpeg, text), 94.90 KiB.

[16 Sep 2005 19:22] Aaron Edwards
ODBC info for productscategories view

Attachment: productscategoriesODBCInfo.jpg (image/pjpeg, text), 97.24 KiB.