Data Extensions - Through Business Logic

I have a multi-tier application that does a lot of business processing of
data. I am looking for a way to use SQL Report Server to render reports
based upon this data. I have looked at several examples of extensions and
built one using a serialized XML file. What I am looking for though is to be
able to create an extension that uses data that has been processed from the
business logic in real time without creating a serialized XML file. Any help
would be appreciatedHave you check my DPE? It serializes the dataset and passes it as a
parameter to the report.
http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=B8468707-56EF-4864-AC51-D83FC3273FE5
As a side node, the new controls in RS 2005 will support standalone mode
where you could bind your report to a dataset.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"mkola" <mkola@.discussions.microsoft.com> wrote in message
news:C3E61BE8-D8E8-4330-8C0E-BD0221BC3BD4@.microsoft.com...
> I have a multi-tier application that does a lot of business processing of
> data. I am looking for a way to use SQL Report Server to render reports
> based upon this data. I have looked at several examples of extensions and
> built one using a serialized XML file. What I am looking for though is to
be
> able to create an extension that uses data that has been processed from
the
> business logic in real time without creating a serialized XML file. Any
help
> would be appreciated|||THanks for the Sample Teo. I will look into it today...
Mark
"Teo Lachev [MVP]" wrote:
> Have you check my DPE? It serializes the dataset and passes it as a
> parameter to the report.
> http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=B8468707-56EF-4864-AC51-D83FC3273FE5
> As a side node, the new controls in RS 2005 will support standalone mode
> where you could bind your report to a dataset.
> --
> Hope this helps.
> ---
> Teo Lachev, MVP [SQL Server], MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com: http://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/
> ---
> "mkola" <mkola@.discussions.microsoft.com> wrote in message
> news:C3E61BE8-D8E8-4330-8C0E-BD0221BC3BD4@.microsoft.com...
> > I have a multi-tier application that does a lot of business processing of
> > data. I am looking for a way to use SQL Report Server to render reports
> > based upon this data. I have looked at several examples of extensions and
> > built one using a serialized XML file. What I am looking for though is to
> be
> > able to create an extension that uses data that has been processed from
> the
> > business logic in real time without creating a serialized XML file. Any
> help
> > would be appreciated
>
>

Data diiferentator tools

Hi All,
We have a kiosk application which will be distributed across the states
and connected to network on a cellular broadband connection. Kiosks
transmit records to our central server on a periodic basis.
We use a 3rd party vendor database in kiosks which needs to be updated
once a month. Vendor is not ready to give us a differential database so
we have to write our own utility to do this.
Are there any 3rd party tools available to this or any other
suggestions will be greatly appreciated.
Regards,
SobhanRed-Gate SQL Data Compare (www.red-gate.com)
Amos.
<Sobhan.Vezzu@.gmail.com> wrote in message
news:1150928122.648282.308070@.p79g2000cwp.googlegroups.com...
> Hi All,
> We have a kiosk application which will be distributed across the states
> and connected to network on a cellular broadband connection. Kiosks
> transmit records to our central server on a periodic basis.
> We use a 3rd party vendor database in kiosks which needs to be updated
> once a month. Vendor is not ready to give us a differential database so
> we have to write our own utility to do this.
> Are there any 3rd party tools available to this or any other
> suggestions will be greatly appreciated.
> Regards,
> Sobhan
>|||Red-Gate SQL Data Compare (www.red-gate.com)
Amos.
<Sobhan.Vezzu@.gmail.com> wrote in message
news:1150928122.648282.308070@.p79g2000cwp.googlegroups.com...
> Hi All,
> We have a kiosk application which will be distributed across the states
> and connected to network on a cellular broadband connection. Kiosks
> transmit records to our central server on a periodic basis.
> We use a 3rd party vendor database in kiosks which needs to be updated
> once a month. Vendor is not ready to give us a differential database so
> we have to write our own utility to do this.
> Are there any 3rd party tools available to this or any other
> suggestions will be greatly appreciated.
> Regards,
> Sobhan
>

Data diiferentator tools

Hi All,
We have a kiosk application which will be distributed across the states
and connected to network on a cellular broadband connection. Kiosks
transmit records to our central server on a periodic basis.
We use a 3rd party vendor database in kiosks which needs to be updated
once a month. Vendor is not ready to give us a differential database so
we have to write our own utility to do this.
Are there any 3rd party tools available to this or any other
suggestions will be greatly appreciated.
Regards,
SobhanRed-Gate SQL Data Compare (www.red-gate.com)
Amos.
<Sobhan.Vezzu@.gmail.com> wrote in message
news:1150928122.648282.308070@.p79g2000cwp.googlegroups.com...
> Hi All,
> We have a kiosk application which will be distributed across the states
> and connected to network on a cellular broadband connection. Kiosks
> transmit records to our central server on a periodic basis.
> We use a 3rd party vendor database in kiosks which needs to be updated
> once a month. Vendor is not ready to give us a differential database so
> we have to write our own utility to do this.
> Are there any 3rd party tools available to this or any other
> suggestions will be greatly appreciated.
> Regards,
> Sobhan
>

