I have a SQL 2005 Express db that loads XML and inserts the records into a SQL Anywhere 9.0 (Sybase) linked server. There is another application updating this Sybase db as well. I am successfully inserting records into the Sybase db via the linked server configuration, but continue to have sporadic permission issues. It seems to be banging heads with the other application.
Is there something special you have to configure for the ASA 9.0 to have more than one connection to the db or is it even possible? Could there be environmental settings or specific odbc settings to allow more than one connection to have access to the db at the same time? Any direction or help is appreciated.