|
|
|
|
|
Total Hits: 340 | Today: 0 |
Author: Alwyn
|
Rating:
|
|
|
Copying data from one server to another server is a tricky thing in Microsoft Sql Server, to enable this we have to first make a bulk copy to a file and from that file we can make a bulk copy to our destination database. Once the bulk copy is done, we have to make a check whether the recovery model is simple to handle, if it's so, we have to make a FULL or differential backup, if the recovery model is bulk-logged or full, it's enough to take a LOG backup...
|
|
|
|
Total Hits: 269 | Today: 0 |
Author: Alwyn
|
Rating:
|
|
|
Using Microsoft Sql Server, we can create links to the Object Linking and Embedding(OLE) Database Datasources, this process is called as Linked Servers.
After creating the link we can query into the remote databases using RowSets which will have the reference to tables in the OLE DB DataSources. Every distributed Query will refer multiple linked servers and hence can perform update or read operations to each individual linked servers. A single distributed query can perform read and update ope...
|
|
|
|
Total Hits: 786 | Today: 0 |
Author: PowerASP
|
Rating:
|
|
|
This article is an overview of SYSTEM DSN's, DSN-LESS Connections, and any permissions that may need to be set on the server....
|
|
|
|
Total Hits: 71 | Today: 0 |
Author: Philip Q
|
Rating:
|
|
|
This article will take you through the steps to get data from a database and present it on the screen in a nice and orderly fashion (table).
First you need to know weather you want a DSN or a DSN-Less connection. A DSN connection provides a link to the database using ODBC (DSN-Less uses ADO). I personally use DSN-Less as if you want to move it from server to server, it is easier. However the only difference is in the connection so, both will work here....
|
|
|
|
Total Hits: 475 | Today: 0 |
Author: Dan Pomerchik
|
Rating:
|
|
|
You've probably heard of SQL. What does it mean, you ask. Well, SQL (Structured Query Language) is a very handy tool for database programmers (including ASP programmers). Without SQL, it would be very difficult to perform many common tasks relating to databases. In this article, I will teach you the basics and the common uses of SQL...
|
|
|
|
Total Hits: 448 | Today: 0 |
Author: ASPalliance
|
Rating:
|
|
|
This article is the first of a series on how to retrieve and update information stored in databases. It is organized into the following references:Database Basics, Connecting to a database, The Recordset object
...
|
|
|
|
Total Hits: 785 | Today: 0 |
Author: Wrox Press
|
Rating:
|
|
|
In depth coverage from connecting to the databases to the carrying out of commands and procedures. You can get Introduction about connection and commands and procedure....
|
|
|
|
Total Hits: 294 | Today: 0 |
Author: ASPalliance
|
Rating:
|
|
|
This article will take you through the steps to get data from a database and present it on the screen in a nice and orderly fashion (table)....
|
|
|
|
Total Hits: 1534 | Today: 0 |
Author: 121 Software
|
Rating:
|
|
|
Not sure how to make use of the free MySQL database space included with your web-hosting plan? This step-by-step tutorial explains a simple way to upload data from a Microsoft Access database to the MySQL database at your ISP. The tutorial also contains a free sample application written in ASP (PHP version also available)....
|
|
|
|
Total Hits: 792 | Today: 0 |
Author: Steven Smith
|
Rating:
|
|
|
ASP Functions to simplify your site's data access....
|
|
|
|
Total Hits: 759 | Today: 0 |
|
Rating:
|
|
|
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)....
|
|
|
|
Total Hits: 1666 | Today: 0 |
|
Rating:
|
|
|
Building a Web-based database application isn't as hard as you think. Jay introduces theories of relational databasing and shows you how it's done....
|
|
|
|
Total Hits: 289 | Today: 0 |
Author: John Peterson
|
Rating:
|
|
|
For the past 10 years or so, instead of simply using a search engine as my browser's start page, I've been using my own self-designed page. The page may not look like much, but what it lacks in looks, it more then makes up for in functionality. It has links to the sites and admin pages that I tend to access frequently, search boxes to send queries to the sites I often search, stock quotes for a few different stock symbols, the latest headlines from some RSS feeds, a link to the company phone lis...
|
|
|
|
Total Hits: 350 | Today: 0 |
Author: Darren Death
|
Rating:
|
|
|
The guest book has been designed to be easily deployed. Just drop the files into a directory, customize the database path, and set the appropriate permissions. The guest book does however allow for advanced configuration options which allows for bad word filtering, IP filtering, advanced email options, and more....
|
|
|
|
Total Hits: 152 | Today: 0 |
Author: Brett Burridge
|
Rating:
|
|
|
Once a web site grows beyond a couple of dozen pages then it can sometimes be difficult to create a site navigation scheme that allows users to quickly find exactly what they're looking for. One way to improve site navigation is to add a search facility to the website. Unfortunately, building a website search facility for your website can be a time consuming exercise. Although ASP.NET supports the searching of files using the Windows Indexing Service, writing code to query can Indexing Service c...
|
|
|
|
Total Hits: 53 | Today: 0 |
Author: Philip Q
|
Rating:
|
|
|
Now that you've done part one, its time to continue on with the organization of the data into a table. (This article is also named 'Data to Table'). If you are reading from Part 1 then all you need is the recordset and the connection. If you are reading from Data to Table then Step 4 really = Step 1 for you, but be sure that you have your recordset and your connection done....
|
|
|
|
Total Hits: 577 | Today: 0 |
Author: Faisal Khan
|
Rating:
|
|
|
Databases are a way of organizing and keeping your data. The data stored in databases can be anything from user email addresses to binary files. Databases have become so popular in the past decade that it is almost unimaginable to not to use them on the web.In this tutorial I will guide through the creation of a simple Microsoft Access database to incorporating it in to your ASP web pages. Creating and making use of a database on the web is so very much easy that it will be only after reading th...
|
|
|
|
Total Hits: 298 | Today: 0 |
Author: Faisal Khan
|
Rating:
|
|
|
In this article we will learn the two ways of connecting to database :via (DSN Data Source Name)without DSN
DSN Connections In my earlier article on Accessing the database from ASP I explained connecting to database via DSN in a step by step mannner. So there is no need to repeat that again, you can see it from there. DSN stands for 'Data Source Name'. It is an easy way to assign useful and easily rememberable names to data sources which may not be limited to databases alone e.g Excel sprea...
|
|
|
|
Total Hits: 268 | Today: 0 |
Author: Errol Booysens
|
Rating:
|
|
|
Before you start to design a database, it’s important you understand exactly what a database is and what types of databases you have to choose from. The application type will affect the database type that you choose....
|
|
|
|
Total Hits: 695 | Today: 0 |
Author: Daniel Morritt
|
Rating:
|
|
|
For simple applications using text files you can count database items using SELECT COUNT in a simple comma delimited txt file database...
|
|
|
|
|
|
|
