index | search | no replies | posting guidelines | help

login | register

Index » Products » ASP Report Wizard v2

search this forum:

:: Microsoft Sql connection :: (5) Post a New Message | Post a Reply
May 9 2006, 6:25 PM	Microsoft Sql connection Post a Reply
pooh since: May 9, 2006 from: somewhere	Hi, according to the code as below: ........................................................................................................................................ <% Dim objWiz Set objWiz = Server.CreateObject("AspWebSolution.ReportWizard2")      'Make sure you initialize before adding any HTML text 'TODO: Change this to your actual connection tring objWiz.Init("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=D:\Databases\nwind.mdb;")      'put this where you want your reports objWiz.DisplayReports      Set objWiz = Nothing %> ........................................................................................................................................ It's using Microsoft Access database. Anyone know how to connect to Microsoft SQL? anyone can help? ....many thanks.
May 10 2006, 10:25 AM	Re: Microsoft Sql connection Post a Reply
ghost from: Washington, DC	MS SQL Server strConnectionString = "Provider=MSDASQL;Driver={SQL Server};" & _     "Server=YOUR_SERVER_NAME;Database=YOUR_DATABASE;" & _     "User ID=YOUR_USERNAME;Password=YOUR_PASSWORD;" You can check out the connection string samples in our online manual for more examples. http://www.aspwebsolution.com/products/report_wizard/t_conn.htm ------------------------- Ghost
May 15 2006, 1:38 AM	Re: Microsoft Sql connection Post a Reply
pooh since: May 9, 2006 from: somewhere	Many thanks ghost....but I have another problem here. i got 2 tables on my database tblA - unique record of advertiser's identity.           eg. Adv_id               name                            email                              001                    IKEA                             ikea@ikea.com                  002                    Isetan                           isetan@isetan.com tblB - multiple records of enquiry on tblA            eg. Adv_id                        Quantity                           EnquiryDatetime                   002                              2                                      3/24/2004 12:08:00                   002                              1                                      4/20/2005 15:00:00                   001                              3                                      3/24/2004 11:24:00 how can achieve the below chart? y - no of enquiry x - months (jan, feb, mar...) filter by years Many thanks and hope to hear from you soon.
May 17 2006, 5:40 PM	Re: Microsoft Sql connection Post a Reply
pooh since: May 9, 2006 from: somewhere	help.... i need some urgent help on this.... anybody can help me on this??
May 18 2006, 11:07 AM	Re: Microsoft Sql connection Post a Reply
ghost from: Washington, DC	how can achieve the below chart? y - no of enquiry x - months (jan, feb, mar...) filter by years What do you need the advertisers table for? The information you want is in the enquiries table. As for the month names, you can create (and populate) a new table called Months (MonthNumber, MonthName) and join it with the enquiries table for SQL Server, your relationship statement might look as shown below: Month([AWS_Enquiries].[EnquiryDateTime]) = MonthNumber The create an aggregate report and select a SUM for Quantity ------------------------- Ghost
Pages: (1)   [1]

search this forum: