I have a server defined locally under XP running 220.127.116.1126 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.
answered 19 May '12, 16:10
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: