Add to Favorites    Make Home Page 243 Online  
 Language Categories  
 Our Services  

Get 9,000 Interview Questions & Answers in an eBook.


  • 9500+ Pages
  • 9000 Question & Answers
  • All Tech. Categories
  • 14 MB Content

    Get it now !!



    Send your Resume to 6000 Companies


  • ASP » Tips and Tutorials » Database-related » Connecting to Database using DSN/DSN less Connections

    A D V E R T I S E M E N T

    Today's Special: Get free Magazine from SAP!

    Search Projects & Source Codes:



    Title Connecting to Database using DSN/DSN less Connections
    Platform n/a
    Price
    Author Visit Author Website
    Website Visit Website of - Connecting to Database using DSN/DSN less Connections
    Category ASP » Tips and Tutorials » Database-related
    Hits 290
    Description An article on connecting to database via ASP using both DSN and DSN less connections. Explains uses of each. Learn using connection strings.

    A D V E R T I S E M E N T




    Google Groups Subscribe to SourceCodesWorld - Techies Talk
    Email:

    Free eBook - Interview Questions: Get over 1,000 Interview Questions in an eBook for free when you join JobsAssist. Just click on the button below to join JobsAssist and you will immediately receive the Free eBook with thousands of Interview Questions in an ebook when you join.


    Scripts Related to - Connecting to Database using DSN/DSN less Connections

    Script Name

    Database Tutorial

    This 4-page tutorial shows all the basics of using Active Server Pages and VBScript to work with databases. It covers Connecting to the Database, Working With Recordsets, and more.

    ASP Data Access for Beginners

    The driving force behind Active Server technologies is data access. In order to develop a truly dynamic web site developers need to allow users to access data on demand. Luckily, with Microsoft's Active Server Pages, this is exceedingly easy to do. This article for ASP beginners details how to connect to a SQL Server 7.0 database using ActiveX Data Object (ADO) and Open Database Connectivity (ODBC).

    Insert Using SQL

    This short tutorial demonstrates how to insert data into a SQL database using SQL statements.

    Display Table on Web Page

    This page demonstrates the capabilities how to display a table from a SQL statement. It illustrates not only how to display the table, but also how to detect that no records were returned from a query, and how to detect null and blank values in the data.

    Multiple Form Selection (Where In)

    Allowing multiple choices of data observations enables people to customize views of your data and adds value to your applications. This example utilizes our db on the career statistics of Hammerin’ Hank Greenberg. The years he played are available to select from in a dropdown menu. When multiple years are selected they are passed comma delimited. Utilizing the where in statement in our sql the comma delimited selections are appended to our sql statement to display only those years selected.

    Limit query results with the Recordset object

    Have this short program around so that you can quickly see what columns and what data are in your database. Here you will see some of the common methods and properties used to limit the results from your SQL query. Using a simple form that takes a table name and a submit button, and you can easily display increments of the table data. Full source code available.

    Creating a Simple SQL-Driven Web Site

    This hands-on tutorial explains how to develop a simple SQL-driven web site in just minutes. Topics include: Our Database Design, Creating a Data Source, Inserting A Tip Into Our Database, Displaying and Deleting Tips, Searching the Database, and Displaying the Tips.

    Generating random records from the Database

    This article shows how to generate random records from the database. Also explains how to generate random numbers. Sample Database and Code available for download.

    ASP-Database Transactions

    This is an article on executing all or none database queries using ASP-Database transactions. Must read for ASP-Database developers. Sample Database and Code available for download.

    Speed up Database Access using GetRows

    This is an article on using Recordset. It uses GetRows method to speedup database access. One of the fastest ways of displaying database records with ASP. Sample Database and Code available for download.

    Google Search

    Google


    Download Yahoo Messenger | Placement Papers | Free SMS | C Interview Questions | C++ Interview Questions


     Advertisements  

     A D V T

    Jobs & Career
    Freshers Jobs
    Jobs Newsletter
    Placement Papers
    Placement Papers
    GATE Preparation
    Analysis & Design Of Algo.
    Operating System
    Lexical Analysis
    GRE Preparation
    GRE Home
    1208 Antonyms Test
    5000 Word's List
    Top 100 Words' List
    Scholarships
    Top 100 CS Univ.
    Top 126 EE Univ.
    Tutorials
    Hardware Tutorial
    1500 Free eBooks
    XML Tutorial
    Webmaster Resources
    EzTraffic
    Articles
    Fun
    Send FREE SMS!
    SMS Jokes
    Love SMS
    Funny Jokes