Data Design Issues

I am working on a Project Management application, and I have two data design issues I am debating.

The key element of this app, as you might expect, is Project. The project will proceed through many phases, from Planning, to Pre-Design, Design, Bid, Construction and Post Construction. All along the way there are a number of discrete tasks that must be performed and tracked.

I bounce back and forth in my mind between a single Project table that encapsulates all of these tasks, but am hesitant because I'm not a big fan of large monolithic tables. Alternatively, I could logically create separate tables for the various phases. However, this would create a series of one-to-one relationships between Project and the Phase tables, and require extra joins. The performance hit would probably not be too bad, but I would need to add extra code in either the app code or stored procedures to create an empty record in each of the phase tables when a new project is added. (Obviously, projects in planning or design will not have active records in the Construction and Post Construction tables). What are your thoughts about these choices?

Secondly, I have to manage data for a lot of individuals, which basically break down into two groups. First are internal employees who will have tasks routed to them, be invited to meetings, etc. Second are external vendors, basically contractors and consultants, who will be performing work and also be invited to meetings and such. I need to track the participants in meetings and inspections, so will have a Meeting Participant table to capture the many-to-many relationship. My issue is structuring the handling of the people. One option is to have a Person table, which basically includes everybody, with a flag field for internal or external people, and categories for their roles. Second is a table for internal folks and a table for external, or separate tables for Consultants, Contractors, and internal Employees. However, this makes capturing the meeting participants more cumbersome.

What is the collective wisdom on these? Thanks!

Jeff LittleThe place to start is the Time Tracker starter kit table design and make modification as needed. The second place is to test drive Enterprise Project Server it comes with Database templates for OLTP and OLAP to build cubes for the project. Check the link below for a demo I attended a while back with OLAP cubes, you can also search the TechNet site for more Project demos. Hope this helps.
http://www.microsoft.com/technet/community/events/project/tnt1-64.mspx

Kind regards,
Gift Peddie|||Here's my suggestion:

Project (ProjectID, ...)
Task (ProjectID, PhaseID, TaskID, TaskTypeID, TaskName, ...)
Phase (PhaseID, Name, ...)
TaskType (TaskTypeID, Name, ...)

Person (PersonID, PersonTypeID, PersonName, Username, ...)
PersonType (PersonTypeID, Name, Internal Bit, ...)|||Hi Jeff,

First off I would go with the idea of multple tables for the project instead of one. I have seen way to many applications where the number of fields and record length is outrageous given that most of the time a third to a half of the fields aren't populated. As for your concerns about adding an empty record, why? Simply do an outer join, where no matching record exists the field values from the applicable table will be null.

Lastly, people are people unless there is some compelling reason such as significant data requirements for internal as opposed to external they belong in the same table.

Cheers

Data Copy

Hi,
Currently, we are running CRM application for 125 users on SQL 2000/Windows
NT. Due to some unforseen reasons, we could not perform
capacity planning before rolling the application to the connected and remote
users. As result, our current database server is running on low memory
and most important is shortage of disk space on the C drive. We decided to
replace the existing server with another robust server, taking into
current and future requirement. With regards to server replacement, couple o
f questions and require your technical expertise.
a) The current CRM users are connected to existing server using configuratio
n file. This configuration file is stored on the users client machine
and and we like to ensure the same configuration file is used by the users.
Due to this constraint, the naming convention of new machine name
will be exactly the same name as used in our current database server machine
. We like to ensure, when the existing box is replaced with new server
the users will be connected to new server.
b) Is it possible to copy the entire SQL data lying on the existing server t
o another server. Following set of data to be copied. Can you
please let us know, which tool to be used for copying the following set of d
ata.
The data to be copied to the new server will be (Master, MSDB, Pubs, CRM app
lication data i.e (Tables, Users, SP, etc)).
DTS Packages from existing to newly built server
All the security Logins
Can you please let us know, are there any other steps which is missed out fo
r copying data from server to server. We will be testing this
process on test box before rolling out to production users.
Need your technical advise on how to proceed.
Thanks
ThomasI've used the following approach: http://www.support.microsoft.com/?i..._sql_server.htm .

Data Copy

