Sql Anywhere 17 : Database access related issue

[former_member798402]

We are using SqlAnywhere17 databse and facing one issue related to database access through ODBC.

Scenario:

• One database that exist in “C:\\DB\test.db. User XYZ is used for connection. It consists:

• Some basic tables

Three application paralleled access this database in multi threading nature . Using same user “XYZ”.

• Window service to Select/Update database tables
• Web page to display grid related to status from database
• A script that open crystal report -> show SQL Query to check “Reset button”

We observed that sometime we get database connection open error. I believe that when window service try to access database for updating information and same time Automation script or web page access database it create issue. As per Event viewer.
Can not access C:\\DB\test.db. Another user use same file.
Query:

We are using ODBC connection with User "XYZ" to access database from all three application.
Can we access SQL Anywhere database through 3 application parallel with same user?
Or we need to do some changes in code for this type of access. Please suggest ?

[DellSC · Accepted solution]

This is not really a question about how Crystal works - it's more about how SQL Anywhere works with multiple logins from the same user. I would ask this question in a SQL Anywhere forum to get a better response.

-Dell