ODBC RDO Oracle7 Outer Join Causes Error

We are working with a Visual Basic reporting tool that does not
(yet) support Objects for OLE but offers instead DAO, OLE DB, and
RDO connectivity options. We have run into a little RDO / ODBC mystery. Maybe someone can identify the cause or has seen this before? We're using Oracle 2.05.0301 ODBC driver.

This query works fine and returns an intact recordset:

        select id, notes from myschema.T1

Note: column 'notes' is defined as VARCHAR2(2000).

But this query fails to return just the 'notes' column; all other columns are returned as part of the recordset:

	select id, notes, team
	from myschema.T1, myschema.T2
	where T1.TeamID = T2.TeamID(+)

Note the use of the "(+)" operator. The problem seems to be related to the combination of a large varchar2 column (2000) and an outer join. Other columns in T1 (dates, smaller varchar2 columns, numbers) are all returned successfully by both queries. It's just this big varvhar2 column that fails in the second query.

Here's a snippet from the ODBC Trace log (table names were changed above for simplicity):

acmm c6:be EXIT SQLErrorW with return code 0
(SQL_SUCCESS)

		HENV                0x00ed5d00
		HDBC                0x00ed5100
		HSTMT               0x00000000
		WCHAR *             0x0012f21c (NYI) 
 		SDWORD *            0x0012f4c0 (0)
		WCHAR *             0x0012ee1c [     132] "[Microsoft][ODBC
Driver Manager] Driver's SQLSetConnectAttr failed"
		SWORD                     1022 
		SWORD *             0x0012f4d2 (132)

acmm            c6:be	EXIT  SQLError  with return code 0


(SQL_SUCCESS)


		HENV                0x00ed5d00
		HDBC                0x00ed5100
		HSTMT               0x00000000
		UCHAR *             0x0012f4ac (NYI) 
 		SDWORD *            0x0012f4c0 (0)
		UCHAR *             0x0012f264 [      66] "[Microsoft][ODBC
Driver Manager] Driver's SQLSetConnectAttr failed"
		SWORD                      511 
		SWORD *             0x0012f4d2 (66)

Thanks,
Tim
tim_at_ot.com Received on Wed Nov 04 1998 - 08:11:23 CST