Wednesday, November 26, 2003

 

SELECT from linked table (in MS SQL 2000)

select * from openquery(pdox,'select * from dtfile where DTNO=''12158803''')

 

How to fix problem with access to application log from ASP.NET

If you get error:
"Requested registry access is not allowed"
during "EventLog.WriteEntry" operation, then do this:
1) Create win application which will create Event Source for application log:
EventLog.CreateEventSource
You can use "CreateLogSource" winapplication which I already created (2003-11-26).
2) You should have Administrator's privileges on the computer which will be used as Web Server (your ASP.NET code will log into Application log of this computer).
3) Execute "EventLog.CreateEventSource" with SpecificSource.
4) Your Web-application should use only this SpecificSource source for "EventLog.WriteEntry" operation.

Tuesday, November 25, 2003

 

Crystal Reports run-time installer package

\\DENNISGORELIK\INSTALL\CrystalReports\cr9netredist.msi

I got it from cr9netredist.zip.
However it requires serial number.
Crystal Reports developers number doesn't work :-(

Monday, November 24, 2003

 

General information about Crystal Reports deployment

General information about Crystal Reports deployment

cr9netmergemodules.zip
cr9netredist.zip


 

Prepare Crystal Reports deployment package

How to prepare Web Project deployment package with Crystal Reports


1) Open solution with Crystal Reports project(s):
*.rpt files, classes which use Crystal Reports and so on...

2) Right-mouse-click on the solution file -> Add -> New Project -> Web Setup Project

3) Right-mouse-click on the WebSetupProject -> Add -> Project Output

4) In "Add Project Output Group" dialog box select:
- "Primary Output".
- "Content Files".

5) Right-mouse-click on the WebSetupProject -> Add -> Merge Modules
- add "dotNETFXRedist_x86.msm" (C:\Program Files\Microsoft Visual Studio .NET 2003\Common7\Tools\Deployment\dotNETFXRedist_x86.msm).
- add "Crystal_Managed2003.msm" (C:\Program Files\Common Files\Merge Modules\Crystal_Managed2003.msm).
- add "Crystal_regwiz2003.msm" (C:\Program Files\Common Files\Merge Modules\Crystal_regwiz2003.msm).
- add "Crystal_Database_Access2003.msm" (C:\Program Files\Common Files\Merge Modules\Crystal_Database_Access2003.msm).
- add "Crystal_Database_Access2003_enu.msm" (C:\Program Files\Common Files\Merge Modules\Crystal_Database_Access2003_enu.msm).


6) Set License Key (it's a must!)
Right-mouse-click on Crystal_regwiz2003.msm -> Properties -> Expand "MergeModuleProperties" -> Set "License Key" = AAP50-GS00000-U7000RN (or to your Crystal Reports License key which you can find in "Help -> About Microsoft Development Environment -> Crystal Reports for Visual Studio Net".

 
How to deploy the project:
http://www.wurzburg.com/DataReports/
File share: \\iisserver\c$\SiteDirectory\Wurzburg\DataReports
If Crystal Reports still doesn't work --- try to reboot computer.

This page is powered by Blogger. Isn't yours?