Rank: Member
Groups: Registered
Joined: 11/10/2016(UTC) Posts: 14  Location: 江苏 Thanks: 2 times
|
I can view report using Sealreport designer and publish report to iis OK.
but dont access report using browser.
report error:
15:42:12 Error in model 'model': Unexpected error when executing the following SQL statement:
SELECT
ts_tj_login_201612.day AS C0,
Sum(ts_tj_login_201612.uid) AS C1
FROM ts_tj_login_201612
GROUP BY ts_tj_login_201612.day
ORDER BY ts_tj_login_201612.day ASC,Sum(ts_tj_login_201612.uid) ASC
Error detail:
Error opening database connection:
ERROR [IM002] [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
It looks like the security configured by your IIS publication (by default LocalSystem user in the dedicated application pool) is incorrect (not the same when you run a report with the Report Designer).
It occurs often with SQLServer when you have a trusted authentication...
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 11/10/2016(UTC) Posts: 14 Location: 江苏 Thanks: 2 times
|
tks for your replay.
I connect to MySQL database and dont configure data source on seal server manager.
only configure mysql data source on Seal Report Designer.run excute report Ok on sealreport designer.
so i want to confirm whether need to configure data source on seal server manager first? then developer report on seal report desginer second. thanks.
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 11/10/2016(UTC) Posts: 14 Location: 江苏 Thanks: 2 times
|
Hi ，
When publish report to iis whether modify Server settings “default connecting string”?
Would you give me a document for how to publish report ? Now had to develop report completely,but not publish.....
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 11/10/2016(UTC) Posts: 14 Location: 江苏 Thanks: 2 times
|
I check data sources on seal server manager normally. 17:05:57 Starting check Data Sources 17:05:57 Checking data source 'pu' 17:05:57 Checking Connections... 17:05:57 Checking connection 'pu2':OK 17:05:57 Connections: 1 Connection(s) checked 17:05:57 Checking Tables... ..... ....... 17:05:59 Checking table 'ts_user':OK 17:06:00 Checking table 'ts_user_yuehuo':OK 17:06:00 Tables: 12 Table(s) checked 17:06:00 Checking Joins... 17:06:00 Joins: 0 Join(s) checked 17:06:00 Checking Enums... 17:06:00 Enums: 0 Enum(s) checked 17:06:00 1 Data Source(s) checked 17:06:00 Check Data Sources terminated 17:06:00 Youpi, pas d'erreur ! Edited by user Wednesday, December 7, 2016 9:08:18 AM(UTC)
| Reason: Not specified
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
I do not understand the issue, your Data Source is fine with the Server Manager and the Report Designer.
When you publish reports on the Web Report Server, the only difference is that user executing the report is the one configured by your IIS publication...
You just have to make sure that this user has the rights necessary to execute a report...
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 11/10/2016(UTC) Posts: 14 Location: 江苏 Thanks: 2 times
|
I had test on wins server 2008,wins7, wins10.but the same issue happened.
1.i want to confirm whether need to configure data source on seal report manager?
2.Do you have other method to publish report?
thanks
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
what is the error message exactly (not in chinese please...) ?
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 11/10/2016(UTC) Posts: 14 Location: 江苏 Thanks: 2 times
|
Only report error on IIS.i connect to remote mysql database using odbc ,not local mysql database system.
report error:
15:42:12 Error in model 'model': Unexpected error when executing the following SQL statement:
SELECT
ts_tj_login_201612.day AS C0,
Sum(ts_tj_login_201612.uid) AS C1
FROM ts_tj_login_201612
GROUP BY ts_tj_login_201612.day
ORDER BY ts_tj_login_201612.day ASC,Sum(ts_tj_login_201612.uid) ASC
Error detail:
Error opening database connection:
ERROR [IM002] [Microsoft][ODBC Driver manager] did not discover the name of the data source and did not specify the default driver
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
I think it is classic: you created an ODBC data source for your user and not for the system,
so when the web report server runs as localsystem, he can not see the DSN defined...
Make sure that you have created a System Data Source for your ODBC.
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 11/10/2016(UTC) Posts: 14 Location: 江苏 Thanks: 2 times
|
Thanks for your means,
I create a system DSN and run normally.
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