Hi,
Currently, we are running CRM application for 125 users on SQL 2000/Windows NT. Due to some unforseen reasons, we could not perform
capacity planning before rolling the application to the connected and remote users. As result, our current database server is running on low memory
and most important is shortage of disk space on the C drive. We decided to replace the existing server with another robust server, taking into
current and future requirement. With regards to server replacement, couple of questions and require your technical expertise.
a) The current CRM users are connected to existing server using configuration file. This configuration file is stored on the users client machine
and and we like to ensure the same configuration file is used by the users. Due to this constraint, the naming convention of new machine name
will be exactly the same name as used in our current database server machine. We like to ensure, when the existing box is replaced with new server
the users will be connected to new server.
b) Is it possible to copy the entire SQL data lying on the existing server to another server. Following set of data to be copied. Can you
please let us know, which tool to be used for copying the following set of data.
The data to be copied to the new server will be (Master, MSDB, Pubs, CRM application data i.e (Tables, Users, SP, etc)).
DTS Packages from existing to newly built server
All the security Logins
Can you please let us know, are there any other steps which is missed out for copying data from server to server. We will be testing this
process on test box before rolling out to production users.
Need your technical advise on how to proceed.
Thanks
Thomas
I've used the following approach: http://www.support.microsoft.com/?id=314546 . Here the master and msdb databases are not copied to the new server. Instead you transfer the logins, jobs, packages etc as outlined here. If you plan on using the old serv
er's name, you need to run sp_dropserver and sp_addserver (after renaming the server) to change @.@.servername ie:
1. sp_dropserver 'currentservername'
2. sp_addserver 'desiredservername' , 'local'
3. restart the service and check @.@.servername
I've seen description sof the approach you're asking about but have never tried it myself - it assumes that your drive set up for example is the same. Here is a link that describes this http://vyaskn.tripod.com/moving_sql_server.htm .

Data changes in SQLExpress not committed?

Hello,

I am developing an application with a SQLExpress database. The database contains a very simple table, and I have added a Dataset object to the solution, and generated a plain Adapter object in the Dataset (using the standard VS wizard capabilities) to operate on one of the tables in de database. Just plain SELECT, INSERT operations, etc.

Strange thing is, the data changes caused by the adapter's generated Insert command (which will call the INSERT statement on the database) are only visible while the application runs (or so it seems). For example:

- I start off with the table containing 2 records, and start debugging
- perform a COUNT within the code: 2 records
- call the Insert function once from code
- perform a COUNT within the code: 3 records
- stop debugging
- inspect the table: the 3rd record doesn't exist, just the 2 records

So, it seems that the changes don't get committed, although I am not sure it is a transaction/commit problem. I haven't been able to figure out what I can do to fix this. I have used adapters before on a SQL database, no problems there. Any comments appreciated.

Cheers, JP

Try to call SqlDataAdapter.Update method after inserting records Please take a look at this link:

http://msdn2.microsoft.com/en-us/library/33y2221y(d=ide).aspx

Data Base Backup & Restore

We are in the process of migrating an application from an
Oracle data base to a SQL Server data base.
My DBA is telling me that with SQL Server he will not be
able to do a backup & restore at the 'alias' level like
he can now do with Oracle. He says he will have to do
an entire data base backup.
Is this true?In our current environment with our databases on Oracle,
we have one physical db for 1099 tax info. When it comes
to keeping the tax years separate, we set up different
aliases for each year...1099_01, 1099_02, etc. By doing
this, we are able to backup and restore at the alias
level. In case there is a problem with a
certain 'alias', we are able to restore just that
specific alias and not the entire db.
We would like to be able to do the same thing using SQL
Server, but it sounds like we may not be able to.
Any suggestions'
>--Original Message--
>Yes,
>Assuming you mean a database backup. He can also copy
out individual tables using something like DTS or BCP if
required.
>He can also do file or filegroup backups to subset
things if the db is very large, but frequently full db
backups are more than sufficient.
>What are you trying to achieve?
>Mike John
>"Don" <Don@.nomail.com> wrote in message news:08ed01c38211
$b2eb5d10$a101280a@.phx.gbl...
>> We are in the process of migrating an application from
an
>> Oracle data base to a SQL Server data base.
>> My DBA is telling me that with SQL Server he will not
be
>> able to do a backup & restore at the 'alias' level
like
>> he can now do with Oracle. He says he will have to
do
>> an entire data base backup.
>> Is this true?
>.
>

data base access

Hi,
I have problem accessing my sqlDatabase via asp.net
When running a test application I get the following error message:

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'P900\ASPNET'.

I know the connection to the db is ok since I can gain access from a simple console application.

Anybody knows what's wrong and how to fix it??
Many thanks,

Cat33Is your ASPNET user on machine P900 a user in the SQL Server you are trying to connect to?

If you are using integrated security, a console mode applicaiton might work because integrated security while you are running a console mode application uses YOUR security context. Running an ASP.NET application, you are using the ASP.NET users' security context (ASPNET by default).

