梦想报表FAQ 点击:289 | 回复:1



DreamReport

    
  • 精华:0帖
  • 求助:0帖
  • 帖子:16帖 | 20回
  • 年度积分:0
  • 历史总积分:96
  • 注册:2008年5月14日
发表于:2008-07-07 10:23:48
楼主

ID: 000001 – Web Portal – PHP.ini configuration
Q:
In the DR Web portal I’m getting strange messages: “Notice…”
A:
During DR installation we are installing PHP component, it requires distribution of
php.ini into Windows directory. If on the computer PHP was already installed php.ini
won’t be overwritten. So in order to resolve that problem you have to modify php.ini
manually:
Go to Window directory, find and open it. In side you’ll find “Error handling and
logging” section. As a parameter put:
error_reporting = E_ALL & ~E_NOTICE & ~E_STRICT
Then save it and restart DR web portal.
ID: 000002 – Configuration of Remote DSN
Q:
How to configure the DSN for remote SQL server?
A:
1. You have to ensure that TCP/IP connection is enabled on SQL server and remote
access to SQL server configured well. For Example port 1433 is open in firewall
and router properly set. (See your System Administrator for more details)
2. See movie “DR_To_SQL_Tutorial” located in the same directory as FAQ
ID: 000003 – Schedule Backup of MS SQL server DB
Q:
How to schedule backups for my SQL 2005 Express DR Data Base?
A:
1. You have to ensure that you have administrative rights to access SQL 2005
Express server
2. Import the “expressmaint.sql” sql script which is located in the same directory as
FAQ to SQL server.
3. user script is following:
execexpressmaint
@database = 'ALL_USER',
@optype = 'DB',
@backupfldr = '<path>\backups',
@reportfldr = '<path>\BackupReport',
@verify = 1,
@dbretainunit = 'days',
@dbretainval = 1,
Ocean Data Systems Ltd
The Art of Industrial Intelligence
Page 3 of 20
@rptretainunit = 'days',
@rptretainval = 1,
@report = 1
Save this script with sql extension
4. Create bat file which launch user script as follow:
SQLCMD.EXE -S . -i "<path>\userfullbackup.sql"
5. Create fake report in DR, schedule execution time of it according your needs and
in Report Settings define macro that executes bat file from p.4.
ID: 000004 – Setup proper permission for Web folder in DR.
Q:
How to set permission for Web folder in order to ensure proper report generation from
Dream Report Web portal?
A:
In case of generation problem using the web portal, you have to make sure the
web folder of the project has read/write permissions for everyone.
So, if you right click the web folder of the project, then choose properties from
context menu. The folder properties dialog will be opened; you should have a
security tab. If you don't, it means that you are either using a FAT32 partition, or
that you are using Simple Sharing mode. To switch from simple sharing mode to
regular one, from Windows Explorer, go to the tools menu, then Folder options,
go to the second tab (View), then uncheck the last check box of the advanced
properties as shown in the screen shot below:

 

  未完待续




DreamReport

  • 精华:0帖
  • 求助:0帖
  • 帖子:16帖 | 20回
  • 年度积分:0
  • 历史总积分:96
  • 注册:2008年5月14日
发表于:2008-07-07 10:25:56
1楼
Ocean Data Systems Ltd
The Art of Industrial Intelligence
Page 4 of 20
.
If you are using a FAT32 partition, there are no security settings, so the problem
is somewhere else and might be more complex. Please contact Support to resolve
this issue.
So once you have the security tab available, make sure you have an entry
"IUSR_<computer name>" with modify or full control setting. If you don't, then
add a new user to the list and give it read/write access by either checking
"modify" or "full control" as shown in the screenshot below:
Ocean Data Systems Ltd
The Art of Industrial Intelligence
Page 5 of 20
In French, instead of typing "IUSR_<computer name>", type "Tout le monde"
and similar to "IUSR_<computer name>" in other OS languages.
Then it should be ok.
Just to summarize:
1 - Right Click the Web folder
2 - Properties -> Security
3 - Add "IUSR_<computer name>" with modify access

热门招聘
相关主题

官方公众号

智造工程师