Programming Tutorials Browser Tutorials Articles Struts Tutorials Hibernate Tutorials

  Tutorial: ASP Database Related Making the Switch from ODBC to OLE DB Tutorial

ODBC is great and all but for speed and reliability you should switch to OLE DB to power your database driven apps. This tutorial will show you how to do it two ways: in the global.asa and in any ASP page.

Tutorial Details:

Making the Switch from ODBC to OLE DB

ODBC is great and all but for speed and reliability you should switch to OLE DB to power your database driven apps. I will show you how to do it two ways: in the global.asa and in any ASP page.

IN THE GLOBAL.ASA FILE:

As you probably already know, I usually use the global.asa to declare my database connection string. Because of this, the change from ODBC to OLE DB was easy! - I only had to change one line in one file to implement the new connection method across the entire site.


 

Read Tutorial at: Click here to view the tutorial

Rate Tutorial:
ASP Database Related Making the Switch from ODBC to OLE DB Tutorial

View Tutorial:
ASP Database Related Making the Switch from ODBC to OLE DB Tutorial

Related Tutorials:

Integrating Databases
Integrating Databases
 
JDBC drivers in the wild - JavaWorld July 2000
JDBC drivers in the wild - JavaWorld July 2000
 
Develop n-tier applications using J2EE - JavaWorld December 2000
Develop n-tier applications using J2EE - JavaWorld December 2000
 
Create your own type 3 JDBC driver, Part 3
Create your own type 3 JDBC driver, Part 3
 
SQL Database Access with DBTags
SQL Database Access with DBTags In a J2SE or J2EE application, Java Database Connectivity (JDBC) can be used to create a connection with a SQL database, create database tables, retrieve result sets, and update the database. To use a database from a Jav
 
Daffodil DB - Your complete Java RDBMS
Daffodil DB - Cross Platform Java Database Products... Daffodil DB is a J2EE-certified, SQL-99 and JDBC standards compliant Java RDBMS, made available in both Embedded and Network Editions .
 
Berkeley DB, Java Edition I: The Basics
The original version of Berkeley DB is written in C. This means that, up until now, if a Java programmer wanted to use Berkeley DB, she would have to use some sort of translation layer (for example, JNI) to handle the communication between Java and Berkel
 
First Step towards JDBC
This article introduce you with JDBC and shows you how to create a database application to access the databases.
 
Accessing the Database from Servlet
This article shows you how to access database from servlets. Here I am assuming that you are using win95/98/2000 and running Java Web Server.
 
Jeff Schmitt's JDBC Page
This tutorial assumes you are using the MySQL database and the GWE JDBC drivers. The host computer is triton.towson.edu.
 
Overview of JDBC and its use with Microsoft Access
JDBC provides a set of classes for Java with a standard SQL database access interface. Goal is uniform access to a wide range of relational databases.
 
First Step towards JDBC!
First Step towards JDBC! First Step towards JDBC Introduction T his article introduce you with JDBC and shows you how to create a database application to access the databases. For the shake of simplicity, in very first example Access database and
 
Accessing Database from servlets through JDBC!
Accessing Database from servlets through JDBC! Accessing Access Database From Servlet T his article shows you how to access database from servlets. Here I am assuming that you are using win95/98/2000 and running Java Web Server. For the sake of
 
Using MYSQL Database with JSP & Servlets.
Using MYSQL Database with JSP & Servlets. Using MYSQL Database with JSP & Servlets. MY SQL is a powerful RDBMS, which can handle large amount of data. And more interestingly it is free to use, except for some commercial use. you can download it
 
Connecting to MySQL database and retrieving and displaying data in JSP page
Connecting to MySQL database and retrieving and displaying data in JSP page Connecting to MySQL database and retrieving and displaying data in JSP page This tutorial shows you how to connect to MySQL database and retrieve the data from the
 
Techniques used for Generating Dynamic Content Using Java Servlets.
Techniques used for Generating Dynamic Content Using Java Servlets. Techniques used for Generating Dynamic Content Common Gateway Interface (CGI) For any web application high performance and timely delivery are key ingredients to competitive
 
Introduction to the JDBC
Introduction to the JDBC Introduction to the JDBC Introduction T his article introduce you with JDBC and shows you how to our search engine with database. What is JDBC? J ava Database Connectivity or JDBC for short is set of Java API's that
 
Connecting to the Database Using JDBC and Pure Java driver
Connecting to the Database Using JDBC and Pure Java driver Connecting to the Database JDBC Driver In our search engine we are using MySQL database server and MM.MySQL Driver for connecting our application to the database. MM.MySQL Driver is
 
What is Web Hosting
What is Web Hosting What is Web Hosting? What is Web Hosting? If you have a company and want web presence than you need a website. With the website any one from the world must be able to view your pages, images etc. Website is actually a
 
DB Solo - Database development and management tool
DB Solo is a powerful database development and management tool for developers and DBAs. DB Solo has an intuitive user interface that allows you to explore and manage your database objects as well as execute your own ad-hoc queries.
 
Site navigation
 

 

Send your comments, Suggestions or Queries regarding this site at roseindia_net@yahoo.com.

Copyright © 2006. All rights reserved.