Hello, all

Is it possible to receive 08001 error for any other reason that network problems? We know that the server is running and sometimes users get this error: ERROR [08001] [Sybase][ODBC Driver][SQL Anywhere]Database server not found

It goes on for a few seconds and then comes back as if there was never a problem.

So, could it be anything else other than network issues? The IT dep tells us (what a shock...) that there are no network problems.

Thank you Arcady

asked 25 Feb '19, 08:18

Arcady%20Abramov's gravatar image

Arcady Abramov
143141621
accept rate: 0%

edited 25 Feb '19, 08:19


The v16 docs list many such errors, for example:

Error constant SQLE_UNABLE_TO_CONNECT 
ODBC 2 state 08001 
ODBC 3 state 08001 
Parameter 1 Reason that database cannot be started. 
Severity 11 
SQLCODE -105 
SQLSTATE 08001 
Sybase error code 4001 

The specified database cannot be started. Either it does not exist, it is not a database, it is corrupt, or it is an older, unsupported format.

Therefore please check the SQLCODE or SQLSTATE error codes of the error you receive, they should be more specific...

For the error message "Database server not found" aka SQLCODE -100 you get:

The database server is not running, or is in the process of starting up or shutting down, or the interface library is unable to find it.

Using the LOG connection parameter on your client connection string seems worthwhile.

permanent link

answered 25 Feb '19, 09:03

Volker%20Barth's gravatar image

Volker Barth
39.7k358546815
accept rate: 34%

edited 25 Feb '19, 09:08

I read the manuals, thank you. I as asking if this particular error with this particular description can be returned on any event other than network error.

(25 Feb '19, 09:09) Arcady Abramov
Replies hidden

Ah, I see. While I cannot answer that, I still suggest to use the LOG parameter (and possibly the -z database server option to log on that side, as well).

(25 Feb '19, 09:20) Volker Barth

So, "not being able to find it" can be for any other reason other than network error, providing that the DB service is up and running and servicing other connections?

(25 Feb '19, 09:20) Arcady Abramov

OK, I managed to recreate the problem with the log file I am not sure it brought me closer to understanding the source of the problem. Why does it say "verification of server name failed"? Both machine and db server name are correct. Will setting verify=no help in this case?

These are the contents of the log:

//------------------------------------

Attempting to connect using:
UID=MetaSearch;PWD=********;DBN=g4_center_astral;ServerName=g4_center_astral;CON=PricesInternalService;LOG=C:\Temp\center_astral_20190226_11.txt;Host=vm-g4-db-05:2639
12:23:05 Attempting to connect to a running server...
12:23:05 Attempting TCPIP connection (address 10.10.100.65:2639 found in sasrv.ini cache)
12:23:05 Looking for server with name g4_center_astral
12:23:05 Trying to find server at cached address 10.10.100.65:2639 without broadcasting
12:23:08 Verification of server name failed
12:23:08 A HOST value was specified, skipping LDAP check
12:23:08 Failed to connect over TCPIP
12:23:08 Removing failed address from sasrv.ini cache
12:23:08 Not attempting to autostart server

//-----------------------------------
(26 Feb '19, 06:30) Arcady Abramov
Replies hidden

Is the contents of the sasrv.ini file correct, i.e. has the dababase server "g4_center_astral" the address "10.10.100.65:2639"?

Otherwise it seems that the cache routes the connection attempt to a wrong address and therefore fails.

If so, try omitting the .ini cache...


As the .ini file is stored locally, that could explain why different clients can resp. cannot reach the database server, even if they you exactly the same connection string.

See that trouble shooting page.

(26 Feb '19, 07:03) Volker Barth
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • 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:

×157

question asked: 25 Feb '19, 08:18

question was seen: 5,270 times

last updated: 26 Feb '19, 07:05