Why is the TCP/IP section disabled in the ODBC Network tab?

Why is the "TCP/IP Protocol Options:" section disabled in the 12.0.2601 ODBC Administrator - Network tab?

alt text

Here is the working DSN...

[HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\ddd12_on_Envy_connect_to_ddd12b]
"Driver"="C:\\PROGRA~1\\SQLANY~3\\Bin32\\dbodbc12.dll"
"UID"="dba"
"PWD"="sql"
"DatabaseName"="ddd12b"
"ServerName"="ddd12_on_Envy"
"Integrated"="NO"
"Host"="192.168.1.101:2638"

Here is the Login tab, showing that the Action: is set to "Connect to a running database on another computer:"

alt text

debugging

asked 01 Dec '10, 14:41

Breck Carter
32.5k●540●724●1050
accept rate: 20%

edited 01 Dec '10, 16:25

flat view

3 Answers:

active answers oldest answers newest answers popular answers

You've specified a host and port on the Login page. The HOST parameter trumps all other network parameters and you can't specify both HOST and LINKS in the same connection string.

permanent link

answered 01 Dec '10, 17:21

Bill Hillis
836●3●7
accept rate: 66%

Ohhhh, it is the HOST connection parameter, not the HOST protocol option. Well, that's confusing... and the GUI is rather unclear. I guess you get the green check mark, though :)

(01 Dec '10, 20:33) Breck Carter

flat view

If your DSN is set for "Connect to a running database on this computer" or "Start and connect to a database on this computer", we disable the TCP options because you will be using shared memory.

The TCP options are also disabled if you specify something in the Host field, since you cannot use the HOST and LINKS connection parameters together.

permanent link

answered 01 Dec '10, 15:40

Graeme Perrow
9.6k●3●79●124
accept rate: 54%

edited 01 Dec '10, 16:38

Comment Text Removed

It was ""Connect to a running database on another computer". I have added an image to the question.

(01 Dec '10, 16:26) Breck Carter

Besides... local connections CAN use TCP/IP, can't they? Shared Memory can be turned off? Boy, I'm confused now ( as if I haven't always been :)

(01 Dec '10, 16:28) Breck Carter

Yes, you can use shmem for local connections, but shmem is almost always faster. The client doesn't distinguish between TCP connections to the local machine vs. TCP connections to a remote machine, so if you want to use TCP for local connections, you need to pretend it's a remote computer. For the host, specify the hostname, real IP address, "localhost", or 127.0.0.1.

(01 Dec '10, 16:39) Graeme Perrow

@Graeme: So I would have to use "a remote computer" when to connect locally on a Windows 2008 server with SA running as a "local system" service? (As that setup prevents shmem with such services, AFAIK).

(01 Dec '10, 18:04) Volker Barth

@Volker: Yes, that's right.

(01 Dec '10, 18:15) Graeme Perrow

If SA is running as a local system service, shared memory should work. If you have experienced otherwise with software less that a couple years old, please let me know.

(02 Dec '10, 01:28) John Smirnios

@John: How about the SQL Anywhere Monitor that ships in the box? :)

(02 Dec '10, 14:50) Breck Carter

More comments hidden

showing 4 of 7 show all flat view

This is not an answer, but I agree with Breck that the V12 connection dialog is somewhat confusing for experienced SA users.

In older versions, I usually use primarily ENG and DBN to specify the database I'm about to connect to, and usually choose an existing DSN for common usage.

In V12, in case not all necessary information is given (say, you want to add the DBA password interactively), I have often experienced that the action type changes inappropriately between different attempts to add information. - E.g., you were about to start a local database and forget to specify the DBKEY parameter, and then the action combo box turns to a different action...

Guess I will have to put together a reproducable:)

That being said, I really appreciate the efforts to make the connection dialog "easier". It just seems not too easy to do so for all cases:)

permanent link

answered 01 Dec '10, 18:02

Volker Barth
39.8k●360●546●815
accept rate: 34%

@Volker: I agree about the "easier" part, in spite of my rants. If I didn't use it, I wouldn't mention it. If I didn't like it, I wouldn't yell so much about the [cough] features :)

(02 Dec '10, 14:54) Breck Carter

flat view

Your answer

toggle preview

community wiki:

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

learn more about Markdown

Question tags:

debugging ×106

question asked: 01 Dec '10, 14:41

question was seen: 4,506 times

last updated: 01 Dec '10, 18:02

SAP SQL Anywhere

Why is the TCP/IP section disabled in the ODBC Network tab?

Follow this question

Related questions