managed objects

Hello people :-)

I'm doing some development work with Visual Studio 2005 and SQLServer 2000. My SQL DB is running on a Windows 2000 Server box in the office, and I'm doing the development on my XPPro workstation. Now I've been trying to connect to the Win2000 box though VS and although I can see the server and the DB when I hit ok I get this error

"The SQL server specified by these connection propertise does not support managed objects"

What the heck does that mean?

any help would be great :-)Well when you are using VS2005 it assumes you are connecting to SQL Server 2005, quick fix I think is to install .NET framework 2.0 in the Win2k server and make sure IIS is running even if you are not using it. Hope this helps.

Manage cluster resources via Visual Basic

Hello,
is it possible to manage cluster resources with a script language like
Visual Basic?
I want to update the cluster applications with an automatic
installation process. Therefore I must stop the corresponding cluster
resource (take offline), update the application and restart the
cluster resource (bring online).
Knows anyone a way to do this within a Visual Basic program?
Thanks
Widmann
Yes, it is very possible. Do I know how to do it? Heck no. I am not a
programmer in any sense. Check msdn.microsoft.com or "goggle
site:msdn.microsoft.com" cluster programming. Or something like that using
programmer speak
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"Friedbert Widmann" <WidiHEL@.gmx.de> wrote in message
news:1acb6845.0411180650.2a2d88e6@.posting.google.c om...
> Hello,
> is it possible to manage cluster resources with a script language like
> Visual Basic?
> I want to update the cluster applications with an automatic
> installation process. Therefore I must stop the corresponding cluster
> resource (take offline), update the application and restart the
> cluster resource (bring online).
> Knows anyone a way to do this within a Visual Basic program?
> Thanks
> Widmann
|||This might be a good place to start:
http://msdn.microsoft.com/library/en...start_page.asp
Regards,
John
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:OWHUHbYzEHA.1196@.TK2MSFTNGP15.phx.gbl...
> Yes, it is very possible. Do I know how to do it? Heck no. I am not a
> programmer in any sense. Check msdn.microsoft.com or "goggle
> site:msdn.microsoft.com" cluster programming. Or something like that using
> programmer speak
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://msmvps.com/clustering - Blog
> "Friedbert Widmann" <WidiHEL@.gmx.de> wrote in message
> news:1acb6845.0411180650.2a2d88e6@.posting.google.c om...
>
|||The easiest way is to us the command-line tool 'Cluster.exe'. It works very
well from a script. See Windows help for details.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Friedbert Widmann" <WidiHEL@.gmx.de> wrote in message
news:1acb6845.0411180650.2a2d88e6@.posting.google.c om...
> Hello,
> is it possible to manage cluster resources with a script language like
> Visual Basic?
> I want to update the cluster applications with an automatic
> installation process. Therefore I must stop the corresponding cluster
> resource (take offline), update the application and restart the
> cluster resource (bring online).
> Knows anyone a way to do this within a Visual Basic program?
> Thanks
> Widmann
|||use WMI...but carefull
rgds
Sinisa
"Geoff N. Hiten" wrote:

> The easiest way is to us the command-line tool 'Cluster.exe'. It works very
> well from a script. See Windows help for details.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Friedbert Widmann" <WidiHEL@.gmx.de> wrote in message
> news:1acb6845.0411180650.2a2d88e6@.posting.google.c om...
>
>

making reports with xml data source

