<% '*********************************************************************** ' System : ASPBanner ' Author : Christopher Williams of CJWSoft www.CJWSoft.com ' ' COPYRIGHT NOTICE ' ' See attached Software License Agreement ' ' (c) Copyright 2000 - 2001 by CJWSoft. All rights reserved '*********************************************************************** %> Installation instructions For SQL SERVER 7 and SQL SERVER 2000 1. Open SQL Enterprise Manager and Create a new database called "aspbanner". Leave the default settings checked when you do this. 2. In SQL Enterprise Manager go to Tools>SQL Server Query Analyzer. On the drop down box at the top right make sure your database "aspbanner" is selected. Otherwise your changes may effect the wrong database in your SQL server. Then load the script "aspbanner.sql" into the Query Analyzer. Click the green play button at the top. If everything goes well the response should read something like this. ****************************************************** New login created. Granted database access to 'aspbanneruser'. 'aspbanneruser' added to role 'db_datareader'. 'aspbanneruser' added to role 'db_datawriter'. (1 row(s) affected) (1 row(s) affected) (1 row(s) affected) ****************************************************** If so the Database has been created, the SQL user has been created, and access to the database for that user has been set up properly. The Database name is "aspbanner" The SQL user is "aspbanneruser" The password is "temp" You can change the password for the SQL user in Enterprise Manager if you like. Under security. 3. Now, in the ASP files provided with ASPCBanner Edit "dataconn_inc.asp" with a text editor and modify the connection string info. Be sure to change the info to match your server,username, and password Below are examples of valid connection strings. They all work the same. Alternate connection methods are shown in case you have problems with one of them. ------------------------------------------------------ Examples of using DSN-LESS connections. The "SERVER" and "Data Source" settings are either the Network Name for the SQL Server or the IP Address. For local servers you can also use an IP of "127.0.0.1" BannerConnectionString = "Driver={SQL Server};UID=aspbanneruser;password=temp;DATABASE=aspbanner;SERVER=127.0.0.1" or BannerConnectionString = "Provider=sqloledb;Data Source=127.0.0.1;Initial Catalog=aspbanner;User Id=aspbanneruser;Password=temp;" ------------------------------------------------------ ------------------------------------------------------ Examples of using a DSN connection. DSN connection, you must define the DSN first in your server under the ODBC settings. Use SQL server authentication and enter the Username & Password. It will test the connection. It if doesn;t work there it won't work in the code. BannerConnectionString = "DSN=aspbanner;UID=aspbanneruser;PASSWORD=temp" ------------------------------------------------------ 4. Now, in the ASP files provided with aspbanner Edit "dataconn_inc.asp" with a text editor and set the BannerDatabaseType variable to SQL like so. BannerDatabaseType = "SQL" ****************************************************** And you have everything set up. Go try the code via the web browser. ******************************************************