91) 12/14/2003 239725239725  239725.html">BUG: SQL Server Error "Specified Column Precision 38 Is Greater Than the Maximum Precision of 28. (2750)" When Running Parameterized Query
(239725) - When you run a parameterized query, with a parameter of type decimal and a precision of 38, against a SQL Server 7.0 database using the 3.70 driver, you may receive the following error message: Server: Msg 2750, Level 16, State 1, Procedure...

92) 12/14/2003 241147241147  241147.html">PRB: SQL Server ODBC Driver Returns Output Parameter as a Result Set in a Plain SQL Statement
(241147) - The SQL Server ODBC Driver version 3.70.06.23 and later does not support the return of an output parameter from an SQL SELECT statement. Instead, the driver returns the output parameter as a result set. For example, when executing "Select ?=Max(qty)...

93) 12/14/2003 222831222831  222831.html">HOWTO: Retrieving Numeric Data with SQL_NUMERIC_STRUCT
(222831) - This article describes how to retrieve numeric data from the SQL Server ODBC driver into a numeric structure and how to get the correct values using specific precision and scale values. The SQL_NUMERIC_STRUCT is defined in the sqltypes.h header file...

94) 12/14/2003 232060232060  232060.html">HOWTO: MDAC Setup Troubleshooting Guide
(232060) - This article presents a step-by-step troubleshooting guide for MDAC setup issues.

95) 12/14/2003 177135177135  177135.html">PRB: Do not Call ODBC Within DLL_PROCESS_DETACH Case
(177135) - When using the MFC Database classes or calling ODBC functions within the DLL_PROCESS_DETACH case of the DllMain() function, an access violation can occur especially if the DLL links to the MFC DLL (which does a LoadLibrary call to call ODBC). For...

96) 12/14/2003 150552150552  150552.html">HOWTO: How To Avoid the ODBC Login Dialog when Using MFC
(150552) - By default, when you use the MFC ODBC database classes to connect to a datasource, ODBC invokes a login dialog box that allows the user to type in any necessary information, such as a password, to log in. With Visual C++ 4.2, use the...

97) 12/14/2003 137814137814  137814.html">DOC: MFC ODBC Classes and Parameterized Pre-Defined Queries
(137814) - The MFC Encyclopedia article "Recordset: Declaring a Class for a Predefined Query" describes how to invoke a predefined query that takes parameters and returns a result set. The instructions in that article will not work for predefined queries that...

98) 12/14/2003 127734127734  127734.html">HOWTO: Ensure ODBC.DLL and ODBCCURS.DLL Cursor Levels Match
(127734) - The ODBC Driver Manager and the Cursor Library must have the same cursor level. ODBC.DLL and ODBCCURS.DLL are the corresponding files in 16-bit Windows. ODBC32.DLL and ODBCCR32.DLL are the corresponding files in 32-bit Windows. Attempting to use these...

99) 12/14/2003 312085312085  312085.html">FIX: When You Disconnect a Hierarchical Recordset the Connection Is Not Released
(312085) - When you disconnect a recordset that is returned from the Microsoft DataShape provider, it may appear that the recordset is disconnected. However, when the active connections are examined, the connection is still open. In some circumstances this may...

100) 12/14/2003 222129222129  222129.html">INFO: List of All the Files Installed by MDAC 2.0 SP2 (Typical Redist)
(222129) - This article presents a list of all the files installed by MDAC 2.0 SP2. MDAC 2.0 SP2 (Mdac_typ.exe) can be downloaded from http://msdn.microsoft.com/dataaccess . All the following locations of files are given as they were installed on Windows NT. For...

101) 12/14/2003 200427200427  200427.html">HOWTO: Export and Import Access Tables Using DAO or ODBC
(200427) - This article details how to import and export tables using SQL DML (data manipulation language) statements with the Microsoft Access ODBC driver.

102) 12/14/2003 298883298883  298883.html">INFO: OLE DB Header File Changes for 64-Bit Platform Programming
(298883) - The OLE DB database components that are included with the Microsoft Data Access Components (MDAC) 2.7 software development kit (SDK) contain some changes from earlier versions of OLE DB to allow programmers to code to the new 64-bit platforms. This...

103) 12/14/2003 296730296730  296730.html">INFO: MDAC 2.5 Service Pack 2 Included in Windows 2000 Service Pack 2 Release
(296730) - Beginning with Windows 2000, the Microsoft Data Access Components (MDAC) are considered an integral part of the operating system. As a result, the MDAC 2.5 service packs are included as part of the Windows 2000 service packs. Windows 2000 Service Pack...

104) 12/14/2003 236786236786  236786.html">PRB: "Numeric Value Out of Range" Error when Calling GetFieldValue and Using SQL UNION
(236786) - If CRecordset::GetFieldValue() is used on a numeric column to retrieve a value from an SQL UNION derived recordset and the Microsoft Oracle ODBC driver is used, then the following error message occurs: Error in column 1: Numeric value out of range...

105) 12/14/2003 271852271852  271852.html">BUG: MS Oracle ODBC Driver Truncates Trailing Spaces in Column Name
(271852) - When you use Microsoft's Oracle ODBC driver with the ODBC SQLDescribeCol function, incorrect values may be returned for the column name and column name length.