Credentials and ReportViewer

I'm building a simple report request page that makes use of the
reportviewer found in the samples. From the web server that hosts
this page, I'd like to impersonate a user to gain access to RS running
on another server. I've not been able to find instructions how how to
do this. It appears that ReportViewer makes use of the RS web service
but does not expose anything that allows passing along credentials.
I'm sure I'm missing something obvious so sorry in advance.Mark,
The ReportViewer sample control doesn't use the RS Web service. Instead, it
uses URL addressibility by firing an HTTP-GET request on the client side
(IFRAME) to the Report Server. This means, that the control requires direct
access to the Report Server. If the default Windows-based security is used,
the Report Server will see the incoming request under the credentials of the
interactive user, so no need of impersonating the user.
--
Hope this helps.
----
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com : http://tinyurl.com/3l49j
Home page and blog: http://www.prologika.com/
----
"MarkMurphy" <murphy@.murphysw.com> wrote in message
news:e061eb57.0408261430.289dc804@.posting.google.com...
> I'm building a simple report request page that makes use of the
> reportviewer found in the samples. From the web server that hosts
> this page, I'd like to impersonate a user to gain access to RS running
> on another server. I've not been able to find instructions how how to
> do this. It appears that ReportViewer makes use of the RS web service
> but does not expose anything that allows passing along credentials.
> I'm sure I'm missing something obvious so sorry in advance.

CRecordset takes 10 seconds to open

Hi All

I'm new to sql server. I have built simple database apps using MFC CRecordset over MS Access. I'm tying to learn about SQL server by building a simple app using MFC CRecordset in Visual Studio 2005.

I have multiple CRecordset classes within my app. When I developed the app over MS Access I read somewhere that it was better to have a single database object that is shared by multiple recordsets. So I ended up with something like this -

Code Snippet

// In the class header - 2 CRecordset derived classes

CMyRecordSet m_MyRecordSet; // Connects to the database using

// its "GetDefaultConnect" string

CAnotherSet * m_pAnotherSet;

// Within a "CreateRecordSets" method

if (!m_MyRecordSet.IsOpen()) m_MyRecordSet.Open();

// This works fine

m_pAnotherSet = new CAnotherSet (m_MyRecordSet.m_pDatabase);

m_pAnotherSet->Open();

// This open takes 10s to execute,

// there are 10 rows of data in the table

I have about 6 recordsets that I create in this way, there is a tiny amount of data in the database. The open for the next record sets return immediately.

The same app over MS Access works fine - no delays. SQLServer Express and Access are both running on my development PC.

Can anyone tell me why this call takes so long and whether there is a way of avoiding it?

Subsequent calls to the database return immediately.

Thanks

Alec

SQL Server 2005 Express 9.00.3042.00

Microsoft SQL Server Management Studio Express 9.00.2047.00

Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

I thought that I had found the cause of this but I've only found out how to reproduce it.

If I change the character set to unicode in the Visual Studio 2005 project settings the problem goes away. (This is an MFC SDI form view application.) I had originally creating my sql database tables by exporting them from Access and this had created nvarchars. I changed these to varchars but still I get the 10s delay when the project is built with "No Character set" selected. I'm not sure what the side affects of leaving unicode selected may be so I don't really want to change this without understanding the underlying cause.

In the CRecorset code generated by visual studio it says

// The string types below (if present) reflect the actual data type of the

// database field - CStringA for ANSI datatypes and CStringW for Unicode

// datatypes. This is to prevent the ODBC driver from performing potentially

// unnecessary conversions. If you wish, you may change these members to

// CString types and the ODBC driver will perform all necessary conversions.

// (Note: You must use an ODBC driver version that is version 3.5 or greater

// to support both Unicode and these conversions).

My ODBC driver version is 2000.85.1117.00 - am I looking at bthe wrong version number? (this is from the ODBC create new datasource window).

I have varchars being loaded in CString so is there any conversion necessary? (even if there was this convserion should not take so long).

Can anyone explain the delay related to selected charatcter set?

Thanks

Alec

Creating two dimensions referencing the same table

Hi,

I am building a cube in the 2005 Analysis Services. I built the cube successfully when each of my dimensions referenced exactly one table. Now I want to extend that to build two dimensions based on one table. I can build the 2nd dimension but I cannot use it within the cube.

Any suggestions on how to do that?

Thanks in advance,

