|
I have a server defined locally under XP running 12.0.1.3726 which starts on the startup. When I add a new ODBC entry with the ODBC Administrator tool for a non-running db (setup as "Start and connect to a database on this computer"), the Test Connection feature is returning the SQL code -75 message: Connection failed: Request to start/stop database denied. A DCX entry for SQLCODE = -75 shows: You do not have permission to start or stop a database. The required permission is determined on the server command line. Adding the server name does not help to have this local connection completed OK. All the connections to the running db's do test fine. |
|
When running a network server (i.e. dbsrv12), autostarting of databases is disallowed by default. In order to start a database on a running network server, you need to either:
When you unload the service, the client cannot find a running server to connect to, so it starts its own using dbeng12. Autostarting database on personal servers is allowed by anyone by default, so the client can successfully start the database on that server. 1
Breck and Graeme, After adding the -gd all parameter the local connection tested fine. Regarding the <default> server name I entered as a comment, is it still a valid/documented solution for 12?
(19 May '12, 18:37)
Derli Marcochi
|
|
Does the service setup specify dbsrv12.exe or dbeng12.exe? If it is dbsrv12.exe, does the user id in the ODBC setup have DBA permissions? If not, then try specifying -gd all -gk all in the service setup: http://dcx.sybase.com/index.html#1201/en/saerrors/errm75.html http://dcx.sybase.com/index.html#1201/en/dbadmin/gd-database-dbengine.html http://dcx.sybase.com/index.html#1201/en/dbadmin/gk-database-dbengine.html |
When creating a new entry with a 5.5 driver the server name is pre-filled with "<default>".
I added the same text in the server name of the ODBC entry created with the 12 driver and the connection is now testing fine. Is that a valid/acceptable solution?
I have a situation with 32 and 64 bit ODBC connections for SQL Anywhere 11
The 32 bit connection (system DSN) is set to start automatically and the test connection works fine.
I created the same system DSN (settings are no different) for the 64 bit connection and get the first message above.
No database processes are running in the task manager. I can't get the 64 bit connection to connect.