1890423 - Connect to a database, running on the same machine (Windows 7) as a service? - SQL Anywhere

Symptom

On a Windows 7 machine, a service is defined, that starts automatically the SQL Anywhere database server with a single database.

Trying to connect to the database using the connection string "UID=<user>;PWD=<password>;DBF=<path and file name of database file>" results in the error:

Specified database file already in use

Using an alternative connection string "UID=<user>;PWD=<password>;DBN=<database name>" results in the error:

Could not connect to the database.
Database server not found

Similar configuration and connection strings are working on Windows XP.

Environment

SAP Sybase SQL Anywhere

Product

SAP SQL Anywhere all versions ; SQL Anywhere all versions

Keywords

Shared Memory, SharedMemory, ShMem, Windows XP, Windows 2003, Windows Vista, Windows 7, Windows 2008, Windows 2008 R2 , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.