Board index » delphi » MSSQL 7.0 - system stored proc problem (sp_Setapprole)

Abaco Informatic

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

MSSQL 7.0 - system stored proc problem (sp_Setapprole)

My problem is that I cant execute the system stored procedure
sp_Setapprole, so I cant connect to MS SQL Server via an applications
function. I tried with DB.EXEC as well as with the TStoredProc component
with no success.
However, I was able to make it work using the ODBC driver.

My question is: Is there way of doing this using SQL Links?

I am using Delphi 5 along with MS SQL Server 7.0 in Windows 95.

TIA

Alejandra

 
Sinan Guve

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:MSSQL 7.0 - system stored proc problem (sp_Setapprole)


System stored procedures can be in any db in the server. But you can not use
object inspector to select the sp and use autofilled parameter list. Instead
you must write the the name of the stored proc and fill the parameters by
hand (you can make an alias to the master db to see the values for
parameters)
Sinan.

Quote
"Abaco Informatica" <abas...@satlink.com> wrote in message

news:8eq0ut$spq3@bornews.borland.com...
Quote
> My problem is that I cant execute the system stored procedure
> sp_Setapprole, so I cant connect to MS SQL Server via an applications
> function. I tried with DB.EXEC as well as with the TStoredProc component
> with no success.
> However, I was able to make it work using the ODBC driver.

> My question is: Is there way of doing this using SQL Links?

> I am using Delphi 5 along with MS SQL Server 7.0 in Windows 95.

> TIA

> Alejandra

Sinan Guve

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:MSSQL 7.0 - system stored proc problem (sp_Setapprole)


I forgot to mention that if you will use sp_setapprole be sure that you app
will use only 1 connection. Because BDE can open extra connections probably
you will see strange permission errors unless you know what are you doing.
Sinan.

Quote
"Abaco Informatica" <abas...@satlink.com> wrote in message

news:8eq0ut$spq3@bornews.borland.com...
Quote
> My problem is that I cant execute the system stored procedure
> sp_Setapprole, so I cant connect to MS SQL Server via an applications
> function. I tried with DB.EXEC as well as with the TStoredProc component
> with no success.
> However, I was able to make it work using the ODBC driver.

> My question is: Is there way of doing this using SQL Links?

> I am using Delphi 5 along with MS SQL Server 7.0 in Windows 95.

> TIA

> Alejandra

Other Threads

1. MSSQL 7.0 Stored Proc's Error

2. ADO & MSSQL Stored proc problem

3. MSSQL Stored Proc a strange problem

4. Problem with stored procedures in MSSQL 7.0

5. *** Using dataset returnet by a stored proc inside another stored proc ***

6. ADO, stored proc and MSSQL question.

7. SQL Server 7.0, ADO-Command Parameters not Accessible (Stored Proc)

8. Anybody used to write MSSQL 2000 extended stored proc in Delphi

9. Managing Text, Image in Stored Proc on MSSQL

10. SQL Server 7.0 Stored Proc and Joins