Why is the "TCP/IP Protocol Options:" section disabled in the 12.0.2601 ODBC Administrator - Network tab?
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:"
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.
answered 01 Dec '10, 17:21
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.
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:)
answered 01 Dec '10, 18:02