AspWebSolution Forums » Products » ASP Report Wizard v2 » Views and Tables no longer w/SQL 2005

index | search | no replies | posting guidelines | help

» »

:: Views and Tables no longer w/SQL 2005 :: (5)

Mar 28 2007, 3:59 PM

Views and Tables no longer w/SQL 2005

Eric97386

since: Mar 28, 2007
from: Corvallis, OR I have been using ASP Reports Wizard for a while now and it worked fine up until I moved my databases from an SQL Server 2000 to a new SQL Server 2005.

The reports still work but I no longer see the view or table list. All I see is the button "Build Report".

Any ideas?

Thanks in advance.

Mar 31 2007, 4:02 AM

Re: Views and Tables no longer w/SQL 2005

Post a Reply

ghost

from: Washington, DC Try setting the DatabaseType property of the report wizard as follows:
objWiz.DatabaseType="SQLServer"

Also, make sure that your database has views.

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

May 2 2007, 8:20 AM

Re: Views and Tables no longer w/SQL 2005

Post a Reply

Eric97386

since: Mar 28, 2007
from: Corvallis, OR >>Try setting the DatabaseType property of the report wizard as follows:
>>objWiz.DatabaseType="SQLServer"

>>Also, make sure that your database has views.
>>-------------------------
>>Ghost

Unfortunately, that did not work either.

Dim objWiz
Set objWiz = Server.CreateObject("AspWebSolution.ReportWizard2")
With objWiz
.LincenseKey = "XXXX-XXXX-XXXX-XXXX-XXXX"
.StyleSheet = "styles.css"
.Init("Driver={SQL Server};
Server=myserver;
DATABASE=mydatabase;
UID=reports;
PWD=reports")
.DatabaseType="SQLServer" 'new entry
.DisplayReports
End With

Again, it worked up until I moved my databases to SQL Server 2005. I am stumped.

ERIC

May 3 2007, 7:15 AM

Re: Views and Tables no longer w/SQL 2005

Post a Reply

ghost

from: Washington, DC The connection string for SQL Server 2005 is of the following format:

strConnectionString = "Provider=SQLNCLI;" & _ "Server=YOUR_SERVER_IP;Database=YOUR_DATABASE;" & _ "UID=YOUR_USERNAME;PWD=YOUR_PASSWORD;"

Try it and let me know if it helps.

Ref: Connection String Samples

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

May 3 2007, 8:44 AM

RESOLVED: Views and Tables no longer w/SQL 2005

Post a Reply

Eric97386

since: Mar 28, 2007
from: Corvallis, OR After running sqlncli.msi from my SQL Server 2005 install DVD on the web server, I got it working with the new connection string but I had to REMOVE the below entry first.

DatabaseType="SQLServer"

Thanks for your help!

Pages: (1) [1]