FIX: Outer Join Syntax with Parameter Fails Against SQL Server 6.5 (294138)

MORE INFORMATION

Steps to Reproduce Behavior

1. Create the following tables on a SQL Server 6.5 back end:

   create table t1(c1 int, c2 int)
   create table t2(c1 int, c2 int)
   					

2. Paste the following code in a Microsoft Visual C++ console application:

   #include <windows.h>
   #include <stdio.h>
   #include <stdlib.h>
   #include <stdio.h>
   #include <sql.h>
   #include <sqlext.h>
   
   void main(void)
   {
      	SQLHANDLE henv;
      	SQLHANDLE hdbc;
      	SQLHANDLE hstmt;
      	RETCODE rc;
   
      	char Statement[100] = {"select * from {oj t1 left outer join t2 on t1.c1=t2.c2} where t1.c1=?"};
      	char dsn[10] = {"YourDSNName"};
      	char user[5] = {"YourUserName"};
      	char pass[7] = {"YourPassword"};
   	int param =1;
      	long sqlnts = SQL_NTS;
      	long m_bytesRet = SQL_NTS;   	
   	long cbOparm = 0;
      	
   	rc = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &henv);
   	rc = SQLSetEnvAttr(henv,SQL_ATTR_ODBC_VERSION,(SQLPOINTER)SQL_OV_ODBC3, SQL_IS_UINTEGER);
   	rc = SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc);
   	rc = SQLConnect(hdbc, (SQLCHAR *)dsn, SQL_NTS, (SQLCHAR *) user,SQL_NTS,(SQLCHAR *) pass, SQL_NTS);
   	rc = SQLAllocHandle(SQL_HANDLE_STMT,hdbc,&hstmt);  	
   	rc = SQLBindParameter(hstmt, 1, SQL_PARAM_INPUT, SQL_C_SLONG,SQL_INTEGER, 0, 0,&param, 0, &cbOparm);	
   	rc = SQLPrepare(hstmt, (SQLCHAR *)Statement, SQL_NTS);
   	rc = SQLExecute(hstmt);
   
       // Variables for SQLDiagRec.  
       char mstate[6] = "\0";
       long native = 0;
       char mtext[300] = "\0";
       short mlength = 0;
       short i = 0;
   
       while ((rc = SQLGetDiagRec(SQL_HANDLE_STMT, hstmt, ++i, (unsigned char*)&mstate, &native, (unsigned char*)&mtext,300,&mlength))!=SQL_NO_DATA)
       printf("\nODBC Error:\t%s\n",mtext);
   }
   					

3. Change the data source name, user id, and password.
4. Compile and then run the code.