| :: SQL Database :: (4) | Post a New Message | Post a Reply |
 SQL Database | Post a Reply |
from: Dallas
 Re: SQL Database | Post a Reply |
from: Washington, DC
Installing the ASP Report Wizard
Read the following article to setup a sample reporting appliation
Setting up your first application
After you have read the article above, use the code below as the source for your sample reports.asp page located in your web server:
<% 'TODO: Change the constants below to reflect your database settings Const SERVER_NAME = "(local)" Const DATABASE_NAME = "Northwind" Const USER_NAME = "sa" Const PASSWORD = "sa" 'declare your variables Dim objWiz, strConnectionString 'initialize your variables strConnectionString
= "Provider=MSDASQL;Driver={SQL Server};"& _ "Server= "& SERVER_NAME & ";Database= "& DATABASE_NAME & ";"& _ "User ID= "& USER_NAME & ";Password= "& PASSWORD & ";" Set objWiz = Server.CreateObject("AspWebSolution.ReportWizard2") 'Make sure you initialize before adding any HTML text objWiz.Init(strConnectionString)
'put this where you want your reports objWiz.DisplayReports
Set objWiz = Nothing %>Note:
Make sure the folder in which your asp page is located has read & write permissions
Also, download the sample applications located on our downloads page to
learn-by-example
1. Sample Applications
2. Online Manual
-------------------------
Ghost
| Re: SQL Database | Post a Reply |
from: Dallas
| Re: SQL Database | Post a Reply |
from: Washington, DC
'TODO: Change the constants below to reflect your database settings Const SERVER_NAME
= "(local)" Const DATABASE_NAME
= "Northwind" Const USER_NAME
= "sa" Const PASSWORD
= "sa" Check out the sample applications, they are a lot more explicit.
Let me know if this information helps.
thanx!
-------------------------
Ghost