dbTalk Databases Forums  

Re: Freeze up with Sql Anywhere Native Driver

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss Re: Freeze up with Sql Anywhere Native Driver in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Josh Savill [Sybase]
 
Posts: n/a

Default Re: Freeze up with Sql Anywhere Native Driver - 01-04-2010 , 10:36 AM






Val,

You're going to need to be more specific about this setup.

1) What version and build of SQL Anywhere (dbsrvX -v) are you running?
2) What is your architecture? How does IIS come into play with SQL Anywhere?
3) What SQL Anywhere Native Driver are you using? ODBC, JDBC, etc?

Without a complete description of the problem and some debug logs, it difficult to comment on a
potential issue.

--
Joshua Savill
Sybase Inc. - Product Manager


Val Reyes wrote:
Quote:
Our Appeon 6.2 integration with PB10.5 runs on IIS and uses
SQL Anywhere 11. We use SQL ANYWHERE Native Driver which
seems to hang IIS frequently with respect to rollback
transactions. Are there any known issues with the driver?

Val Reyes
Metromedia Software, Inc.

Reply With Quote
  #2  
Old   
Val Reyes
 
Posts: n/a

Default Re: Freeze up with Sql Anywhere Native Driver - 01-06-2010 , 08:22 AM






Josh,

1) Build is 11.0.0.1264
2) Using ODBC. IIS & Appeon (a Sybase Partner) on PB10.5
interact and the db calls are channeled though IIS.

Val


Quote:
Val,

You're going to need to be more specific about this setup.

1) What version and build of SQL Anywhere (dbsrvX -v) are
you running? 2) What is your architecture? How does IIS
come into play with SQL Anywhere? 3) What SQL Anywhere
Native Driver are you using? ODBC, JDBC, etc?

Without a complete description of the problem and some
debug logs, it difficult to comment on a potential issue.

--
Joshua Savill
Sybase Inc. - Product Manager


Val Reyes wrote:
Our Appeon 6.2 integration with PB10.5 runs on IIS and
uses SQL Anywhere 11. We use SQL ANYWHERE Native Driver
which seems to hang IIS frequently with respect to
rollback transactions. Are there any known issues with
the driver?
Val Reyes
Metromedia Software, Inc.

Reply With Quote
  #3  
Old   
Josh Savill [Sybase]
 
Posts: n/a

Default Re: Freeze up with Sql Anywhere Native Driver - 01-06-2010 , 10:50 AM



Val,

Can you determine the transaction and ODBC call that causes the hang? Can you provide a verbose log
from the database server and logging information from IIS that demonstrates the hang? Can you
provide an ODBC trace? It would be beneficial to open a technical support case for this issue as it
will probably require some level of debugging.

11.0.0.1264 is SQL Anywhere 11.0.0 GA. The latest EBF is build 1626. There is nothing that stands
out in the EBF README as a potential problem, but this issue could already be resolved.

--
Joshua Savill
Sybase Inc. - Product Manager


Val Reyes wrote:
Quote:
Josh,

1) Build is 11.0.0.1264
2) Using ODBC. IIS & Appeon (a Sybase Partner) on PB10.5
interact and the db calls are channeled though IIS.

Val


Val,

You're going to need to be more specific about this setup.

1) What version and build of SQL Anywhere (dbsrvX -v) are
you running? 2) What is your architecture? How does IIS
come into play with SQL Anywhere? 3) What SQL Anywhere
Native Driver are you using? ODBC, JDBC, etc?

Without a complete description of the problem and some
debug logs, it difficult to comment on a potential issue.

--
Joshua Savill
Sybase Inc. - Product Manager


Val Reyes wrote:
Our Appeon 6.2 integration with PB10.5 runs on IIS and
uses SQL Anywhere 11. We use SQL ANYWHERE Native Driver
which seems to hang IIS frequently with respect to
rollback transactions. Are there any known issues with
the driver?
Val Reyes
Metromedia Software, Inc.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.