<% '***************************************************************************************** ' Page Description: This page contains the database connections '***************************************************************************************** 'Depending on whether you are using Access or SQL Server, you must comment out one of the lines 'that initialize the constant DB_CONNECTION. The other line should be updated with 'the appropriate details to connect to your database. SQL server is highly recommended. '***** SQL SERVER FORMAT ***** 'Update the string, replacing the words YourServerName, YourDatabaseName, YourUsername, and YourPassword 'with the appropriate values. Const DB_CONNECTION = "Driver=SQL Server;Server=(local);Initial Catalog=Northwind;UID=pallav;PWD=pallav" '***** MS ACCESS FORMAT ***** 'Update the string, replacing the Data Source with the path to your database, YourUsername, and YourPassword with the 'appropriate values. Note that the value for data source has to be the absolute path to the database. If you do not 'have a username or password on your access database, simply delete the word(s) YourUsername and YourPassword 'Const DB_CONNECTION = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Path\DB.mdb;User Id=YourUsername;Password=YourPassword;" 'The following variable must be set to either "MSAccess" or "SQLServer" Const DATABASE_TYPE = "SQLServer" 'Const DATABASE_TYPE = "MSAccess" Response.Write vbcrlf %>