Re: SQLEXEC problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Sorin Sandu (ssandu_at_bizland.ro.invalid)
Date: 08/05/04

Next message: Jane: "Queries of this type are not supported"
Previous message: Sorin Sandu: "SQLEXEC problem"
In reply to: Sorin Sandu: "SQLEXEC problem"
Messages sorted by: [ date ] [ thread ]

Date: Thu, 5 Aug 2004 14:07:34 +0300

Resolved.
The problem was user hea no db_owner and ddl_admin rights.
"Sorin Sandu" <ssandu@bizland.ro.invalid> a scris în mesajul de
ştiri:uGkkK5seEHA.384@TK2MSFTNGP10.phx.gbl...
I have this code
STORE SQLCONNECT('ConnectSQL', 'user', 'password') TO gnConnHandle
IF gnConnHandle <= 0
    = MESSAGEBOX('Cannot make connection', 16, 'SQL Connect Error')
ELSE
   lsucces = SQLEXEC(gnConnHandle,"ALTER TABLE table1 DISABLE TRIGGER
del_table")
   IF lsucces = 1
     = MESSAGEBOX("Work's")
     = SQLDISCONNECT(gnConnHandle)
   ELSE
     = MESSAGEBOX("Don't work")
     = SQLDISCONNECT(gnConnHandle)
    ENDIF
ENDIF
against a SQL Server 2000 table.
It doesn't wotk
What's wrong
Thank's
Sorin Sandu

Next message: Jane: "Queries of this type are not supported"
Previous message: Sorin Sandu: "SQLEXEC problem"
In reply to: Sorin Sandu: "SQLEXEC problem"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: Newbie to T-SQL
... Vyas, MVP (SQL Server) ... "Sorin Sandu" wrote in message ...
(microsoft.public.sqlserver.server)
Re: KB 831997
... Vyas, MVP (SQL Server) ... "Sorin Sandu" wrote in message ... > How can I get the Hotfix for KB 831997? ...
(microsoft.public.sqlserver.server)