Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- numbered list: 1. Foo 2. Bar
- to add a line break simply add two spaces to where you would like the new line to be.
- basic HTML tags are also supported
Question tags:
question asked: 18 Apr '12, 19:09
question was seen: 2,289 times
last updated: 19 Apr '12, 11:42
What error do you get when the server fails to start the db?
Note that it is not recommended to have your database on a drive that is not directly connected to the host that is running the database server.... since doing so can cause unexpected and unwanted results including data corruption.
The error I am getting is the following: Unable to start specified database: autostarting database failed SQLCODE = -82 SQLSTATE = 08001
Try to pre start the DB with e.g. dbeng or dbsrv programms then have a look at the error message you get there.
Which version of SQL Anywhere are you using? (e.g. 12.0.1.3605) How exactly have you mounted the network drive (what was your mount command?) Which OS/file system (e.g. ext4, NTFS, ...) does the database reside on?
As a supplement to Mark's comments, see: http://www.sybase.com/detail?id=1034790. We do not recommend running a database off of an SMB/CIFS mount. NAS/iSCSI/SAN systems should adhere to the document recommendations above.
As Martin suggested, to get the database started, try starting the database with just "dbsrv" or "dbeng" with the output log enabled - (e.g. "dbsrv12 -z -o console.txt database.db" ). This output will help you log any problems with starting the database.
If this simple test works, it looks like your connection string to auto-start the database may be incorrect from your application. Can you post the full string (removing any passwords / sensitive IP information)?