• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Do ODBC connection (PowerBuilder connecting Sybase ASA 17.0 ) makes application slow over network on WAN

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved Do ODBC connection (PowerBuilder connecting Sybase ASA 17.0 ) makes application slow over network on WAN

  1. Issue
0
Votes
Undo
  1. Pradevan Thakur
    Pradevan Thakur
  2. PowerBuilder
  3. Thursday, 6 June 2024 05:23 AM UTC

What are other ways for fast connectivity of PowerBuilder with Sybase ASA 17.0 other than ODBC

PB2022R3 - ORCA ExecutableCreate with embedded Man...
How exe file is looking for pb.ini file
Responses (2)
Andreas Mykonios
Andreas Mykonios Accepted Answer Pending Moderation
  1. Thursday, 6 June 2024 07:25 AM UTC
  2. PowerBuilder
  3. # 1

Hi.

You can connect to SQL Anywhere using ADO.NET or OLE DB (and depending on the version of Powerbuilder using JDBC), but I'm not sure why you are looking for an alternative. ODBC is pretty fast for SQL Anywhere. I've been working for a long time using SQL Anywhere 8, 11, 12, 17 with really large databases and up to 50 concurrent connections without having any problem.

Andreas.

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 6 June 2024 12:08 PM UTC
  2. PowerBuilder
  3. # 2

Hi Pradevan;

   Did you turn on Connection Caching in the ODBC layer?

Regards ... Chris

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.