forked from FreeTDS/freetds
-
Notifications
You must be signed in to change notification settings - Fork 3
/
interfaces
66 lines (62 loc) · 2.3 KB
/
interfaces
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
#
# Note: interfaces has been superceded by freetds.conf, however it can
# continue to be used at sites that require compatibility with the
# Sybase implementation.
#
# This format of the interfaces file is this:
#
# The entry starts with the server name beginning in the first column
# (no whitespace preceding it).
#
# Next comes the services lines. They must be preceded by some
# whitespace (preferably a tab). There are five fields in the services
# line:
#
# 1) Service. Currently only "query" means anything "master" is
# present for historical reasons only.
#
# 2) Transport. Currently ignored by FreeTDS, it should be "tcp".
# When ipv6 support is added a second option of "tcp6"
# will probably be available.
#
# 3) Physical layer. Sybase uses this field for a description of the
# physical layer (usually "ether"), FreeTDS can also
# use it to specify the version of the protocol to use
# when connecting to the server.
#
# 4) Hostname. A hostname or IP address of the server machine.
#
# 5) Port. The TCP port on the server to connect to.
# Microsft SQL Server defaults to 1433.
#
# So putting it all together, let's say you have an NT box running a
# Microsoft SQL Server named "myserver" at ip address 10.0.2.1 and we
# are connecting using version 4.2 of the protocol, your interfaces
# entry would look like this: (without the comments)
#
#myserver
# query tcp 4.2 10.0.2.1 1433
#
# This is a Sybase hosted database server, if you are directly on the
# net you can use it to test.
JDBC
query tcp 5.0 192.138.151.39 4444
master tcp 5.0 192.138.151.39 4444
# The same server, using TDS 4.2. Used in configuration examples for the
# pool server, since the pool server supports only TDS 4.2.
JDBC_42
query tcp 4.2 192.138.151.39 4444
master tcp 4.2 192.138.151.39 4444
# The client connecting to the pool server will use this to find its
# listening socket. This entry assumes that the client is on the same
# system as the pool server.
mypool
query tcp 4.2 127.0.0.1 5000
master tcp 4.2 127.0.0.1 5000
#myserver
# query tcp ether 127.0.0.1 4000
# master tcp ether 127.0.0.1 4000
#
#myserver2
# query tcp ether 127.0.0.1 4001
# master tcp ether 127.0.0.1 4001