Results 1 to 1 of 1
  1. #1
    Join Date
    Dec 2002
    Préverenges, Switzerland

    Unanswered: MS SQL-Server / stored procs / combos

    i'm a newbie to MS-SQL and i'm slightly stuck trying to feed a combo from MS-SQL Server.

    a simple linked table/stored A query takes too long (several seconds)

    i've experimented with temporary pass-thru QueryDef looking at a stored procedure with parameter on the server fine: quarter-second responses, but i can't find how to set this as .rowsource

    i've experimented with coding up a new saved A QueryDef fine and i can set it as .rowsource

    but now i want to mess around with a single saved A QueryDef for this combo:

    .QueryDefs("localAquery").Connect = blah 'works ok
    .QueryDefs("localAquery").SQL = "nameOfStoredProc " & longParam 'doesn't!

    A rejects my "SQL", insisting i must start with SELECT etc....

    does anyone have a neat method of pointing a combo at:

    a/ an ALL stored procedure
    b/ a MINE stored procedure with parameter (a long).

    or am i barking up completely the wrong tree?

    Last edited by izyrider; 06-04-04 at 14:07.
    currently using SS 2008R2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts