Articles   Dev Forums   Personalize   Favorites   Member Login   ASP Hosting      Active Users:  53
DevASP - ASP and XML Articles, Samples, Toturials, Sample Chapters and resources for Developers Friday, May 16, 2008
Home
Articles & Samples
ASP Hosting
Dev Search
Dev Forum
Add Your Articles
Add a Listing
Sample Chapters
Directory Feed
Link to US
Contact

Search Directory
Applications
Articles & Samples
Components
Community
Database
Developer Sites
Downloads
Hosting Services
Introduction
Knowledge Base
Sample Chapters
WebCasts

Trusted by over 7 million customers!
ASP Directory
Applications
Articles & Samples
Components
Developer Sites
Knowledge Base
Sample Chapters
WebCasts
XML Directory
Applications
Articles & Samples
Developer Sites
Error, Bugs & Fixes
Downloads
Introduction
Knowledge Base
Sample Chapters
WebCasts

FREE 12 month online training for ASP.NET & MS Expression Studio and a Free copy of MS Expression Web with Windows Server Purchase

Home > Search > Knowledge Base > ASP > Articles > Database
Search
DevASP

What's New
What's Hot

Troubleshooting Common Problems with Remote Data Services (Q251122)       
Total Hits: 742  |  Today: 0       Rating:  
Read Reviews | Write Review |              Your Rating: 

Problems with Remote Data Services (RDS) are usually the result of one or more of a very common set of configuration concerns. This article describes the settings required for RDS to work properly. If any of these settings are not properly configured, then you may receive errors when trying to use RDS. Some of the most common RDS error messages are:
4099 800A1003 Unable to connect to server.
4100 800A1004 Unable to create business object.
4101 800A1005 Unable to invoke method on busi...

HOW TO: Debug Visual Basic COM Components That Are Used Within Active Server Pages (Q299633)       
Total Hits: 739  |  Today: 0       Rating:  
Read Reviews | Write Review |              Your Rating: 

This step-by-step procedure demonstrates how to debug (or step through) Microsoft Visual Basic (VB) Component Object Model (COM) components that are used within Active Server Pages (ASP) pages.

...

HOWTO: Programmatically Create a DSN for SQL Server with VB (Q184608)        
Total Hits: 1838  |  Today: 0       Rating:  
Read Reviews | Write Review |              Your Rating: 

This article demonstrates how to programmatically create a Data Source Name (DSN) for SQL Server using Visual Basic. The technique discussed in this article uses Windows Application Programming Interface (API) functions to create and manipulate entries in the Windows Registry.


...

HOW TO: Connect an HTML Page to a Microsoft Access Database        
Total Hits: 6178  |  Today: 0       Rating:  
Read Reviews | Write Review |              Your Rating: 

A data access page is an HTML page that has an Office Web Component embedded into it. The Office Web Component stores connection information about a data source. This article describes how to use data access pages to connect an HTML page to tables in a database.

...

HOWTO: Use ASP to Create an Access Report Snapshot and Display it on a Web Page (Q259805)       
Total Hits: 5723  |  Today: 0       Rating:  
Read Reviews | Write Review |              Your Rating: 

This article illustrates how you can use server-side script to create a Microsoft Access snapshot (.snp) that can be displayed on a Web page....

Q271908 INFO: MDAC Version 2.6 Does Not Contain Jet       
Total Hits: 877  |  Today: 0       Rating:  
Read Reviews | Write Review |              Your Rating: 

Starting with Microsoft Data Access Components (MDAC) version 2.6, MDAC no longer contains Jet components. In other words, MDAC version 2.6 and 2.7 do not include Microsoft Jet, Microsoft Jet OLE DB Provider, and the ODBC Desktop Database Drivers.

...

HOWTO: Retrieve ADO Recordset from Oracle Through ASP Using REF CURSORS (Q255043)       
Total Hits: 1451  |  Today: 0       Rating:  
Read Reviews | Write Review |              Your Rating: 

With the release of Microsoft Data Access Components (MDAC) 2.5, the Microsoft OLEDB provider for Oracle now supports the return of ActiveX Data Objects (ADO) recordsets from an Oracle procedure through the use of a REF CURSOR type. This functionality is only supported in the Microsoft OLEDB provider for Oracle. The Microsoft ODBC for Oracle driver does not support the use of REF CURSORS....

HOWTO: Populating a FlexGrid Control with ADO and ASP (Q189406)       
Total Hits: 2401  |  Today: 0       Rating:  
Read Reviews | Write Review |              Your Rating: 

The FlexGrid ActiveX control is a powerful control to display and manipulate data from a database in Internet Explorer. This sample uses Visual InterDev's DataCommand Design-time control to access the datasource. The client-side script uses a call to a subroutine to actually build the HTML source code that will add rows and columns to the FlexGrid control before the control is displayed by Internet Explorer....

