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

asked 24 Aug '11, 10:09

dejstone's gravatar image

dejstone
959395069
accept rate: 0%

What error are you getting when trying to connect?

(24 Aug '11, 10:36) Tyson Lewis

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.

permanent link

answered 24 Aug '11, 10:56

Siger%20Matt's gravatar image

Siger Matt
3.1k486493
accept rate: 13%

Seen this before as well.

(25 Aug '11, 21:34) Calvin Allen

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.

permanent link

answered 25 Aug '11, 09:31

Doug's gravatar image

Doug
30234
accept rate: 0%

Start the database by assigning server ip address and port

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

Provide the same on odbc

permanent link

answered 26 Aug '11, 00:25

Karuppasamy's gravatar image

Karuppasamy
136334
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×3

question asked: 24 Aug '11, 10:09

question was seen: 785 times

last updated: 26 Aug '11, 00:25