Home » blog » tkim's blog

ODBC SQL Server Communication link failure(08S01:)

Posted April 30th, 2012 by tkim

We are having iMIS webserver issue, it is very slow and delay responds + hang up with error messages:

1) 08S01: [Microsoft][ODBC SQL Server Drive]Communication link faliure

2) OEProc 1/97 0 - 08S01: [Microsoft][ODBC SQL Server Drive]Communication link faliure

We have iMIS database 15.1.2 with dedicated iMIS app server and iMIS webserver separately, joined with domain server. When I shut down iMIS webserver, this issue is gone. iMIS web server seems to be cause of error, but can't find cause of issue. Our iMIS website is custom built, would code be a issue with this? Any suggestions to where to check, would be much helpful!

 

tkim's blog | login or register to post comments | printer friendly version

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

I would guess that this is a

On May 14th, 2012 jjohn says:

I would guess that this is a configuration issue. I would look at your: ImisWebServerUrl variable on your iMIS App server/SQL server. I would then look to see what you have aliased in your HOSTS file on those servers. Perhaps the App Server has your Web Server aliased to a domain that is publicly mapped to another server. I would start there. I would think it is unlikely a code bug would cause your data connection to fail but almost anything is possble.

Regards,

Joe John

Principle Consultant

John Consulting

login or register to post comments