Aref

Any reason why you can't build 1 dimension and use it in 2 roles within your cube (eg: Date dimension in Adventure Works plays 3 roles)?

Creating SQL Server CE database on server

Is it possible to create a SQL server CE 2.0 database on a desktop
running SQL Server? We're currently building the database on the device
itself but would like to prebuild it on the server and just send it
down. Microsoft describes something in:
http://support.microsoft.com/default...301217&sd=tech
This really seems like just a hack.
You can create the databases on the PPC emulator, so I didn't think it
would be too far of a stretch to create them on the server.
the really great news is you can create it on the desktop/server in SQL
2005! However, the method described in the link you have provided is the way
I have always done it.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Chris Karcher" <ckarcher@.mail.utexas.edu> wrote in message
news:ehb1c8$7k9$1@.geraldo.cc.utexas.edu...
> Is it possible to create a SQL server CE 2.0 database on a desktop running
> SQL Server? We're currently building the database on the device itself
> but would like to prebuild it on the server and just send it down.
> Microsoft describes something in:
> http://support.microsoft.com/default...301217&sd=tech
> This really seems like just a hack.
> You can create the databases on the PPC emulator, so I didn't think it
> would be too far of a stretch to create them on the server.
|||Yea, it's really cool that SQL Mobile (Everywhere?) can be used on all
platforms. It's just that we aren't quite ready to switch yet..
Hilary Cotter wrote:
> the really great news is you can create it on the desktop/server in SQL
> 2005! However, the method described in the link you have provided is the way
> I have always done it.
>

Creating SQL Server CE database on server

Is it possible to create a SQL server CE 2.0 database on a desktop
running SQL Server? We're currently building the database on the device
itself but would like to prebuild it on the server and just send it
down. Microsoft describes something in:
http://support.microsoft.com/default.aspx?scid=kb;en-us;301217&sd=tech
This really seems like just a hack.
You can create the databases on the PPC emulator, so I didn't think it
would be too far of a stretch to create them on the server.the really great news is you can create it on the desktop/server in SQL
2005! However, the method described in the link you have provided is the way
I have always done it.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Chris Karcher" <ckarcher@.mail.utexas.edu> wrote in message
news:ehb1c8$7k9$1@.geraldo.cc.utexas.edu...
> Is it possible to create a SQL server CE 2.0 database on a desktop running
> SQL Server? We're currently building the database on the device itself
> but would like to prebuild it on the server and just send it down.
> Microsoft describes something in:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;301217&sd=tech
> This really seems like just a hack.
> You can create the databases on the PPC emulator, so I didn't think it
> would be too far of a stretch to create them on the server.|||Yea, it's really cool that SQL Mobile (Everywhere?) can be used on all
platforms. It's just that we aren't quite ready to switch yet..
Hilary Cotter wrote:
> the really great news is you can create it on the desktop/server in SQL
> 2005! However, the method described in the link you have provided is the way
> I have always done it.
>

Creating SQL Server CE database on server

Is it possible to create a SQL server CE 2.0 database on a desktop
running SQL Server? We're currently building the database on the device
itself but would like to prebuild it on the server and just send it
down. Microsoft describes something in:
http://support.microsoft.com/defaul...;301217&sd=tech
This really seems like just a hack.
You can create the databases on the PPC emulator, so I didn't think it
would be too far of a stretch to create them on the server.the really great news is you can create it on the desktop/server in SQL
2005! However, the method described in the link you have provided is the way
I have always done it.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Chris Karcher" <ckarcher@.mail.utexas.edu> wrote in message
news:ehb1c8$7k9$1@.geraldo.cc.utexas.edu...
> Is it possible to create a SQL server CE 2.0 database on a desktop running
> SQL Server? We're currently building the database on the device itself
> but would like to prebuild it on the server and just send it down.
> Microsoft describes something in:
> http://support.microsoft.com/defaul...;301217&sd=tech
> This really seems like just a hack.
> You can create the databases on the PPC emulator, so I didn't think it
> would be too far of a stretch to create them on the server.|||Yea, it's really cool that SQL Mobile (Everywhere?) can be used on all
platforms. It's just that we aren't quite ready to switch yet..
Hilary Cotter wrote:
> the really great news is you can create it on the desktop/server in SQL
> 2005! However, the method described in the link you have provided is the w
ay
> I have always done it.
>