Unable to start database server - but the database is already running?

[Former Member]

I'm attempting to connect to a running SQL Anywhere 11 instance, which is running and processing as a Point of Sale system for a customer of ours.

Using a previous version of the POS software, and SQL Anywhere 10, I can connect to the SQL Anywhere server, using this connection call:

string stringConnection = string.Format(@"ENG={0};DBN = {1};UID={2};PWD={3}", serverName, dataBaseName2, userDB2, passwordDB2);
AsaConnection myConnection = new AsaConnection(stringConnection);
myConnection.Open();
AsaCommand myCommand = myConnection.CreateCommand();

However, with the current version of SQL Anywhere, I'm getting this error:

iAnywhere.Data.AsaClient.AsaException: Unable to start database server
  at iAnywhere.Data.AsaClient.AsaConnection.Open()

I don't quite understand the error, because the database server is already running.

Is there some way to run the database where no other process can connect to it (like in a local mode), where the database is up and running - but I cannot connect?  Any suggestions on how to change the connection string to connect?

Thanks!

--

Anthony

[JasonHinsperger · Accepted solution]

You would get this error if the SQL Anywhere engine name (ENG) or database name (DBN) has changed. 

Perhaps one (or both) of these was changed when the application was updated?

hth,

--Jason