I get the following error when doing RSW2K3 ENT Installation on WS2K3 SP1
(DC) and SQL Server 2000 SP4 environment. There is no option to ignore the
Error 1603 message , the only option is to cancel and rollback the
installation.
There is a parsing error is in the "LoadRSCatalog" Function- (see end of log)
Has anyone seen this problem before, any suggestions greatefully
appreciated,
<Func Name='CService::~CService'>
Action 22:07:52: Do_sqlScript. Configuring Microsoft SQL Server
SQL_SUCCESS_WITH_INFO (1) in SQLDriverConnectW
sqlstate=01000, level=0, state=0, native_error=5701, msg=Changed database
context to 'master'.
sqlstate=01000, level=0, state=0, native_error=5703, msg=Changed language
setting to us_english.
use master
SQL_SUCCESS_WITH_INFO (1) in SQLExecDirectW
sqlstate=01000, level=0, state=1, native_error=5701, msg=Changed database
context to 'master'.
IF (DB_ID('ReportServer') IS NULL) BEGIN CREATE DATABASE ReportServer
COLLATE Latin1_General_CI_AS_KS_WS END
0
Action 22:07:52: Do_sqlScript. Configuring Microsoft SQL Server
Do_sqlScript: Running SQL Statement
SQL_SUCCESS_WITH_INFO (1) in SQLExecDirectW
sqlstate=01000, level=0, state=1, native_error=1805, msg=The CREATE DATABASE
process is allocating 0.63 MB on disk 'ReportServer'.
sqlstate=01000, level=0, state=1, native_error=1805, msg=The CREATE DATABASE
process is allocating 0.49 MB on disk 'ReportServer_log'.
ALTER DATABASE ReportServer SET RECOVERY FULL
0
IF CHARINDEX('\', 'NT AUTHORITY\NETWORK SERVICE') != 0 BEGIN EXEC
sp_grantlogin 'NT AUTHORITY\NETWORK SERVICE' END
0
SQL_SUCCESS_WITH_INFO (1) in SQLExecDirectW
sqlstate=01000, level=0, state=1, native_error=15481, msg=Granted login
access to 'NT AUTHORITY\NETWORK SERVICE'.
IF (DB_ID('ReportServerTempDB') IS NULL) BEGIN CREATE DATABASE
ReportServerTempDB COLLATE Latin1_General_CI_AS_KS_WS END
0
SQL_SUCCESS_WITH_INFO (1) in SQLExecDirectW
sqlstate=01000, level=0, state=1, native_error=1805, msg=The CREATE DATABASE
process is allocating 0.63 MB on disk 'ReportServerTempDB'.
sqlstate=01000, level=0, state=1, native_error=1805, msg=The CREATE DATABASE
process is allocating 0.49 MB on disk 'ReportServerTempDB_log'.
ALTER DATABASE ReportServerTempDB SET RECOVERY SIMPLE
0
use ReportServerTempDB
SQL_SUCCESS_WITH_INFO (1) in SQLExecDirectW
sqlstate=01000, level=0, state=1, native_error=5701, msg=Changed database
context to 'ReportServerTempDB'.
IF NOT EXISTS (SELECT * FROM dbo.sysusers WHERE name='RSExecRole' AND
issqlrole=1) EXEC sp_addrole 'RSExecRole'
0
SQL_SUCCESS_WITH_INFO (1) in SQLExecDirectW
sqlstate=01000, level=0, state=1, native_error=15424, msg=New role added.
DECLARE @.pname AS sysname DECLARE @.i AS INT IF LOWER('NT AUTHORITY\NETWORK
SERVICE') != 'sa' AND NOT EXISTS (SELECT db1.dbid FROM
master.dbo.sysdatabases AS db1, master.dbo.syslogins AS logins1 WHERE db1.sid
= logins1.sid AND logins1.name = 'NT AUTHORITY\NETWORK SERVICE' AND db1.name
= 'ReportServerTempDB') AND NOT EXISTS (SELECT users1.name FROM dbo.sysusers
AS users1, master.dbo.syslogins AS logins1 WHERE users1.sid = logins1.sid AND
logins1.name = 'NT AUTHORITY\NETWORK SERVICE') BEGIN SET @.i = 0 SET @.pname = 'NT AUTHORITY\NETWORK SERVICE' WHILE EXISTS (SELECT name FROM dbo.sysusers
WHERE name=@.pname) BEGIN SET @.i = @.i + 1 SET @.pname = @.pname +
CONVERT(NVARCHAR(10), @.i) END EXEC sp_grantdbaccess 'NT AUTHORITY\NETWORK
SERVICE', @.pname END
0
SQL_SUCCESS_WITH_INFO (1) in SQLExecDirectW
sqlstate=01000, level=0, state=1, native_error=15341, msg=Granted database
access to 'NT AUTHORITY\NETWORK SERVICE'.
DECLARE @.pname AS sysname IF LOWER('NT AUTHORITY\NETWORK SERVICE') != 'sa'
AND NOT EXISTS (SELECT db1.dbid FROM master.dbo.sysdatabases AS db1,
master.dbo.syslogins AS logins1 WHERE db1.sid = logins1.sid AND logins1.name
= 'NT AUTHORITY\NETWORK SERVICE' AND db1.name = 'ReportServerTempDB') BEGIN
SELECT @.pname = (SELECT users1.name FROM dbo.sysusers AS users1,
master.dbo.syslogins AS logins1 WHERE users1.sid = logins1.sid AND
logins1.name = 'NT AUTHORITY\NETWORK SERVICE') EXEC sp_addrolemember
'RSExecRole', @.pname END
0
SQL_SUCCESS_WITH_INFO (1) in SQLExecDirectW
sqlstate=01000, level=0, state=1, native_error=15488, msg='NT
AUTHORITY\NETWORK SERVICE' added to role 'RSExecRole'.
D:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\CatalogTempDB.sql
17
Action 22:07:52: Do_sqlScript. Configuring Microsoft SQL Server
Do_sqlScript: Running SQL Script: D:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportServer\CatalogTempDB.sql
<Func Name='LoadRSCatalog'>
error parsing script file D:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportServer\CatalogTempDB.sql: 87
Error 29525. SQL Setup failed to execute a command for server configuration.
Refer to the Server error logs and setup logs for detailed error information.
MSI (s) (F4!C8) [22:08:37:874]: Product: Microsoft SQL Server 2000 Reporting
Services Enterprise Edition -- Error 29525. SQL Setup failed to execute a
command for server configuration. Refer to the Server error logs and setup
logs for detailed error information.
<EndFunc Name='SqlScriptHlpr' Return='1603' GetLastError='0'>
<EndFunc Name='Do_sqlScript' Return='1603' GetLastError='0'>
Gathering darwin properties for failure handling.
<Func Name='DisplayErrorDialog'>
regardsIts RS2000 Enterprise Edition not RSY2K3 ENT.
"Graham Smith" wrote:
> I get the following error when doing RSW2K3 ENT Installation on WS2K3 SP1
> (DC) and SQL Server 2000 SP4 environment. There is no option to ignore the
> Error 1603 message , the only option is to cancel and rollback the
> installation.
> There is a parsing error is in the "LoadRSCatalog" Function- (see end of log)
> Has anyone seen this problem before, any suggestions greatefully
> appreciated,
>
> <Func Name='CService::~CService'>
> Action 22:07:52: Do_sqlScript. Configuring Microsoft SQL Server
> SQL_SUCCESS_WITH_INFO (1) in SQLDriverConnectW
> sqlstate=01000, level=0, state=0, native_error=5701, msg=Changed database
> context to 'master'.
> sqlstate=01000, level=0, state=0, native_error=5703, msg=Changed language
> setting to us_english.
> use master
> SQL_SUCCESS_WITH_INFO (1) in SQLExecDirectW
> sqlstate=01000, level=0, state=1, native_error=5701, msg=Changed database
> context to 'master'.
> IF (DB_ID('ReportServer') IS NULL) BEGIN CREATE DATABASE ReportServer
> COLLATE Latin1_General_CI_AS_KS_WS END
> 0
> Action 22:07:52: Do_sqlScript. Configuring Microsoft SQL Server
> Do_sqlScript: Running SQL Statement
> SQL_SUCCESS_WITH_INFO (1) in SQLExecDirectW
> sqlstate=01000, level=0, state=1, native_error=1805, msg=The CREATE DATABASE
> process is allocating 0.63 MB on disk 'ReportServer'.
> sqlstate=01000, level=0, state=1, native_error=1805, msg=The CREATE DATABASE
> process is allocating 0.49 MB on disk 'ReportServer_log'.
> ALTER DATABASE ReportServer SET RECOVERY FULL
> 0
> IF CHARINDEX('\', 'NT AUTHORITY\NETWORK SERVICE') != 0 BEGIN EXEC
> sp_grantlogin 'NT AUTHORITY\NETWORK SERVICE' END
> 0
> SQL_SUCCESS_WITH_INFO (1) in SQLExecDirectW
> sqlstate=01000, level=0, state=1, native_error=15481, msg=Granted login
> access to 'NT AUTHORITY\NETWORK SERVICE'.
> IF (DB_ID('ReportServerTempDB') IS NULL) BEGIN CREATE DATABASE
> ReportServerTempDB COLLATE Latin1_General_CI_AS_KS_WS END
> 0
> SQL_SUCCESS_WITH_INFO (1) in SQLExecDirectW
> sqlstate=01000, level=0, state=1, native_error=1805, msg=The CREATE DATABASE
> process is allocating 0.63 MB on disk 'ReportServerTempDB'.
> sqlstate=01000, level=0, state=1, native_error=1805, msg=The CREATE DATABASE
> process is allocating 0.49 MB on disk 'ReportServerTempDB_log'.
> ALTER DATABASE ReportServerTempDB SET RECOVERY SIMPLE
> 0
> use ReportServerTempDB
> SQL_SUCCESS_WITH_INFO (1) in SQLExecDirectW
> sqlstate=01000, level=0, state=1, native_error=5701, msg=Changed database
> context to 'ReportServerTempDB'.
> IF NOT EXISTS (SELECT * FROM dbo.sysusers WHERE name='RSExecRole' AND
> issqlrole=1) EXEC sp_addrole 'RSExecRole'
> 0
> SQL_SUCCESS_WITH_INFO (1) in SQLExecDirectW
> sqlstate=01000, level=0, state=1, native_error=15424, msg=New role added.
> DECLARE @.pname AS sysname DECLARE @.i AS INT IF LOWER('NT AUTHORITY\NETWORK
> SERVICE') != 'sa' AND NOT EXISTS (SELECT db1.dbid FROM
> master.dbo.sysdatabases AS db1, master.dbo.syslogins AS logins1 WHERE db1.sid
> = logins1.sid AND logins1.name = 'NT AUTHORITY\NETWORK SERVICE' AND db1.name
> = 'ReportServerTempDB') AND NOT EXISTS (SELECT users1.name FROM dbo.sysusers
> AS users1, master.dbo.syslogins AS logins1 WHERE users1.sid = logins1.sid AND
> logins1.name = 'NT AUTHORITY\NETWORK SERVICE') BEGIN SET @.i = 0 SET @.pname => 'NT AUTHORITY\NETWORK SERVICE' WHILE EXISTS (SELECT name FROM dbo.sysusers
> WHERE name=@.pname) BEGIN SET @.i = @.i + 1 SET @.pname = @.pname +
> CONVERT(NVARCHAR(10), @.i) END EXEC sp_grantdbaccess 'NT AUTHORITY\NETWORK
> SERVICE', @.pname END
> 0
> SQL_SUCCESS_WITH_INFO (1) in SQLExecDirectW
> sqlstate=01000, level=0, state=1, native_error=15341, msg=Granted database
> access to 'NT AUTHORITY\NETWORK SERVICE'.
> DECLARE @.pname AS sysname IF LOWER('NT AUTHORITY\NETWORK SERVICE') != 'sa'
> AND NOT EXISTS (SELECT db1.dbid FROM master.dbo.sysdatabases AS db1,
> master.dbo.syslogins AS logins1 WHERE db1.sid = logins1.sid AND logins1.name
> = 'NT AUTHORITY\NETWORK SERVICE' AND db1.name = 'ReportServerTempDB') BEGIN
> SELECT @.pname = (SELECT users1.name FROM dbo.sysusers AS users1,
> master.dbo.syslogins AS logins1 WHERE users1.sid = logins1.sid AND
> logins1.name = 'NT AUTHORITY\NETWORK SERVICE') EXEC sp_addrolemember
> 'RSExecRole', @.pname END
> 0
> SQL_SUCCESS_WITH_INFO (1) in SQLExecDirectW
> sqlstate=01000, level=0, state=1, native_error=15488, msg='NT
> AUTHORITY\NETWORK SERVICE' added to role 'RSExecRole'.
> D:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\CatalogTempDB.sql
> 17
> Action 22:07:52: Do_sqlScript. Configuring Microsoft SQL Server
> Do_sqlScript: Running SQL Script: D:\Program Files\Microsoft SQL
> Server\MSSQL\Reporting Services\ReportServer\CatalogTempDB.sql
> <Func Name='LoadRSCatalog'>
> error parsing script file D:\Program Files\Microsoft SQL
> Server\MSSQL\Reporting Services\ReportServer\CatalogTempDB.sql: 87
> Error 29525. SQL Setup failed to execute a command for server configuration.
> Refer to the Server error logs and setup logs for detailed error information.
> MSI (s) (F4!C8) [22:08:37:874]: Product: Microsoft SQL Server 2000 Reporting
> Services Enterprise Edition -- Error 29525. SQL Setup failed to execute a
> command for server configuration. Refer to the Server error logs and setup
> logs for detailed error information.
> <EndFunc Name='SqlScriptHlpr' Return='1603' GetLastError='0'>
> <EndFunc Name='Do_sqlScript' Return='1603' GetLastError='0'>
> Gathering darwin properties for failure handling.
> <Func Name='DisplayErrorDialog'>
> regards
>
Showing posts with label ignore. Show all posts
Showing posts with label ignore. Show all posts
Wednesday, March 21, 2012
Tuesday, March 20, 2012
rs.MoveNext triggers "Operation is not allowed when the object is closed"
Wait, please don't ignore this one ... I've already tried all the obvious stuff.
I am currently on a contract assignment, and so cannot post the exact code (at least not at this time), but I should be able to layout the problem enough anyway.
I have a section of code that hits a remote database (same network, same subnet, but different city than the primary SQL database) to retrieve information logged by a digital phone system for display on an intranet screen.
The code is your typical recordset iteration, and looks basically like this.
Note: the connection is created and opened inside the PhoneCenter class. SQL statement used has been verified correct in SQL Server Management Studio.
<snip>
....
Dim rs as adodb.recordset = objPhoneCenter.Conn.execute(SQL)
If rs.recordcount > 0 then
while not rs.eof
.... Data processed here
rs.MoveNext
end while
end if
....
</snip>
This code runs flawlessly, every time, on the development platform but fails at "rs.MoveNext" when pushed out to the production server. What mystifies me is that the "Operation is not allowed when the object is closed" should not occur on code inside an rs.eof test, since the recordset must be open and have data in order to enter such a block.
This is, however, exactly what is happening. In 7 years working with SQL Server and ADO, I've never seen anything quite like this. Does anyone have any insight into what might be going on here?
P.S. I am in the process of attempting to gather more detailed information about this error, which I will post as it arrives if needed. At the moment, the above message is all I have to go on.
This is a wild guess since the information is not sufficient, but could you try specifying the cursor location likeobjPhoneCenter.Conn = ADODB.CursorLocationEnum.adUseClient
and see if there are any changes in behavior?|||
Ok, I didn't provide much info, I'll grant that. The connection is already using the above cursor. What other information would you like to see to make a more educated guess?
The current connection is defined by the following lines of code:
objPhoneCenter = New ADODB.Connection
objPhoneCenter.CursorLocation = ADODB.CursorLocationEnum.adUseClient
objPhoneCenter.Open("Provider=SQLOLEDB.1;Persist Security Info=True;Password=" & password & ";" & _
"User ID=" & username & ";Data Source=" & servername & ";" & _
"Network Library=dbmssocn;Initial Catalog=" & database & ";")
objPhoneCenter.IsolationLevel = ADODB.IsolationLevelEnum.adXactReadUncommitted
objPhoneCenter.CommandTimeout = 300
Servername is the actual machine name, not an IP address, and is resolved by an internal DNS server.
Does this help any?
rs.MoveNext triggers "Operation is not allowed when the object is closed"
Wait, please don't ignore this one ... I've already tried all the obvious stuff.
I am currently on a contract assignment, and so cannot post the exact code (at least not at this time), but I should be able to layout the problem enough anyway.
I have a section of code that hits a remote database (same network, same subnet, but different city than the primary SQL database) to retrieve information logged by a digital phone system for display on an intranet screen.
The code is your typical recordset iteration, and looks basically like this.
Note: the connection is created and opened inside the PhoneCenter class. SQL statement used has been verified correct in SQL Server Management Studio.
<snip>
....
Dim rs as adodb.recordset = objPhoneCenter.Conn.execute(SQL)
If rs.recordcount > 0 then
while not rs.eof
.... Data processed here
rs.MoveNext
end while
end if
....
</snip>
This code runs flawlessly, every time, on the development platform but fails at "rs.MoveNext" when pushed out to the production server. What mystifies me is that the "Operation is not allowed when the object is closed" should not occur on code inside an rs.eof test, since the recordset must be open and have data in order to enter such a block.
This is, however, exactly what is happening. In 7 years working with SQL Server and ADO, I've never seen anything quite like this. Does anyone have any insight into what might be going on here?
P.S. I am in the process of attempting to gather more detailed information about this error, which I will post as it arrives if needed. At the moment, the above message is all I have to go on.
This is a wild guess since the information is not sufficient, but could you try specifying the cursor location likeobjPhoneCenter.Conn = ADODB.CursorLocationEnum.adUseClient
and see if there are any changes in behavior?|||
Ok, I didn't provide much info, I'll grant that. The connection is already using the above cursor. What other information would you like to see to make a more educated guess?
The current connection is defined by the following lines of code:
objPhoneCenter = New ADODB.Connection
objPhoneCenter.CursorLocation = ADODB.CursorLocationEnum.adUseClient
objPhoneCenter.Open("Provider=SQLOLEDB.1;Persist Security Info=True;Password=" & password & ";" & _
"User ID=" & username & ";Data Source=" & servername & ";" & _
"Network Library=dbmssocn;Initial Catalog=" & database & ";")
objPhoneCenter.IsolationLevel = ADODB.IsolationLevelEnum.adXactReadUncommitted
objPhoneCenter.CommandTimeout = 300
Servername is the actual machine name, not an IP address, and is resolved by an internal DNS server.
Does this help any?
Wednesday, March 7, 2012
RS interface tools
Hi Ya'll,
I saw a MS demo of RS and decided to give it a try, do a little learning.
Perhaps toss Crystal reports if RS is too cool to ignore.
I have SQL 2K and had RS Installed but don't see the tools to begin design.
Is that only in SQL2K5 ?
Am I suppose to fork out the bucks for VB.net when I don't roll vb code?
Seems silly for a 'free' module.
Any easier options ? I can't upgrade to 2K5 yet, months away.
--
Mike
If data falls in the woods and nobody is there to see it ...... ?Hi,
You need to get hold of Visual Studio 2003 and here's a link to help you.
http://www.ondotnet.com/pub/a/dotnet/2004/11/29/sqlreporting.html
Cheers,
Phillip
"Tigermikefl" wrote:
> Hi Ya'll,
> I saw a MS demo of RS and decided to give it a try, do a little learning.
> Perhaps toss Crystal reports if RS is too cool to ignore.
> I have SQL 2K and had RS Installed but don't see the tools to begin design.
> Is that only in SQL2K5 ?
> Am I suppose to fork out the bucks for VB.net when I don't roll vb code?
> Seems silly for a 'free' module.
> Any easier options ? I can't upgrade to 2K5 yet, months away.
> --
> Mike
> If data falls in the woods and nobody is there to see it ...... ?|||If you are using SQL 2005 - then the Report Designer is already included and
you do NOT need to buy VB.NET. If you are using SQL 2000 Reporting Services,
then you will need to buy VS.NET 2003 (VB.NET) to install the Reporting
Services Designer component.
Best bet: Use SQL 2005 - the client tools will install the SQL Server
Business Intelligence Development Studio by default. (Which is the report
designer).
=-Chris
"Tigermikefl" <Tigermikefl@.discussions.microsoft.com> wrote in message
news:C465EEC3-A0B4-44EE-B019-3840F8BD5826@.microsoft.com...
> Hi Ya'll,
> I saw a MS demo of RS and decided to give it a try, do a little learning.
> Perhaps toss Crystal reports if RS is too cool to ignore.
> I have SQL 2K and had RS Installed but don't see the tools to begin
> design.
> Is that only in SQL2K5 ?
> Am I suppose to fork out the bucks for VB.net when I don't roll vb code?
> Seems silly for a 'free' module.
> Any easier options ? I can't upgrade to 2K5 yet, months away.
> --
> Mike
> If data falls in the woods and nobody is there to see it ...... ?|||Thanks for confirming. Wish we would upgrade but the developers aren't keen
on the testing time for a discontinued GUI (ours).
I'll see if I can find the VS2003/VB demo for testing and maybe we'll have
upgraded SQL by spring.
--
Mike
If data falls in the woods and nobody is there to see it ...... ?
"Phillip MacPherson-Cox" wrote:
> Hi,
> You need to get hold of Visual Studio 2003 and here's a link to help you.
> http://www.ondotnet.com/pub/a/dotnet/2004/11/29/sqlreporting.html
> Cheers,
> Phillip
> "Tigermikefl" wrote:
> > Hi Ya'll,
> >
> > I saw a MS demo of RS and decided to give it a try, do a little learning.
> > Perhaps toss Crystal reports if RS is too cool to ignore.
> >
> > I have SQL 2K and had RS Installed but don't see the tools to begin design.
> > Is that only in SQL2K5 ?
> >
> > Am I suppose to fork out the bucks for VB.net when I don't roll vb code?
> > Seems silly for a 'free' module.
> >
> > Any easier options ? I can't upgrade to 2K5 yet, months away.
> >
> > --
> > Mike
> >
> > If data falls in the woods and nobody is there to see it ...... ?|||Thanks Chris, maybe they'll let me play with the good toys soon.
--
Mike
If data falls in the woods and nobody is there to see it ...... ?
"Chris Conner" wrote:
> If you are using SQL 2005 - then the Report Designer is already included and
> you do NOT need to buy VB.NET. If you are using SQL 2000 Reporting Services,
> then you will need to buy VS.NET 2003 (VB.NET) to install the Reporting
> Services Designer component.
> Best bet: Use SQL 2005 - the client tools will install the SQL Server
> Business Intelligence Development Studio by default. (Which is the report
> designer).
> =-Chris
> "Tigermikefl" <Tigermikefl@.discussions.microsoft.com> wrote in message
> news:C465EEC3-A0B4-44EE-B019-3840F8BD5826@.microsoft.com...
> > Hi Ya'll,
> >
> > I saw a MS demo of RS and decided to give it a try, do a little learning.
> > Perhaps toss Crystal reports if RS is too cool to ignore.
> >
> > I have SQL 2K and had RS Installed but don't see the tools to begin
> > design.
> > Is that only in SQL2K5 ?
> >
> > Am I suppose to fork out the bucks for VB.net when I don't roll vb code?
> > Seems silly for a 'free' module.
> >
> > Any easier options ? I can't upgrade to 2K5 yet, months away.
> >
> > --
> > Mike
> >
> > If data falls in the woods and nobody is there to see it ...... ?
>
>|||check out 90 degree software - full client desktop report writer for MSRS.
"Tigermikefl" wrote:
> Thanks Chris, maybe they'll let me play with the good toys soon.
> --
> Mike
> If data falls in the woods and nobody is there to see it ...... ?
>
> "Chris Conner" wrote:
> > If you are using SQL 2005 - then the Report Designer is already included and
> > you do NOT need to buy VB.NET. If you are using SQL 2000 Reporting Services,
> > then you will need to buy VS.NET 2003 (VB.NET) to install the Reporting
> > Services Designer component.
> >
> > Best bet: Use SQL 2005 - the client tools will install the SQL Server
> > Business Intelligence Development Studio by default. (Which is the report
> > designer).
> >
> > =-Chris
> >
> > "Tigermikefl" <Tigermikefl@.discussions.microsoft.com> wrote in message
> > news:C465EEC3-A0B4-44EE-B019-3840F8BD5826@.microsoft.com...
> > > Hi Ya'll,
> > >
> > > I saw a MS demo of RS and decided to give it a try, do a little learning.
> > > Perhaps toss Crystal reports if RS is too cool to ignore.
> > >
> > > I have SQL 2K and had RS Installed but don't see the tools to begin
> > > design.
> > > Is that only in SQL2K5 ?
> > >
> > > Am I suppose to fork out the bucks for VB.net when I don't roll vb code?
> > > Seems silly for a 'free' module.
> > >
> > > Any easier options ? I can't upgrade to 2K5 yet, months away.
> > >
> > > --
> > > Mike
> > >
> > > If data falls in the woods and nobody is there to see it ...... ?
> >
> >
> >
I saw a MS demo of RS and decided to give it a try, do a little learning.
Perhaps toss Crystal reports if RS is too cool to ignore.
I have SQL 2K and had RS Installed but don't see the tools to begin design.
Is that only in SQL2K5 ?
Am I suppose to fork out the bucks for VB.net when I don't roll vb code?
Seems silly for a 'free' module.
Any easier options ? I can't upgrade to 2K5 yet, months away.
--
Mike
If data falls in the woods and nobody is there to see it ...... ?Hi,
You need to get hold of Visual Studio 2003 and here's a link to help you.
http://www.ondotnet.com/pub/a/dotnet/2004/11/29/sqlreporting.html
Cheers,
Phillip
"Tigermikefl" wrote:
> Hi Ya'll,
> I saw a MS demo of RS and decided to give it a try, do a little learning.
> Perhaps toss Crystal reports if RS is too cool to ignore.
> I have SQL 2K and had RS Installed but don't see the tools to begin design.
> Is that only in SQL2K5 ?
> Am I suppose to fork out the bucks for VB.net when I don't roll vb code?
> Seems silly for a 'free' module.
> Any easier options ? I can't upgrade to 2K5 yet, months away.
> --
> Mike
> If data falls in the woods and nobody is there to see it ...... ?|||If you are using SQL 2005 - then the Report Designer is already included and
you do NOT need to buy VB.NET. If you are using SQL 2000 Reporting Services,
then you will need to buy VS.NET 2003 (VB.NET) to install the Reporting
Services Designer component.
Best bet: Use SQL 2005 - the client tools will install the SQL Server
Business Intelligence Development Studio by default. (Which is the report
designer).
=-Chris
"Tigermikefl" <Tigermikefl@.discussions.microsoft.com> wrote in message
news:C465EEC3-A0B4-44EE-B019-3840F8BD5826@.microsoft.com...
> Hi Ya'll,
> I saw a MS demo of RS and decided to give it a try, do a little learning.
> Perhaps toss Crystal reports if RS is too cool to ignore.
> I have SQL 2K and had RS Installed but don't see the tools to begin
> design.
> Is that only in SQL2K5 ?
> Am I suppose to fork out the bucks for VB.net when I don't roll vb code?
> Seems silly for a 'free' module.
> Any easier options ? I can't upgrade to 2K5 yet, months away.
> --
> Mike
> If data falls in the woods and nobody is there to see it ...... ?|||Thanks for confirming. Wish we would upgrade but the developers aren't keen
on the testing time for a discontinued GUI (ours).
I'll see if I can find the VS2003/VB demo for testing and maybe we'll have
upgraded SQL by spring.
--
Mike
If data falls in the woods and nobody is there to see it ...... ?
"Phillip MacPherson-Cox" wrote:
> Hi,
> You need to get hold of Visual Studio 2003 and here's a link to help you.
> http://www.ondotnet.com/pub/a/dotnet/2004/11/29/sqlreporting.html
> Cheers,
> Phillip
> "Tigermikefl" wrote:
> > Hi Ya'll,
> >
> > I saw a MS demo of RS and decided to give it a try, do a little learning.
> > Perhaps toss Crystal reports if RS is too cool to ignore.
> >
> > I have SQL 2K and had RS Installed but don't see the tools to begin design.
> > Is that only in SQL2K5 ?
> >
> > Am I suppose to fork out the bucks for VB.net when I don't roll vb code?
> > Seems silly for a 'free' module.
> >
> > Any easier options ? I can't upgrade to 2K5 yet, months away.
> >
> > --
> > Mike
> >
> > If data falls in the woods and nobody is there to see it ...... ?|||Thanks Chris, maybe they'll let me play with the good toys soon.
--
Mike
If data falls in the woods and nobody is there to see it ...... ?
"Chris Conner" wrote:
> If you are using SQL 2005 - then the Report Designer is already included and
> you do NOT need to buy VB.NET. If you are using SQL 2000 Reporting Services,
> then you will need to buy VS.NET 2003 (VB.NET) to install the Reporting
> Services Designer component.
> Best bet: Use SQL 2005 - the client tools will install the SQL Server
> Business Intelligence Development Studio by default. (Which is the report
> designer).
> =-Chris
> "Tigermikefl" <Tigermikefl@.discussions.microsoft.com> wrote in message
> news:C465EEC3-A0B4-44EE-B019-3840F8BD5826@.microsoft.com...
> > Hi Ya'll,
> >
> > I saw a MS demo of RS and decided to give it a try, do a little learning.
> > Perhaps toss Crystal reports if RS is too cool to ignore.
> >
> > I have SQL 2K and had RS Installed but don't see the tools to begin
> > design.
> > Is that only in SQL2K5 ?
> >
> > Am I suppose to fork out the bucks for VB.net when I don't roll vb code?
> > Seems silly for a 'free' module.
> >
> > Any easier options ? I can't upgrade to 2K5 yet, months away.
> >
> > --
> > Mike
> >
> > If data falls in the woods and nobody is there to see it ...... ?
>
>|||check out 90 degree software - full client desktop report writer for MSRS.
"Tigermikefl" wrote:
> Thanks Chris, maybe they'll let me play with the good toys soon.
> --
> Mike
> If data falls in the woods and nobody is there to see it ...... ?
>
> "Chris Conner" wrote:
> > If you are using SQL 2005 - then the Report Designer is already included and
> > you do NOT need to buy VB.NET. If you are using SQL 2000 Reporting Services,
> > then you will need to buy VS.NET 2003 (VB.NET) to install the Reporting
> > Services Designer component.
> >
> > Best bet: Use SQL 2005 - the client tools will install the SQL Server
> > Business Intelligence Development Studio by default. (Which is the report
> > designer).
> >
> > =-Chris
> >
> > "Tigermikefl" <Tigermikefl@.discussions.microsoft.com> wrote in message
> > news:C465EEC3-A0B4-44EE-B019-3840F8BD5826@.microsoft.com...
> > > Hi Ya'll,
> > >
> > > I saw a MS demo of RS and decided to give it a try, do a little learning.
> > > Perhaps toss Crystal reports if RS is too cool to ignore.
> > >
> > > I have SQL 2K and had RS Installed but don't see the tools to begin
> > > design.
> > > Is that only in SQL2K5 ?
> > >
> > > Am I suppose to fork out the bucks for VB.net when I don't roll vb code?
> > > Seems silly for a 'free' module.
> > >
> > > Any easier options ? I can't upgrade to 2K5 yet, months away.
> > >
> > > --
> > > Mike
> > >
> > > If data falls in the woods and nobody is there to see it ...... ?
> >
> >
> >
Subscribe to:
Posts (Atom)