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...
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...
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....
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...
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...
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...
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...
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...
This tutorial is helpful for every SQL server administrators and its developers which explains them about the usage of apostrophe in a SQL statement. It clearly explains the users how to avoid apostrophe errors. Its an easy to follow tutorial for...
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... | 