INFO: Programmer's Guide to Using ADO in Active Server Pages (Q172927)       
Total Hits: 592  |  Today: 0       Rating:  
Read Reviews | Write Review |              Your Rating: 

This article presents information that will be useful to anyone wanting to take advantage of the ActiveX Data Objects within Active Server Pages (ASP). The following topics are covered: How to find ADO Knowledge Base Articles, ADO Resources/Points of Information...

Hand Code an ADO Data Connection       
Total Hits: 1124  |  Today: 0 Author: microsoft.com       Rating:  
Read Reviews | Write Review |              Your Rating: 

This step-by-step procedure demonstrates how to hand code an ActiveX Data Objects (ADO) data connection in an Active Server Pages (ASP) page....

HOWTO: Extract Information from Excel Sheet with DAO (Q190195)       
Total Hits: 1617  |  Today: 0       Rating:  
Read Reviews | Write Review |              Your Rating: 

If there is a column in your Excel spreadsheet that contains both text and numbers, the ISAM will not be able to correctly interpret which datatype it should be. Make sure that all the cells in a column are formatted to be the same datatype. For example, you might have following data in four columns in an Excel sheet...

HOWTO: Use ADO to Access Objects Through an ADSI LDAP Provider (Q187529)       
Total Hits: 5083  |  Today: 0       Rating:  
Read Reviews | Write Review |              Your Rating: 

The Active Directory Service Interfaces (ADSI) Lightweight Directory Access Protocol (LDAP) provider implements OLE DB interfaces that allow you to use ActiveX Data Objects (ADO) to access objects in LDAP compliant directories. You must create an ADO connection object and set its Provider property to "ADsDSOObject". You can specify any string, including "", as the connection string (first argument) of the ADO connection object's open method....

HOWTO: Open ADO Connection and Recordset Objects (Q168336)       
Total Hits: 2264  |  Today: 0       Rating:  
Read Reviews | Write Review |              Your Rating: 

ActiveX Data Objects (ADO) offers several ways to open both the Connection and Recordset objects. This article presents sample code for several common techniques for each object....

Q202125 HOWTO: Page Through a Recordset from ASP       
Total Hits: 3782  |  Today: 0       Rating:  
Read Reviews | Write Review |              Your Rating: 

This article describes how to use the PageSize, PageCount, and AbsolutePage properties of an ADO recordset and what cursor types must be used to get Recordset Paging to work....

HOWTO: Retrieve a Recordset from an Oracle Stored Procedure Using ADO on ASP       
Total Hits: 8102  |  Today: 0       Rating:  
Read Reviews | Write Review |              Your Rating: 

This article demonstrates how to call an Oracle package to retrieve a recordset using ADO on Active Server Pages (ASP).....

How to Define a Stored Procedure in ASP       
Total Hits: 3362  |  Today: 0       Rating:  
Read Reviews | Write Review |              Your Rating: 

This article provides the ASP code necessary to programmatically determine the parameter requirements for any stored procedure....

Authentication methods for connections to SQL Server in Active Server Pages       
Total Hits: 399  |  Today: 0 Author: Microsoft       Rating:  
Read Reviews | Write Review |              Your Rating: 

Both SQL Server authentication (standard security) and Windows NT authentication (integrated security) are SQL Server authentication methods that are used to access a SQL Server database from Active Server Pages (ASP)....

Retrieve XML Data in ASP       
Total Hits: 1206  |  Today: 0 Author: Microsoft       Rating:  
Read Reviews | Write Review |              Your Rating: 

This article includes step-by-step instructions to set up an ASP client that demonstrates the use of the OLEDB Simple Provider for XML to access hierarchical XML data....

HOWTO: Connect to a Remote Access Database from Active Server Pages (Q253580)       
Total Hits: 3435  |  Today: 0       Rating:  
Read Reviews | Write Review |              Your Rating: 

It is possible to connect to a remote Microsoft Access database from Active Server Pages on an IIS Web server. To do this, you need to set up your connection string just as you would if the database were on the local server as described in the "References" section of this article. However, when the database is on a remote server, there are a number of additional configuration steps that should be taken to ensure that this works correctly....

HOWTO: Create ADO Disconnected Recordsets in ASP Using VBScript and JScript (Q289531)       
Total Hits: 1465  |  Today: 0       Rating:  
Read Reviews | Write Review |              Your Rating: 

This article shows one technique to create ActiveX Data Objects (ADO) disconnected recordsets in Active Server Pages (ASP) when programming with Microsoft VBScript and Microsoft JScript. This article assumes that the reader is familiar with ADO and ASP....


1  2  Next >> 


DevASP - Privacy - Disclaimer
Copyright © 2008 DevASP.com