106) 12/7/2003 184375184375 184375.html">PRB: Security Implications of RDS 1.5, IIS 3.0 or 4.0, and ODBC (184375) - Because the RDS Datafactory (a single component of RDS) allows implicit remoting of data access requests by default, it can be exploited to allow unauthorized Internet clients to access OLE DB datasources available to the server. A malicious user may...
107) 12/7/2003 185425185425 185425.html">INFO: ADO Hierarchical Recordsets via SHAPE APPEND via C++/VBA/Java (185425) - This article describes how to use the SHAPE APPEND syntax to produce hierarchical recordsets and how to traverse them. Sample code is provided for VBA.
108) 12/7/2003 183059183059 183059.html">PRB: ODBC Syntax Required for Retrieving Parameter Information (183059) - The following information only applies to the OLEDB Provider for ODBC: When using the Refresh method on a Command object's Parameters Collection for retrieving provider-side parameter information of a stored procedure, parameter information may not be...
109) 12/7/2003 181479181479 181479.html">FIX: Getting SELECT DISTINCT to Work Under ADO with SQL Server (181479) - Under certain conditions with ActiveX Data Objects (ADO), SELECT DISTINCT in your SQL statement will not provide distinct records. Any of the following situations produces incorrect results with SQL Server: You open a recordset with rs.open "select...
110) 12/7/2003 175245175245 175245.html">PRB: Unable to Update Long Text Fields Using ADO (175245) - When attempting to perform a table update, the following message appears: Query Based Insertion or Updating of BLOB values can not be supported. This may be caused by an attempt to update a non-primary table in a view
111) 12/7/2003 175264175264 175264.html">FIX: CommandTimout Property Problem with Connection Object (175264) - The Connection object of the ActiveX Data Objects supports the CommandTimeout property. This property is documented to support a value of 0, which provides for an infinite timeout. This functionality is not available in ActiveX Data Objects 1.0.
112) 12/7/2003 165804165804 165804.html">INFO: Comparing RDS Technology to RDO and DAO (165804) - NOTE : With version 1.5, the Remote Data Service (RDS) was renamed and merged with ActiveX Data Objects (ADO) to provide data remoting within the same programming model as ADO. Formerly, the Remote Data Service was known as the Advanced Data Connector...
113) 12/7/2003 164479164479 164479.html">PRB: Windows 95 Hangs When You Use ADO with Active Server Pages (164479) - ActiveX Data Objects (ADO) cause Windows 95 to stop responding with Personal Web Server (PWS) under heavy loading conditions.
114) 12/7/2003 165671165671 165671.html">HOWTO: Use ASP/ADO to Query an ODBC Datasource (SELECT) (165671) - The following is an example of an Active Server Pages (ASP) script that can be used to troubleshoot connection problems with ODBC datasources. This example can also be used to demonstrate how to write simple scripts that select data from databases:...
115) 12/7/2003 184265184265 184265.html">HOWTO: Distribute ADO with the VB5 Application Setup Wizard (184265) - Redistributing ADO, Remote Data Services (RDS), and other Microsoft Data Access Components correctly and safely with the Visual Basic 5.0 Application Setup Wizard is done by SHELLing out and running the MDAC_TYP.exe. You can download the latest...
116) 12/7/2003 175261175261 175261.html">HOWTO: Retrieve Bitmap from Access and Display It in Web Page (175261) - This article shows by example how to extract the bitmap photos in the Microsoft Access 97 Nwind.mdb database, and view them from a Web browser using Active Server Pages (ASP). In order to accomplish this task, an ActiveX DLL must be created that...
117) 12/7/2003 323920323920 323920.html">PRB: Run-Time Error When You Use SQLXML 2.0 with ADO to Execute an Updategram (323920) - If you use Microsoft SQLXML 2.0 with ActiveX Data Objects (ADO) to execute an updategram that specifies an XML Schema definition language (XSD) schema, and the SQLXML Version property of the connection object is set to a default value, you receive the...
118) 12/7/2003 224320224320 224320.html">FIX: Different MTS Transaction Contexts Cause Increase in Connections (224320) - If you are using ADO within components that are running under Microsoft Transaction Server (MTS), and the components have different transactional contexts, additional connections may be opened to database server. Connections opened in a package with...
119) 12/7/2003 189448189448 189448.html">FIX: Error "Undefined Function 'xxxxx' in Expression" (189448) - When you use an Active Server Pages (.asp) page and ActiveX Data Objects (ADO) to open a recordset from a query in a Microsoft Access database, which contains any intrinsic functions (for example, Month(), Left(), etc.), the following error may occur:...
120) 12/7/2003 184630184630 184630.html">HOWTO: Create and Distribute an ActiveX Document with Remote Data Services (RDS) (184630) - This article explains how to create an ActiveX document that uses the Remote Data Services (RDS) of ActiveX Data Objects (ADO) and how to distribute the document to Microsoft Internet Explorer clients.