sqla12 customer down after os patch

[Former Member]

Yesterday, I updated a sqla10 customer to sqla12. All was fine after the upgrade. Then, apparently, a W2008 server OS patch was applied last night. Now our app cannot communicate via ODBC. When I test the connection with ODBC admin, all is fine. Also, dblocate finds the server. Any word about recent w2008 OS patches and a problem with sqla12? Any suggestions? Thanks, Doug

[Former Member]

What error are you getting when trying to connect?

[former_SQLA_member1694868]

This has happened to us a few times now. Some Windows server updates reset the security settings and the firewall settings. With the firewall turned on with default settings, the ODBC connection is blocked. Either turn the firewall off, or make an exception for the process running the database (probably dbsrv12.exe ) as well as for your application.

[Former Member]

Seen this before as well.

[Former Member]

Start the database by assigning server ip address and port

-x tcpip(MyIP=192.168.12.5;ServerPort=2680)

Provide the same on odbc

[Former Member]

It looks now like the failure of our app to run against the new sqla12 installation was caused by a failure of apps 'citrix to sybase server' share. We often place our apps' executables on our apps' sybase server. Then, to run our app thru citrix, the citrix admin just points citrix to our apps' executable, thru a share, on the sybase server. for some reason, after an ms os update, that share only remains operational for a few mintues.