AspWebSolution Forums » Products » ASP Report Wizard v2 » MS Sql server 2000 table not display

index | search | no replies | posting guidelines | help

» »

:: MS Sql server 2000 table not display :: (4)

Post a New Message | Post a Reply

Apr 15 2005, 9:57 AM

MS Sql server 2000 table not display

Post a Reply

wongsa

since: Apr 15, 2005
from: Bangkok Thailand.

Dear,

I use Windows 2003 server/IIS 6.0/Sql server 2000

I test by created folder /asp_test under root and grant permission complete.
I make defaultsql.asp

<%

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=MSDASQL;Driver={SQL Server};" & _
    "Server=SPCOMNET1;Database=siriraj;" & _
    "User ID=sa;Password=2496;")

'put this where you want your reports
objWiz.DisplayReports

Set objWiz = Nothing

%>

Below is happen after run script please advise.

Thanks in advance,

Sanit Kiriwong.

Apr 17 2005, 9:02 AM

Re: MS Sql server 2000 table not display

Post a Reply

ghost

from: Washington, DC

Make sure that your web server has ASP enabled. IIS 6 comes with ASP disabled by default.

-------------------------
Ghost

Apr 17 2005, 8:38 PM

Re: MS Sql server 2000 table not display

Post a Reply

wongsa

since: Apr 15, 2005
from: Bangkok Thailand.

I have enabled and I test with asp application on this server it's work fine but only not work when ran default.asp page,

Sanit Kiriwong.

Apr 18 2005, 7:45 AM

Re: MS Sql server 2000 table not display

Post a Reply

wongsa

since: Apr 15, 2005
from: Bangkok Thailand.

Hi Ghost,

I test your sample product on windows 2003, IIS6 it work fine.But I can not config to run on Sql server 2000.Please advise.

Your product feature meet my project requirement ,so please give me solution for this cause.

Thanks in advance,

Sanit.

Pages: (1) [1]