You need to either add the ASPNET user to SQL Server or use a username and password.

Look at the different possible connection strings here:

www.connectionstrings.com|||Ok, thanks for quick response. I have one simple question however;
How do I add the ASPNET user to the SQL Server?
Thanks in advance,
Cat33|||Do you have Enterprise Manager? If so, Expand out the Security folder, and right click on Logins and add a new login.

If not, there is a command line tool called OSQL you can use. Find it and add the folder to the path, or from the folder where OSQL is, run the following:

osql -S servername\instancename -E -q
 --Line numbers will appear
EXEC sp_grantlogin 'COMPUTERNAME\ASPNET'
go
use <databasename>
go
EXEC sp_grantdbaccess 'COMPUTERNAME\ASPNET'
go
EXEC sp_addrolemember 'db_owner', 'COMPUTERNAME\ASPNET'
go

|||Hi,
Sorry to have to plague you with this access question, but after having done what you said, using the osql-tool, nothing improved. I still get the same Error Message, wheré the line 299 is hightlighted. I'm running Framework 1.1 with IIS 5.1 on a XP Pro machine. I have earlier been able to access the database so I simply don't know what to do. I have seen to it that the ASPNET account has been added to the directories in question. What do I do now? Do you have any idea as to where the source to the error is?
Thanks again,
Catharina

Error Message:

Login failed for user 'P900\ASPNET'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'P900\ASPNET'.

Source Error:

Line 294:
Line 295:cmd = new SqlCommand(sql, con);
Line 296:con.Open();
Line 297:
Line 298:bool doredirect = true;

Source File: c:\inetpub\wwwroot\webapperikspage\start\newuser.aspx.cs Line: 296

Stack Trace:

