Through this online article the developers could get a solution for a problem which arise while executing Recordcount function in SQL. The author suggests to use GetRows function. The article highlights another method using SQL Server also. This arti
At the end of this online article the webmasters can easily access a text file or a database from any remote server. The author demonstrates the way to link to an Access database from the web. This article displays the sample connection string for th
This tutorial is used as reference which helps the users to know what is the best way to fetch or update records into the database. Author discusses this issue with rs(0) and rs(column_name). Sample code has been given for the users to refer and unde
Through this online article the author describes about the neccessity of using execute method. The author also suggests about the direct statements for quicker access. In this article the advantage of using INSERT or UPDATE statement is explained. Th
The author suggests the task to be carried out with the help of OLEDB. The author proves this concept by using SQL Server Authentication and Windows Authentication. The author also steps in ORACLE and MS Access using the MS OLEDB. The sample source c
This article is mostly for referring about SELECT key usage in SQL statements and also tells why to avoid SELECT while building statements. It explains about the demerits in SELECT with example in a simple way. The author also tells to use BLOB/text
After reading this article the developers can take a proper decision to store images on the file system than in the database. The author suggests to take filesystem option while storing images. Further the author explains each methodology with proper
Reserved Database Keywords is an ASP.NET reference with hundreds of reserved words that should not be used in the user defined objects, names of tables and columns of Access, ODBC and T-SQL databases. If the users use these words unknowingly then syn
In this online tutorial the learners could find the issues while paging with the help of a recordset. The author comes with more solutions to overcome this sort of issues. The author gives ten techniques explaining each one with an example and sample
In this ASP tutorial, how to retrieve an user's IP address is taught clearly with a simple program. And this tutorial analyzes the problems with this process when the IP address is protected by firewall and proxy settings. The users IP stored in the | 
