We are using Sybase ASE ODBC Driver version 4.20.00.06 (syodase.dll) from Sybase dated 6/25/2003. We are in the process of migrating from Sybase ASE ODBC Driver version 3.60.00.16 (syodase.dll) from Sybase dated 6/16/2000. We are using this from a VB app using a DSN-less connection string method of creating connections. I have pasted below the code for the connection string.
We ran into trouble when trying to execute a stored proc in the unchained mode on a Sybase 12.5 server.It just hangs in there and the db monitor shows that the connection is in the AWAITING COMMAND status. So my app just hangs in there until the connection timeout we have set in the code is reached and the connection is closed with an error message.
We don't have any issues with the old driver.
Any help would be most appreciated. Also is there any place where I can get teh documentation for these drivers?
Thanks a lot.
ConntStr = "ODBC;UID=" & Userid & ";PWD=" & Pwd & ";DRIVER=" & Trim(gADriver) & ";" & "NA=" & Server & "," & DbServerPort & ";DB=" & gDb & ";is=set ansinull off;"