logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
vicry21  
#1 Posted : Tuesday, December 6, 2016 7:55:17 AM(UTC)
vicry21

Rank: Member

Groups: Registered
Joined: 11/10/2016(UTC)
Posts: 14
China
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 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序


epf  
#2 Posted : Tuesday, December 6, 2016 8:52:58 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 552
Switzerland

Thanks: 7 times
Was thanked: 78 time(s) in 76 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...
vicry21  
#3 Posted : Tuesday, December 6, 2016 1:03:12 PM(UTC)
vicry21

Rank: Member

Groups: Registered
Joined: 11/10/2016(UTC)
Posts: 14
China
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.
vicry21  
#4 Posted : Tuesday, December 6, 2016 1:36:34 PM(UTC)
vicry21

Rank: Member

Groups: Registered
Joined: 11/10/2016(UTC)
Posts: 14
China
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.....
vicry21  
#5 Posted : Wednesday, December 7, 2016 9:07:07 AM(UTC)
vicry21

Rank: Member

Groups: Registered
Joined: 11/10/2016(UTC)
Posts: 14
China
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

epf  
#6 Posted : Wednesday, December 7, 2016 10:02:56 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 552
Switzerland

Thanks: 7 times
Was thanked: 78 time(s) in 76 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...

vicry21  
#7 Posted : Wednesday, December 7, 2016 1:40:15 PM(UTC)
vicry21

Rank: Member

Groups: Registered
Joined: 11/10/2016(UTC)
Posts: 14
China
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
epf  
#8 Posted : Wednesday, December 7, 2016 2:15:17 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 552
Switzerland

Thanks: 7 times
Was thanked: 78 time(s) in 76 post(s)
what is the error message exactly (not in chinese please...) ?
vicry21  
#9 Posted : Wednesday, December 7, 2016 2:27:06 PM(UTC)
vicry21

Rank: Member

Groups: Registered
Joined: 11/10/2016(UTC)
Posts: 14
China
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
epf  
#10 Posted : Wednesday, December 7, 2016 2:39:01 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 552
Switzerland

Thanks: 7 times
Was thanked: 78 time(s) in 76 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.
vicry21  
#11 Posted : Friday, December 9, 2016 6:05:29 AM(UTC)
vicry21

Rank: Member

Groups: Registered
Joined: 11/10/2016(UTC)
Posts: 14
China
Location: 江苏

Thanks: 2 times
Thanks for your means,
I create a system DSN and run normally.
Users browsing this topic
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.