Connecting SQL Anywhere with Sybase database file on local computer

sybase-sql-anywhere

I have installed SQL Anywhere 12 in my system.

I have a .db file in my computer. I have no idea what is it's username and password.

If I try to connect to it by providing credentials- username=DBA and password=sql
I'm getting below error-

How can I connect to it successfully?

Best Answer

Here is a way to reset the password using the free SQL Anywhere 17 Developer edition. The paid edition should work also.

"C:\Program Files\SQL Anywhere 17\bin64\dbsrv17.exe"  dbsrv17 -orp "UID=DBA;NEWPWD=newpassword;AUTHUID=reset_user;AUTHPWD=sql456" C:\database.file.db

Related Solutions

Sybase SQL Anywhere 12 – Get all indexes which are unique -> ambigious sysindexes error

There are two system views called sysindexes - one owned by SYS and one owned by DBO. You likely want the the one owned by SYS:

SELECT z.name FROM sys.sysobjects z JOIN sys.sysindexes ON (z.id = i.id) WHERE type = 'U'

SqlAnywhere 12- service started but stopped

If you are still having problems with this, the first place to look is in the Windows Application Events log - you should see the reason (eg manual shutdown requested) why the server was stopped.

You can also get the database engine to write its own console log to file with the

-o <filename>

server start up option - that may give you more detailed information.

It's important to check that your connections aren't specifying the AutoStop connection parameter or the Stop Database After Last Disconnect ODBC setting. This only applies if you are asking the connection to automatically start the database engine if it is not already running - NOT if you are running the database engine as a service.

Best Answer

Related Solutions

Sybase SQL Anywhere 12 – Get all indexes which are unique -> ambigious sysindexes error

SqlAnywhere 12- service started but stopped

Related Question