FIX: ????? ?????? ????? ODBC Access/Jet Microsoft ??? ? ???????? ??????? ???????? ????

?????? ????????? ?????? ?????????
???? ???????: 272951 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

???????

??? ??? ?????? ?????? Microsoft Access (Jet) ????? ODBC (Odbcjt32.dll ??????? 4.0.5303.1) ? ???? ??? ????? ?? Microsoft Windows 2000 Service Pack (SP) 1 ??? ????? ???????? ???? ????? ??? ????? ?????? ?? ??? ?????? ?? ? ??????? SQLDescribeCol ODBC API ??? ????? ?????? ????? ??? ???? 2147483598 (2 ???? ????).

??? ????????? ???? ????? ??????? ??? ?????? ???? ?? ?????? ?? ??????? API ODBC SQLDescribeCol ?????? ????? ??????? ?????? ?????? ? ?? "???? ???????" ????? ?????.

??? ????? ????? ????? Odbcjt32.dll 4.0.5303.1 ?????? ????? Microsoft Data Access Components (MDAC) ? 2.5 ?????? ????? ?????? Service Pack 1.

?? ???? ??????? ????? ?? ????? ????? ODBC Access ????.

????? ?? ????????? ??? ??? ??????? ?? "???? ??????? Windows Vista?" ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
940895??? ???? ??????? ???? ????? ??????? Windows Vista ?????? SQLDescribeCol ??????? SQLColAttribute ?????? ???? ????? ?? 2147483598 ????? ?? ?????? ???????? ?? 255

?????

????? Jet ??? ???? ??? ??????? ???????? ???? ?????? ????? ODBC Jet ?? ????? ??? ?????? ????. ????? ???? ?????? ??????? Jet ???? ?????? ??? ?????? ??? ???? ??? ????? ?? ?????? ???????? ??????? ????? ?? ? ????????. ??? ???? ??? ??? ??? ???????? ??? ?????? ?? (??? ?? varchar) ?? ???? ??? ??????? ????? ?? SQL_VARCHAR ??? ?? ???? ??? ???? 255.

???? ?????? ?? ???? ODBC ???? ???? ???? ??? ?????? 2 ???????? ???? ?? ?????? ?????? (????) ??????:

mdactest        65c-698	EXIT  SQLDescribeCol  with return code 0 (SQL_SUCCESS)
		HSTMT               01EC18D8
		UWORD                        2 
		UCHAR *             0x0012FAE4 [       8] "Expr1001"
		SWORD                      129 
		SWORD *             0x0012FA94 (8)
		SWORD *             0x0012FA86 (12)
		SQLULEN *           0x0012FA98 (2147483598)
		SWORD *             0x0012FA9C (0)
		SWORD *             0x0012FA9E (1)
				

????

??? ??? ???????? ??? ?????? ??? ???? ???? ???? ?? Microsoft ?????? Access ?????? 2.5. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
293312????? ?????? ??? ???? ???? ???? ?? MDAC 2.5
??? ??? ?????? ?????? Access ????? ODBC (Aceodbc.dll) ??????? ?? ???? 2007 Microsoft Office ????? ??????? ?????? 941877 ??? ??? ???????.

????? ?? ????????? ??? ??????? ?????? 941877 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
941877??? ???? ????????? ??????? Access 2007: ?? ?????? ????
??? ?? ???? ?????? ?????????? ?? ??? ??????? ???? ??????? ??????? ?? ????:
   Date         Version        Size              File name     
   -----------------------------------------------------------
   08/29/00     4.0.5629.0     270,608 bytes     Odbcjt32.dll
				
??????: ??? ??????? ?????? ??? ????? ?? ???? ?????? SP5 Jet ?? MDAC 2.6. ??? ????? ?? ?? ??????? "???????" ?? ??? ????? MDAC 2.5 ?????? ????? ?????? SP2 ??? ?? ??????? ???? ????? ??? ??????? ????? ????? ???? ??? ??? ??????? ??? ????? MDAC 2.5 SP2. ???????? ??? ???? ??? ????? ?? ????? ??? ????? ?????? ?? MDAC 2.5 ?????? ????? ?????? SP1 ??? MDAC 2.6 ??? ??????? ?????? ?????.

???? ??????

?? ??? ???????? ?? ???? ?? ?????? ?????? ??? ????? ?? ???? ????? ??? ?????? ??? ?????? CInt ?? CLng ? ????? ????? ??????? ??? ??? ?????? ??? ??????.

?????

???? Microsoft ?? ??? ????? ?? ?????? Microsoft ??????? ?? ??? "????? ???". ?? ????? ??? ??????? ???? ??? ?? Microsoft ?????? Access ?????? 2.5 ?????? ????? ?????? Service Pack 2.

??????? ????

???? ?? ???? ??? ?????? ?? ??? ???? ???? ?????? ????? ???????? ????? ????? ????? ??????? ??? IIF ? MAX ? MIN ? ????? ? ?????? ? MID ???.

