Unable to connect: Adaptive Server is unavailable or does not exist (SQL-08S01) [state was 08S01 now 08001]
1 2 3 4 5 6 7 8 9 10 11 12 13 14
use strict; use warnings; use DBI; use DBIx::Class; my $host = '192.192.192.192'; my $database = 'datenbank'; my $user = 'user'; my $auth = 'pwd'; my $driver = 'TDS'; my $dbh = DBI->connect("dbi:ODBC:Driver=$driver;Server=$host;Database=$database;UID=$user;PWD=$auth") or die "Fehler beim Verbinden: ", $DBI::errstr;
$ tsql -H 192.192.192.192 -p 1433 -U user -P pwd
1
2
3
4
5
locale is "C"
locale charset is "ANSI_X3.4-1968"
Msg 20002, Level 9, State -1, Server OpenClient, Line -1
Adaptive Server connection failed
There was a problem connecting to the server
1
2
3
4
5
6
7
8
9
10
Compile-time settings (established with the "configure" script)
Version: freetds v0.82
freetds.conf directory: /etc/freetds
MS db-lib source compatibility: no
Sybase binary compatibility: yes
Thread safety: yes
iconv library: yes
TDS version: 4.2
iODBC: no
unixodbc: yes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
[global]
# TDS protocol version
; tds version = 4.2
# Whether to write a TDSDUMP file for diagnostic purposes
# (setting this to /tmp is insecure on a multi-user system)
; dump file = /tmp/freetds.log
; debug flags = 0xffff
# Command and connection timeouts
; timeout = 10
; connect timeout = 10
# If you get out-of-memory errors, it may mean that your client
# is trying to allocate a huge buffer for a TEXT field.
# Try setting 'text size' to a more reasonable limit
text size = 64512
[sqlexpress]
host = 192.192.192.192
port = 1433
tds version = 4.2
1
2
Unable to connect to data source (SQL-08001) [state was 08001 now 01000]
Adaptive Server connection failed (SQL-01000)