Board index Oracle

Question on Oracle7 ODBC Driver

Question on Oracle7 ODBC Driver

Post by Danie » Tue, 21 Jan 1997 04:00:00



Hi All,

I have a problem on using VB4.0(16 bit) connect Oracle7 through ODBC
Driver.
The version of ODBC Driver is 1.11.0005

I have designed a field 'A' with varchar2(2000), when this field 'A' has a
value with that length is over 255 Char., e.g. length(A) = 300.
When I open a dbSqlPassThrough recordset such as "Select A from tableA",
I can only capture the first 255 Char. of field 'A', the other is trimmed!

I don't know what's wrong in this case? But I can select the whole thing of
field 'A' when I was using ODBC Driver with version 1.11.0000.

Thanks very much if anyone can answer me!

Daniel

 
 
 
Top

1. Visual Basic/Oracle7 ODBC driver question

In designing a utility to load data into Oracle using Visual Basic as a
front end, problems arose in trying to read into the proper tables.  These
problems can be summarized in the following paragraphs, taken from Oracle7
ODBC Driver (Release January 1995) and Visual Basic 3.0 Documentation:

PROBLEMS WITH RUNNING A QUERY ON A USERNAME QUALIFIED TABLE VIEW:
When you type from any Visual Basic or Microsoft Access application,
select * from SCOTT.EMP, the query terminates with the following error
message, "Couldn't find 'USER.MDB'.  Error #3024".  Microsoft Corporation
is aware of this limitation with the application Visdata of Microsoft
Visual Basic 3.0.

PROBLEMS WITH SYNONYMS:
The JET layer is unable to distinguish between two objects of the same
name.  This raises problems with synonyms such as SYSTEM.EMP and
SCOTT.EMP.  Moreover, Oracle7 public synonyms are returned by the ODBC
driver as belonging to "PUBLIC".  Visual Basic does not display the owner
as PUBLIC.  This causes resolution conflicts between a synonym like
ALL_TABLES and SCOTT.ALL_TABLES.

Is there a fix or a work around to these problems?  Any solutions or
suggestions would be greatly appreciated.

2. Remote Server Synchronization

3. VB4 Front end to Oracle7 w/SQL*NET2 -- Need ODBC driver to support RDO

4. ANNOUNCEMENT: 3 SQLServer security tools and download site

5. Oracle7 - ODBC Driver (Small FAQ)

6. Progress Software Engineer

7. Installation of ODBC Drivers for Windows 95. Oracle7

8. Design question

9. 32-bit ODBC driver for Oracle7 on NT 3.5

10. Looking for old ODBC driver & ODBC question

11. Oracle ODBC driver instead of Microsofts ODBC Oracle driver

12. ODBC Error: Oracle7.2, ODBC, VB4.0, DAO, Jet 3.0


All times are UTC
Board index