??????: ????? ??? ??????? ?????? ????? ??? ????? ??????? ??????? ?? ????? "????? ????? Microsoft" ???????:
271177FIX: ???? ????? ????? ???????? ????? ???? ?????? ???? ???? ?????? ODBC

????? ????? ????? ???????

  1. ?? ???? ???????? ???????? ???? ?? ????? ???? ???? Microsoft Visual C++ ?? ?? ????? ????????? ????????. ?????? ?????? ?? ????? ??? ????? ??? ???? ?????? ???? ???????? ????? ??????.
    #include "stdafx.h"
    #include <windows.h>
    #include <stdio.h>
    #include <sql.h>
    #include <sqlext.h>
    
    
    void ShowErrors(HDBC, HSTMT);
    
    
    void main(void)
    {
    
    	SQLHANDLE henv;
    	SQLHANDLE hdbc;
    	SQLHANDLE hstmt;
    	
    	RETCODE rc = 0;
    	
    	SQLCHAR Statement[50] = "Select IIF('A' = 'A', 'Y', 'N') from shippers";	
    
    	SQLCHAR dsn[15] = "northwind2000";
    	SQLCHAR user[6] = "admin";
    	SQLCHAR pass[5] = "";
    	long sqlnts = -3;
    	
    //	variables for SQLDescribeCol
    	char  m_colname[20] = {"\0"};
    	short m_colsize = 0;
    	short m_sqltype = 0;
    	unsigned long m_prec = 0;
    	short m_scale = 0;
    	short m_nullable = 0;
    	
    
    
    	rc = SQLAllocEnv(&henv);
    	
    	rc = SQLAllocConnect(henv, &hdbc);
    	
    	rc = SQLConnect(hdbc, dsn, SQL_NTS, (SQLCHAR *) user, SQL_NTS, (SQLCHAR *) pass, SQL_NTS);
    	if ((rc != SQL_SUCCESS) && (rc != SQL_SUCCESS_WITH_INFO))
    		ShowErrors(hdbc, NULL);
    	rc = SQLAllocStmt(hdbc, &hstmt);
    
    	rc = SQLExecDirect(hstmt, Statement, SQL_NTS);
    	if ((rc != SQL_SUCCESS) && (rc != SQL_SUCCESS_WITH_INFO))
    		ShowErrors(NULL, hstmt);
    
    	rc = SQLDescribeCol(hstmt, 1, (unsigned char *)m_colname, 20, &m_colsize, &m_sqltype, &m_prec, &m_scale, &m_nullable);
    
    	printf("Size returned from SQLDescribeCol is:\t%d", m_prec);
    
    	SQLFreeStmt(hstmt, SQL_CLOSE);
    	SQLDisconnect(hdbc);
    	SQLFreeConnect(hdbc);
    	SQLFreeEnv(henv);
    }
    
    
    void ShowErrors (HDBC hdbc, HSTMT hstmt)
    {
    
    //	Variables for SQLGetDiagRec
    	SQLCHAR sqlState[20];
    	SQLCHAR errorMsg[1000];
    	SQLSMALLINT errorMsgLen;
    	SQLINTEGER nativeError;
    	char szTemp[4096];
    	
    	
    //	Retrieve the Raised error message
    	if (hdbc!= NULL) 
    		SQLGetDiagRec(SQL_HANDLE_DBC,hdbc,1,sqlState,
    			&nativeError,errorMsg,1000,&errorMsgLen);
    	else
    		SQLGetDiagRec(SQL_HANDLE_STMT,hstmt,1,sqlState,
    			&nativeError,errorMsg,1000,&errorMsgLen);
    
    //	Display the size of the returned error message, and the message itself
    	sprintf(szTemp, "Length=[%d] Text=%s", strlen((char*)errorMsg), errorMsg );
    	printf("ERROR!  %s\n\n\n", szTemp);
    
    	printf("Press any key to exit...");
    	getchar();
    
    	if (hstmt != NULL)
    	{
    		SQLFreeStmt(hstmt, SQL_CLOSE);
    		SQLFreeHandle(SQL_HANDLE_STMT, hstmt);
    	}
    	SQLDisconnect(hdbc);
    	SQLFreeHandle(SQL_HANDLE_DBC, hdbc);
    
    	exit(0);
    
    
    }
    					
  2. ????????? ???????? ????? ?? ??? ?????? ???? ??? ??????? ????? ?? ? ????????.

?????

????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
271177FIX: ???? ????? ????? ???????? ????? ???? ?????? ???? ???? ?????? ODBC

???????

???? ???????: 272951 - ????? ??? ??????: 22/???? ??????/1429 - ??????: 5.1
????? ???
  • Microsoft Data Access Components 2.5
  • Microsoft Data Access Components 2.5 Service Pack 1
  • Microsoft Open Database Connectivity Driver for Access 4.0
????? ??????: 
kbmt kbqfe kbhotfixserver kbbug kbdatabase kbfix kbjet kbmdac250sp2fix kbmdacnosweep KB272951 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????272951

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com