|
With 12.0.0.2601 dbsrv12 the default setting for the -gd option does NOT enable the ODBC Administrator - Login tab - Action: "Start and connect to a database on another computer" to work even when the user is connecting via DBA.
This contradicts the Help http://dcx.sybase.com/index.html#1200en/dbadmin/gd-database-dbengine.html which says "The default setting is all for the personal database server, and DBA for the network database server." The explicit dbsrv12 -gd DBA option does not seem to help either. Tests were performed using Sybase Central 12 to connect to a running database on the server, and then trying to start a second database on that server. The "start a second database" connections failed with "Request to start/stop database denied" when -gd default and -gd DBA were used, but worked with -gd all. Note that when -gd all is specified, no "first connection to the server from the same application" is required, and this warning from the Help topic above does NOT apply: "When this option is set to DBA, the client application must already have a connection to the database server to start or stop a database. Providing a DBA user ID and password on a new connection is not enough." I.e., when -gd all is specified, the ODBC Administrator Test Connection button works, as does a single connection from Sybase Central 12. ===== Client DSN for connecting to a running database ddd12b.db on server computer... [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" ===== Client DSN for starting and connecting to a second database ddd12c.db on server computer... [HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\ddd12_on_Envy_start_ddd12c] "Driver"="C:\\PROGRA~1\\SQLANY~3\\Bin32\\dbodbc12.dll" "UID"="dba" "PWD"="sql" "DatabaseName"="ddd12c" "DatabaseFile"="ddd12c.db" "ServerName"="ddd12_on_Envy" "Integrated"="NO" "Encryption"="NONE" "Host"="192.168.1.101:2638" |
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- 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:
question asked: 01 Dec '10, 14:32
question was seen: 2,659 times
last updated: 01 Dec '10, 15:55