[SqlException: Login failed for user 'P900\ASPNET'.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
System.Data.SqlClient.SqlConnection.Open()
WebAppEriksPage.start.NewUser.InsertUser() in c:\inetpub\wwwroot\webapperikspage\start\newuser.aspx.cs:296
WebAppEriksPage.start.NewUser.btnAccept_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\webapperikspage\start\newuser.aspx.cs:147
System.Web.UI.WebControls.Button.OnClick(EventArgs e)
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
System.Web.UI.Page.ProcessRequestMain()|||When you ran the script in the previous message, you did replace COMPUTERNAME with your computer's name (P900), correct? Were there any error messages when you ran those lines through OSQL?|||Hi,
this is what I wrote:
osql - S P900\NetSDK -E -q
1> EXEC sp_grantlogin 'P900\ASPNET'
2> go

1> use Northwind
2> go

1> EXEC sp_grantdbaccess 'P900\ASPNET'
2> go

1> EXEC sp_addrolemember 'db_owner', 'P900\ASPNET'
2>go

1>exit
and I got no error messages

/Catharina|||OK. Also, replace Northwind with the name of the database you want to use. Northwind is a sample database used for that script.|||Well, at this stage the Northwind database is the database I'm using since this is a test trial to see that things work, which they don't, and I can access that database via a console application and also a Windows application.
Any more leads?|||If you added the user to the database, and there were no errors, then I cannot think of anything else.

Can you show your exact connection string (it should not have any password in it, so you should be able to just cut and paste it). If you did have access to Enterprise Manager, I would suggest looking there to verify that the user is really there.|||

con = new SqlConnection("server= p900\\NetSDK; Trusted_Connection=yes; database= Northwind");

I don't have access to Enterprise Manager, can I verify via osql?
Cheers,
Catharina|||When you start OSQL, rather than

osql -S servername\instancename -E -q

Should be, in your case:

osql -S p900\NetSDK -E -q

I have always used Trusted_Connection=true rather than =yes, so I would try that.

data application blocks for windows mobile

I've read that microsoft.applicationblocks.data for .net v2 can't be deployed to a mobile app, and my experience bears that out. So I 'm wondering if there are application blocks for windows mobile 5 that would know how to both talk to sql server mobile and sql server 2005. I see OpenNetCF has a port but as far as I can tell, they only address sql server mobile and not talking to a sql server 2005 remote database. I can use the OpenNetCF version for my sql server mobile requirements, but I'm hoping there is an encapsulation of sqlclient calls for communication with my server db.

thanks

braden

There is also a nice port at www.businessanyplace.net

http://www.businessanyplace.net/?p=daabcf

and someone did a dual database (SqlClient and System.Data.SqlServerCe) block in .Net Developer's Journal a few months ago as well.

-Darren

|||Thanks Darren. I ended up doing my own by copying the methods I needed from the full fw set.

Data Acess aplication block __How to use it on server without Microsoft

Hi all
As per my earlier conversation with Ciaran (thx for reply) I have
installed the MS APplication block on the server , when i ran Build
Enterprise Library file and Install Services from (batch files )
programme files menu it was asking for visual studio 2003 , I have only
.net framework on the server how can i use the MS application block
data access library on my server plz help...
Mukesh Agarwal
mukesh.nitb@.gmail.com
Delhi India
Ciaran O''Donnell wrote:
> The error you are getting is because the enterprise library wants to
write events to the event log and setting this up requires registry
permissions. You need to installutil the dlls for the enterprise library
(this is covered in the docs somewhere). The reason it is writing to the
event log is because the connection failed. If you setup the event log
access correctly then you will have an eventlog entry telling you why
the connection failed.
>
> HTH
>
> Ciaran O'Donnell
>
> "Mukesh" wrote:
>
>> Hi
>>
>> I have Microsoft Enterprise Library 2005 installed on my local system.
>> I m also using ASp.net 1.1 And C3 as coding language , I have MS Sql
Server 2000.
>>
>> I am developing a web application in which i am using data Access
Application Block for data access.
>>
>> I have a remote web n data server with asp.net 1.1 support
>>
>> the application is working fine here on the local server(web & data).
>>
>> when i change the data server path to the remote server it also
working fine but
>> When I uploaded the application on the remote server n tested there
it gives me the following err
>>
>>
>> ex.message was
>>
>>
>> >>The type initializer for
>>"Microsoft.Practices.EnterpriseLibrary.Data.Instrumentation.DataConnectionFailedEvent"
>>threw an exception.
>>
>> ex.Source was
>>
>> ..........Microsoft.Practices.EnterpriseLibrary.Data
>>
>> ex.trace was
>>
>> at
Microsoft.Practices.EnterpriseLibrary.Data.Instrumentation.DataConnectionFailedEvent.Fire(String
connectionString) at
Microsoft.Practices.EnterpriseLibrary.Data.Instrumentation.DataInstrumentationFacade.ConnectionFailed(String
connectionString) at
Microsoft.Practices.EnterpriseLibrary.Data.Database.OpenConnection() at
Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteReader(DBCommandWrapper
command) at property.m4.Button2_Click(Object sender, EventArgs e)
>>
>>
>> Plz help me why this is happening.........
>>
>> Mukesh Kumar agarwal
>> Delhi
>> India
>>
>>
>>
>>
>>
>>The build file calls devenv.exe, which is Visual Studio 2003. You best
option now is a command line compilation of the library. Follow the docs on
the csc.exe (C#) or vbc.exe (VB.NET) compilers.
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
*************************************************
Think outside of the box!
*************************************************
"Mukesh" <efextra@.newsgroups.nospam> wrote in message
news:45056076.3060606@.newsgroups.nospam...
> Hi all
> As per my earlier conversation with Ciaran (thx for reply) I have
> installed the MS APplication block on the server , when i ran Build
> Enterprise Library file and Install Services from (batch files ) programme
> files menu it was asking for visual studio 2003 , I have only .net
> framework on the server how can i use the MS application block data access
> library on my server plz help...
> Mukesh Agarwal
> mukesh.nitb@.gmail.com
> Delhi India
>
> Ciaran O''Donnell wrote:
> > The error you are getting is because the enterprise library wants to
> write events to the event log and setting this up requires registry
> permissions. You need to installutil the dlls for the enterprise library
> (this is covered in the docs somewhere). The reason it is writing to the
> event log is because the connection failed. If you setup the event log
> access correctly then you will have an eventlog entry telling you why the
> connection failed.
> >
> > HTH
> >
> > Ciaran O'Donnell
> >
> > "Mukesh" wrote:
> >
> >> Hi
> >>
> >> I have Microsoft Enterprise Library 2005 installed on my local
> >> system.
> >> I m also using ASp.net 1.1 And C3 as coding language , I have MS Sql
> Server 2000.
> >>
> >> I am developing a web application in which i am using data Access
> Application Block for data access.
> >>
> >> I have a remote web n data server with asp.net 1.1 support
> >>
> >> the application is working fine here on the local server(web & data).
> >>
> >> when i change the data server path to the remote server it also
> working fine but
> >> When I uploaded the application on the remote server n tested there
> it gives me the following err
> >>
> >>
> >> ex.message was
> >>
> >>
> >> >>The type initializer for
> >>"Microsoft.Practices.EnterpriseLibrary.Data.Instrumentation.DataConnectionFailedEvent"
> >>threw an exception.
> >>
> >> ex.Source was
> >>
> >> ..........Microsoft.Practices.EnterpriseLibrary.Data
> >>
> >> ex.trace was
> >>
> >> at
> Microsoft.Practices.EnterpriseLibrary.Data.Instrumentation.DataConnectionFailedEvent.Fire(String
> connectionString) at
> Microsoft.Practices.EnterpriseLibrary.Data.Instrumentation.DataInstrumentationFacade.ConnectionFailed(String
> connectionString) at
> Microsoft.Practices.EnterpriseLibrary.Data.Database.OpenConnection() at
> Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteReader(DBCommandWrapper
> command) at property.m4.Button2_Click(Object sender, EventArgs e)
> >>
> >>
> >> Plz help me why this is happening.........
> >>
> >> Mukesh Kumar agarwal
> >> Delhi
> >> India
> >>
> >>
> >>
> >>
> >>
> >>|||I didnt mean install the enterprise library with the MSI file.
I mean't for each dll in the EL you use:
call InstallUtil.exe passing in the name of the dll. This will invoke the
custominstaller classes inside the dll's to register them selves in teh event
log and things.
Ciaran O'Donnell
"Mukesh" wrote:
> Hi all
> As per my earlier conversation with Ciaran (thx for reply) I have
> installed the MS APplication block on the server , when i ran Build
> Enterprise Library file and Install Services from (batch files )
> programme files menu it was asking for visual studio 2003 , I have only
> .net framework on the server how can i use the MS application block
> data access library on my server plz help...
> Mukesh Agarwal
> mukesh.nitb@.gmail.com
> Delhi India
>
> Ciaran O''Donnell wrote:
> > The error you are getting is because the enterprise library wants to
> write events to the event log and setting this up requires registry
> permissions. You need to installutil the dlls for the enterprise library
> (this is covered in the docs somewhere). The reason it is writing to the
> event log is because the connection failed. If you setup the event log
> access correctly then you will have an eventlog entry telling you why
> the connection failed.
> >
> > HTH
> >
> > Ciaran O'Donnell
> >
> > "Mukesh" wrote:
> >
> >> Hi
> >>
> >> I have Microsoft Enterprise Library 2005 installed on my local system.
> >> I m also using ASp.net 1.1 And C3 as coding language , I have MS Sql
> Server 2000.
> >>
> >> I am developing a web application in which i am using data Access
> Application Block for data access.
> >>
> >> I have a remote web n data server with asp.net 1.1 support
> >>
> >> the application is working fine here on the local server(web & data).
> >>
> >> when i change the data server path to the remote server it also
> working fine but
> >> When I uploaded the application on the remote server n tested there
> it gives me the following err
> >>
> >>
> >> ex.message was
> >>
> >>
> >> >>The type initializer for
> >>"Microsoft.Practices.EnterpriseLibrary.Data.Instrumentation.DataConnectionFailedEvent"
> >>threw an exception.
> >>
> >> ex.Source was
> >>
> >> ..........Microsoft.Practices.EnterpriseLibrary.Data
> >>
> >> ex.trace was
> >>
> >> at
> Microsoft.Practices.EnterpriseLibrary.Data.Instrumentation.DataConnectionFailedEvent.Fire(String
> connectionString) at
> Microsoft.Practices.EnterpriseLibrary.Data.Instrumentation.DataInstrumentationFacade.ConnectionFailed(String
> connectionString) at
> Microsoft.Practices.EnterpriseLibrary.Data.Database.OpenConnection() at
> Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteReader(DBCommandWrapper
> command) at property.m4.Button2_Click(Object sender, EventArgs e)
> >>
> >>
> >> Plz help me why this is happening.........
> >>
> >> Mukesh Kumar agarwal
> >> Delhi
> >> India
> >>
> >>
> >>
> >>
> >>
> >>
>|||Install the .msi on a development machine with VS2003.
Look at the .bat files.
You need to not find the compile code (csc or dev.exe), but rather the code
that installs the services.
You need the rights to install services , especially on a Server Machine.
Make sure the framework (free download) is installed on the server also.
"Mukesh" <efextra@.newsgroups.nospam> wrote in message
news:45056076.3060606@.newsgroups.nospam...
> Hi all
> As per my earlier conversation with Ciaran (thx for reply) I have
> installed the MS APplication block on the server , when i ran Build
> Enterprise Library file and Install Services from (batch files )
> programme files menu it was asking for visual studio 2003 , I have only
> .net framework on the server how can i use the MS application block
> data access library on my server plz help...
> Mukesh Agarwal
> mukesh.nitb@.gmail.com
> Delhi India
>
> Ciaran O''Donnell wrote:
> > The error you are getting is because the enterprise library wants to
> write events to the event log and setting this up requires registry
> permissions. You need to installutil the dlls for the enterprise library
> (this is covered in the docs somewhere). The reason it is writing to the
> event log is because the connection failed. If you setup the event log
> access correctly then you will have an eventlog entry telling you why
> the connection failed.
> >
> > HTH
> >
> > Ciaran O'Donnell
> >
> > "Mukesh" wrote:
> >
> >> Hi
> >>
> >> I have Microsoft Enterprise Library 2005 installed on my local
system.
> >> I m also using ASp.net 1.1 And C3 as coding language , I have MS Sql
> Server 2000.
> >>
> >> I am developing a web application in which i am using data Access
> Application Block for data access.
> >>
> >> I have a remote web n data server with asp.net 1.1 support
> >>
> >> the application is working fine here on the local server(web & data).
> >>
> >> when i change the data server path to the remote server it also
> working fine but
> >> When I uploaded the application on the remote server n tested there
> it gives me the following err
> >>
> >>
> >> ex.message was
> >>
> >>
> >> >>The type initializer for
>>"Microsoft.Practices.EnterpriseLibrary.Data.Instrumentation.DataConnect
ionFailedEvent"
> >>threw an exception.
> >>
> >> ex.Source was
> >>
> >> ..........Microsoft.Practices.EnterpriseLibrary.Data
> >>
> >> ex.trace was
> >>
> >> at
>
Microsoft.Practices.EnterpriseLibrary.Data.Instrumentation.DataConnectionFai
ledEvent.Fire(String
> connectionString) at
>
Microsoft.Practices.EnterpriseLibrary.Data.Instrumentation.DataInstrumentati
onFacade.ConnectionFailed(String
> connectionString) at
> Microsoft.Practices.EnterpriseLibrary.Data.Database.OpenConnection() at
>
Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteReader(DBCommandW
rapper
> command) at property.m4.Button2_Click(Object sender, EventArgs e)
> >>
> >>
> >> Plz help me why this is happening.........
> >>
> >> Mukesh Kumar agarwal
> >> Delhi
> >> India
> >>
> >>
> >>
> >>
> >>
> >>|||Dear Mukesh,
I am interested in this issue. Would you mind letting me know the result of
the suggestions? If you need further assistance, feel free to let me
know. I will be more than happy to be of assistance.
Have a great day!
Charles Wang
Microsoft Online Community Support
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

Data access method

I have built a WM5 SQLce2005 application using, primarily, table adapters which sparked a discussion whether it is more effiecent to use table adapters or use SQLce command execution with coding for a device.

Are there any papers / threads or thoughts as to the best access method to use?

The best access method in terms of performance and memory overhead is SQLCeResultset and SQLCEdatareader. There are various performance papers out there, for example: http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?culture=en-US&EventID=1032307726&CountryCode=US

Data Access components with MSSQL 2000

Can I use an application developed with DAO, ADO or RDO with MSSQL 2000?
(I'm migrating the server)
Are there compatibility issues?
Greetings,Yes, you can access SQL Server 2000 using ADO, so an application that can
reference ADO can access SQL Server 2000. That's typically what ADO is used
for. ADO superceeds RDO and DAO, but I believe they can still use the SQL
Server 2000 provider.
"MedioYMedio" <MedioYMedio@.discussions.microsoft.com> wrote in message
news:72CBE14D-5F52-45C9-8CDA-D702B62DA444@.microsoft.com...
> Can I use an application developed with DAO, ADO or RDO with MSSQL 2000?
> (I'm migrating the server)
> Are there compatibility issues?
> Greetings,

Data Access Application Block: Using in Class Library

I'm trying to use the Data Access Application block, and am having some issues with configuration. I am using it in a class library, and it seems that with v 3 you need to configure the DAAB first, making changes to the configuration file. However, in a class library, I do not seem to have the web.config or app.config file to change. So where do I need to store the configuration settings?

Thanks,

Paul

I think you dont need to care about the Configuration in Class Library ... that will be Handled by the Application in which your Class Library is used.

For now you can Sample Application with Proper Configuration and use your class Library in that to test.

|||

I am trying to put my data access code in the class library, though. How can I configure the DAAB to work WITHIN there? Or do I need to pull all data access code out of the class library and into the application?

The library I am developing will be used by several applications, so I would like to encapsulate the data aceess there...

Ideally, I would like to designate the database configuration I am using at run-time, by passing the connection string info in from the consuming applications...

|||

Once after creating DAL then you can keep both Enterprise and DAL dlls can be placed in Web App or Windows app. And all the required configuration can be added in Web.Config and App.Config filesrespectively. We are doing same with Enterprise Library 3.1

Data Access Application Block for SQLClient

I download the DAAB CF version. However, most of them use SQLCEClient to connect to the database. Is there any DAAB that use SQLClient?
One workaround that I made is I replaced all SQLCEClient objects with the SQLClient objects. I only test one method "ExecuteDataset" and it works so far. However, my question is "does my workaround a good solution?"

Thanks,
Hendra

You might want to explore the new Mobile Client Software Factory. I believe it has data access blocks for both SQL CE/Mobile and SqlClient contained in the framework. http://msdn.microsoft.com/mobility/default.aspx?pull=/library/en-us/dnpag2/html/mcsflp.asp

Darren

Damaged PDF files

Hi,
I have created a web application with ASP.Net 2.0. I also have created a
report using Reporting Services 2005. After showing the report on the
screen, I give the suer the possibility to export to report. One of the
possibilities is PDF. Now we have some troubles with this export.
On some PC's after saving or opening the PDF we got the message :
"There was an error opening this document. The file is damaged and could
not be repaired"
It only appears on some PC's, on other PC's exporting the same documents
works fine. It also didn't have any effect on the version of Acrobat. The
problems comes with Acro v 5, 7 and 8. Even after upgrading, deinstalling,
rebooting, installing a newer version the problem still exists on those PC's.
So I hope that someone have a solution for this as we don't know if it's a
problem with reporting services or with acrobat.
Txs in advance.On Apr 30, 4:36 am, Cipidos <Cipi...@.discussions.microsoft.com> wrote:
> Hi,
> I have created a web application with ASP.Net 2.0. I also have created a
> report using Reporting Services 2005. After showing the report on the
> screen, I give the suer the possibility to export to report. One of the
> possibilities is PDF. Now we have some troubles with this export.
> On some PC's after saving or opening the PDF we got the message :
> "There was an error opening this document. The file is damaged and could
> not be repaired"
> It only appears on some PC's, on other PC's exporting the same documents
> works fine. It also didn't have any effect on the version of Acrobat. The
> problems comes with Acro v 5, 7 and 8. Even after upgrading, deinstalling,
> rebooting, installing a newer version the problem still exists on those PC's.
> So I hope that someone have a solution for this as we don't know if it's a
> problem with reporting services or with acrobat.
> Txs in advance.
I've never seen this occur before; however, from what you are saying,
it seems that it is a non-Reporting Services issue. Traditionally, if
it was SSRS, then all of the machines would be behaving the same way.
It may not be related to Acrobat either; however, I'm not sure what
could be causing the problem (missing Adobe update, missing MS Office
update, etc). Sorry that I could not be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Cyrillic problem with cr10 on XP and 2003

When I run my application on windows 2000 everything is ok. But on XP service pack 2 and windows 2003 words in report cut at the end of the line. Words a written in cyrillic alphabet. Does anybody meet this problem?Set Can Grow option for that field

Customizing report columns count at runtime

Hello all. In my application I have some rdl file that determines
general look of my report. Also I have a table that has 20 columns I
have stored proc that returns dataset that also has 20 columns but may
have filled less than 20 columns (5 for example). The problem is how
to hide another (20-n) columns.
Now I simply pass params to report and hide columns according to these
params.In this case I have normally rendered report on screen and I'm
experiencing problems with printing: I have my "n" columns printed
normally then long space and table end line ( in another printed
page ) what looks ugly.
So my question is: can I dynamically manage columns count ( without
having to generate rdl programatically :) ), for example pass report
param "ColumnsCount" and then have so much columns as I want (also
apply binding values for these columns)
or
is there a method how to hide my (20-n) columns and minimize table so
I do not have that big white space and ugly line after it.
Any ideas?
Thanks in advanceOn Apr 30, 4:15 am, mblishch <mykhaylo.blis...@.gmail.com> wrote:
> Hello all. In my application I have some rdl file that determines
> general look of my report. Also I have a table that has 20 columns I
> have stored proc that returns dataset that also has 20 columns but may
> have filled less than 20 columns (5 for example). The problem is how
> to hide another (20-n) columns.
> Now I simply pass params to report and hide columns according to these
> params.In this case I have normally rendered report on screen and I'm
> experiencing problems with printing: I have my "n" columns printed
> normally then long space and table end line ( in another printed
> page ) what looks ugly.
> So my question is: can I dynamically manage columns count ( without
> having to generate rdl programatically :) ), for example pass report
> param "ColumnsCount" and then have so much columns as I want (also
> apply binding values for these columns)
> or
> is there a method how to hide my (20-n) columns and minimize table so
> I do not have that big white space and ugly line after it.
> Any ideas?
> Thanks in advance
You should be able to toggle visibility of the columns in the report
via an expression. Right-clicking the column in the table control and
selecting properties and select the tab for visibility and then enter
an expression that checks for the sum of the column's value. Something
like this should work:
=iif(Sum(Fields!ColumnItemX.Value) > 0, "true", "false")
Also, you might want to make sure that for individual cells, the
shrink to fit (or similar wording) is selected and that you
conditionally set border styles based on if the column is visible
(via, Properties -> Border Style: =iif(Sum(Fields!ColumnItemX.Value) >
0, "Solid", "None"))
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant