Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
goltzs
Starting Member
1 Post |
 Posted - 2010-02-24 : 07:11:53
|
| Hi,I have developed reports on our SQL server SSRS 2005 that draw data from our ERP system. The data are stored in another server with informix DB and I've managed to connect the informix server via ODBC. The connection works fine most of the times but occasionally it get stuck and none of the reports are working. In order to solve this i have to restart SQL service!!Do you have some kind of idea what is causing this failure?Thanks! |
|
|
Jaime
Starting Member
19 Posts |
Posted - 2010-02-26 : 23:43:19
|
| I find it strange that restarting the SQL Server service fixes your connection issue from SSRS to Informix. Are you connecting to Informix through the local SQL server by using a linked server? |
 |
|
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
Posted - 2010-02-27 : 02:44:39
|
| How big are the reports? Could be a blocking? |
|
|
|
|
|
|
ODBC Connection Stuck