RSS Feed
Knowledgebase : Windows Hosting > MSSQL
You can use the following string to connect to MSSQL with a DSN <% Set Conn = Server.CreateObject ("ADODB.Connection") Conn.open "DSN=MyDSN;UID=USER;PWD=PASSWORD;DATABASE=mydatabase" %> MyDSN is the DSN that you created for the MSSQL server through...
You can use the following string to connect to MSSQL with out a DSN. It uses an OLEDB connection string to connect to a Microsoft SQL Server 200 database from within ASP: <% Dim conn Set conn = Server.CreateObject("ADODB.Connection") conn.Open "Pro...
Enterprise manager is a free tool from Microsoft which allows you to administer remote MS SQL databases - it is supplied as part of MS SQL Server software package. If you don't own a copy of SQL server you can download [http://www.microsoft.com/sql/evalua...
Yes, we have perl DBI installed with the MySQL DBD
Have you ever experienced a timeout error when trying to connect to your SQL Server database? Are you working from a laptop or over a dial-up connection to try and update tables in your database? One of the possible causes for this is the timeout value se...
You can truncate only nonactive portion of the transaction log. If your transaction log is very big and full, and you want to truncate transaction log, try the following: 1. Make the full database backup. 2. Set the Truncate Log On Checkpoint database opt...
SQL (Structured Query Language) is the most popular database language in use today. SQL is used to create database queries that take the form of commands. SQL queries enable you to select, insert, update and determine the location of data, among other tas...