Can i make a report from non sql-server data source ?
To be specific:
I have an xml data source, and i built the dataset from the xml,by VIsual
Studio -DotNet [by Code],
can i bound reporting services 2000 to this dataset as datasource?
if NO, can we do it in sql server Reporting Services 2005?
thanks in advanced
Oren.On Sun, 10 Apr 2005 00:11:05 -0700, Oren Said <Oren
Said@.discussions.microsoft.com> wrote:
>Can i make a report from non sql-server data source ?
>To be specific:
>I have an xml data source, and i built the dataset from the xml,by VIsual
>Studio -DotNet [by Code],
>can i bound reporting services 2000 to this dataset as datasource?
>if NO, can we do it in sql server Reporting Services 2005?
>thanks in advanced
>Oren.
See, "Using an External Dataset with Reporting Services" in BOL for RS
2000.
Andrew Watt
MVP - InfoPath|||The new controls (available with beta 2 of Widbey) should allow this. Unitl
the controls are out and being used I'm not guaranteeing that but it is my
understanding that they will allow this (both a web and winform control
will be available).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Oren Said" <Oren Said@.discussions.microsoft.com> wrote in message
news:B8E667B7-78EA-4A2F-92FC-9B230ABCCE6A@.microsoft.com...
> Can i make a report from non sql-server data source ?
> To be specific:
> I have an xml data source, and i built the dataset from the xml,by VIsual
> Studio -DotNet [by Code],
> can i bound reporting services 2000 to this dataset as datasource?
> if NO, can we do it in sql server Reporting Services 2005?
> thanks in advanced
> Oren.|||Here are some options for today:
Customize your own XML datasource for SQL Server 2000, and cosume the
webservice from SQL and acces those objects from the report (SQLRS)
Customize you own BOL for use XML as datasources, (make sure your BOL
support more than 10k records)
Wait for SQL 2005, certainly MS will have something available (its the
promess)
Thanks
Jerry
--
Call a WebService from SQL Server 2000
http://www.rdlcomponents.com/EXSP/default.aspx
WebService Data Processing Extension
http://www.rdlcomponents.com/DTE/Default.aspx
"Bruce L-C [MVP]" wrote:
> The new controls (available with beta 2 of Widbey) should allow this. Unitl
> the controls are out and being used I'm not guaranteeing that but it is my
> understanding that they will allow this (both a web and winform control
> will be available).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Oren Said" <Oren Said@.discussions.microsoft.com> wrote in message
> news:B8E667B7-78EA-4A2F-92FC-9B230ABCCE6A@.microsoft.com...
> >
> > Can i make a report from non sql-server data source ?
> >
> > To be specific:
> >
> > I have an xml data source, and i built the dataset from the xml,by VIsual
> > Studio -DotNet [by Code],
> > can i bound reporting services 2000 to this dataset as datasource?
> >
> > if NO, can we do it in sql server Reporting Services 2005?
> >
> > thanks in advanced
> >
> > Oren.
>
>sql

Make a Query in VB and pass to CR

Hello all, I'm new to this crystal reports mumbo-jumbo and need some help. Im using VB 6 and the crystal that comes with free with Visual Studio 6. I have to create a report, and I would like to be able to do it from my VB app. I have the user select some criteria from my app. I would then like to construct an SQL query based on that input and output a report. The SQL isnt the problem. I've searched the web for help, but the most help I got was finding out how to install CR and add it to my toolbox.

Where do I go from here? I figure I need to at least layout the report in CR, cause that won't be changing, only the data that goes in the report.

I know I'm asking a lot in this post, but I haven't been able to find answers anywhere else. If one of you gentelmen (or ladies?) could point me in the right direction, I would appreciate it more than you could possibly know.

P.S. I'm using a FoxPro DB if that makes a diffrence. I'm connected with Jet driver.sql query : like only shown record with lastname = erick?
if it is u could use selection formula..

cRt.selectionformula = " lastname = '" & text1.text & "'"

regards|||Thats kind of what I'm looking for. What I have is a table that has some test information, test id, name, number of questions, etc. Then i have a test taker table that has all the ususal info, ie, name, ssn, ... and also the test they took. what I want to do is populate my report with only the test takers who scored above a certain number, who took the selected test. I know how to structure the query, but I don't know what to do with it once I have it. I saw there is a sqlquery property so i set it equal to my query, then showed my report, but nothing happend.|||cRt.selectionformula = " lastname = '" & text1.text & "'"

is "lastname" a field in the report?|||I tried something similar to what just got posted but nothing happend, my report didn't even print to the screen. I think that that might just add 1 record to the report, would I have to loop through an entire recordset to populate the report, or is there another way?|||There are 2 ways (that I know of) that you can do your query and get the results within VB, then pass only the data to Crystal Reports.

The first way is use ADO or RDO and pass the recordset to the report.

The second way is to use CDO (Crystal Data Objects) to pass the data to the report. With CDO, you populate an array with your data and stuff the array into a CDO Rowset (which is similar to an RDO resultset or an ADO Recordset).

Using either of these 2 methods, the only Crystal does is display the data.

