Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Painfully Slow Connection C# ODBC Sybase Adaptive Server Anywhere 6.0

Status
Not open for further replies.

savage1881

IS-IT--Management
Jul 28, 2008
1
0
0
I'm integrating with a property management software package called Peak Property Management.

I'm using the ODBC DSN that gets installed with the program. I'm in C# using ODBCConnection and when I open the connection it takes forever.. easily 5-10 mins. Then it opens without error. ASA Server logs, ODBC Trace... etc do not show any activity until it works. I have tried every modification on the connection string I could think of... i've been hacking away at this problem for over 10 hours.

Both Peak and Sybase iSQL connect thru the same ODBC connection very quickly (Verified in Logs). The performance does not change with trace on or off, but the performance in Peak replicates my app's behavior when trace is turned on.

ODBC Trace Files:

Any thoughts would be appreciated!

-Justin
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top