Re: Best approach to connecting to SQL Server - SQL Commands, Cursor Adapter or ADO

> If SQL server administrator only allows your Foxpro to access and
> updates data via stored procedures, would CursorAdaptors help?

Perhaps, as you can define code for Select/Insert/Update/Delete of
the CA (SelectCmd,InsertCmd,UpdateCmd,DeleteCmd) instead of
automatically generated SQL. That may not be SQL but stored
procedure (sp) calls...

Haven't tried though. And the advantage is lost, especially if you
are sure you'll stay with MS SQL Server. You'd have to implement
the code within the Cursoradapter classes, you could also send via
SQLExec() instead.

But CursorAdapter won't have more rights and be able to do more
SQL than you are allowed, as it also has to connect via user/password
and is only granted the priviliges that connected user has.

Bye, Olaf.


.

Relevant Pages

  • Re: basic question
    ... Currently we have are doing calculations via stored procedures ... in which case *I* would like to have them run on the SQL server ... procs are doing. ...
    (microsoft.public.dotnet.general)
  • Re: Frage zu View-Tabellen
    ... eigenes Element in SQL. ... Erweiterungen sind indizierte Sichten (SQL Server 2000), ... Performance und vom Speicherverbrauch ein Unterschied, ob ich eine Anfrage auf eine View-Tabelle oder eine Stored Procedure schicke? ... Bei Stored Procedures wird der kompilierte Ausführungsplan im Cache gespeichert, der bei Zugriffen auf die View in der Regel neu erstellt wird. ...
    (microsoft.public.de.sqlserver)
  • Re: Stored Procedure vs direct execute SQL
    ... another of dynamic sql (otherwise SQL Server can't take advantage of ... You seem to be saying that SQL Server can use ... To say that stored procedures are "far ... > select listingId, listingName from Property ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: DB Architecture Questions (for joe celko)
    ... much more flexibility and scalability. ... Although in the reality I live in, stored procedures ... SQL Server, this means that you will have a lot of round trips for data ...
    (microsoft.public.sqlserver.programming)
  • Re: Insert Date and Time in SQL Server 2000 using ASP
    ... > applications that actively communicate with SQL Server, ... Oracle any more than necessary") but we have a single application that works ... The effort to code the SQL logic into 3 separate sets of stored procedures ...
    (microsoft.public.inetserver.asp.general)
Loading