For more info on CDO, see this link (http://www.dev-archive.com/forum/showthread.php?s=&threadid=281658&highlight=cdo)

Also, have a look at this (http://www.dev-archive.com/forum/showthread.php?t=298564&highlight=rdc). It gives code on 2 different ways of passing the data to the report. (rsData would be an ADO recordset since that's what I use, but you can replace that with an RDO resultset or a CDO rowset)

I personally prefer to use CDO and the second method from the second post (called RDC), since it seems to give you more control (ie, with RDC you can move fields and rename column headers, etc, that are in the report.)

One last thing, keep in mind that I use Crystal Reports 8.5, so if you have a different version, you may not be able to use the code I have posted word-for-word.

And check out Crystal's Support Website (http://support.businessobjects.com/search/advsearch.asp) and Crystal's Suport Forum (http://support.businessobjects.com/forums/default.asp)|||is "lastname" a field in the report?
yes it is..that is the field that user want to retrieve..
text1.text is the value that user choose..is this case
filed (lastname) with value = erick
cRt is ur crystal report control name

would I have to loop through an entire recordset to populate the report, or is there another way?
u don't have to loop entire record..if the value that user enter is in the table then the report will shown..the other way maybe what malleyo do..right now i'm using the method above..

regards

Major Problem!...Multiple user connection problem in reporting service 2000 with SOAP

Hi Everyone,

I am having a big problem here.

I am using Reporting Service 2000 and Visual Studio 2005. I have developed a custom web control which communicates with reporting web service and displays report. I pass username, password and domain information as network credential for communicating with report server (report server is remote). This is a web application in which users can see reports on the web page which uses my custom web control.

Everything works fine when there is single user. But when another user logs onto website and tries to access same or different report it seems like connection of the first user gets lost. And everything crashes for first user and for second user it works fine.

In fact if second user is accessing the same report then first user can see second user's report information which is no at all acceptable. I am sure that there should be some way so that multiple users can communicate with reporting server programmatically at the same time. Microsoft wouldn't make reporting web service so that only one user can access report at a time, would they?

Can anyone help me with this problem? Any help will be greatly appreciated.

Sounds like your users are being identified as the same person which would suggest annonymous access is being used or your web control is passing the same credentials for both users. I'm not sure how you've coded it or whether you are doing any caching or storing session state somewhere.

You have to narrow down what is at fault here. I would suggest the following:

Set your report server and report manager virtual directories to integrated or basic authentication and have 2 separate users access report manager at the same time|||

Thanks Adam for quick reply.

I don't have anonymous access enabled. I am using integrated windows authentication. Earlier i was trying to authenticate all users with one administartor credentials to communicate with Reporting web service. But then i changed my code so that it takes individual user's credentials. But this didn't make any difference.

I read in one reporting service book that Report server overwrites SessionID member after each call to the Render method. Therefore, two subsequent report requests will share same sessions only if they ask for the same report (assuming that the parameter set is same)

For example, let's say you run report A, then report B, and then report A again. When report B is rendered, its session identifier will overwrite the previous session identifier, which means that you will lose report A's session identifier. When report A is run again, even if the parameter set is the same, its execution will create a new report session and IsNewExecution will return true.

So i think this overwriting of SessionID by report server is causing the problem. But i don't know yet how to program so that it maintains proper SessionID for each user and hence doesn't crash for any user.

If anyone has any idea for solving this problem then please let me know. Thanks in advance.

|||Figured out. It was bug in my code. Accidentlly i had declared Parameter property as static in my code and because of that one user's report was using other user's property and which was making program crash. Thanks for reply though.

Major Multiple connection problem RS2000 with SOAP

Hi Everyone,

I am having a big problem here.

I am using Reporting Service 2000 and Visual Studio 2005. I have developed a custom web control which communicates with reporting web service and displays report. I pass username, password and domain information as network credential for communicating with report server (report server is remote). This is a web application in which users can see reports on the web page which uses my custom web control.

Everything works fine when there is single user. But when another user logs onto website and tries to access same or different report it seems like connection of the first user gets lost. And everything crashes for first user and for second user it works fine.

In fact if second user is accessing the same report then first user can see second user's report information which is no at all acceptable. I am sure that should be some way so that multiple users can communicate with reporting server programmatically at the same time. Microsoft wouldn't make reporting web service so that only one user can access report at a time, would they?

Can anyone help me with this problem? ANyhelp will be greatly appreciated.

I don't have anonymous access enabled. I am using integrated windows authentication. Earlier i was trying to authenticate all users with one administartor credentials to communicate with Reporting web service. But then i changed my code so that it takes individual user's credentials. But this didn't make any difference.

I read in one reporting service book that Report server overwrites SessionID member after each call to the Render method. Therefore, two subsequent report requests will share same sessions only if they ask for the same report (assuming that the parameter set is same)

For example, let's say you run report A, then report B, and then report A again. When report B is rendered, its session identifier will overwrite the previous session identifier, which means that you will lose report A's session identifier. When report A is run again, even if the parameter set is the same, its execution will create a new report session and IsNewExecution will return true.

So i think this overwriting of SessionID by report server is causing the problem. But i don't know yet how to program so that it maintains proper SessionID for each user and hence doesn't crash for any user.

If anyone has any idea for solving this problem then please let me know. Thanks in advance.