Re: NEED TO CALL AS400 S.P

From: Phil (Phil_at_discussions.microsoft.com)
Date: 07/06/04

  • Next message: MacDuff: "Re: Jet 4.0 / Oledb intall problem" 
    Date: Tue, 6 Jul 2004 09:04:03 -0700

    The idea in one of the other groups seems to be the best. I am testing it now. That is to use a trigger on a table and perform an INSERT/UPDATE which will execute the trigger. So simple yet so nice (if it works).....

    "Erland Sommarskog" wrote:

    > Phil (Phil@discussions.microsoft.com) writes:
    > > The stored procedure doesn't return any records as it only does inserts
    > > and updates. I have been unsuccessfully trying to devise a method to
    > > 'fool' the OPENQUERY. :(
    >
    > Well, OPENQUERY is definitely a dead end. (Unless you could add a dummy
    > result set.)
    >
    > > *****EXEC as4cs01..as4cs01.qgpl.sp_run
    > > RETURNS:
    > > The procedure name 'as4cs01..as4cs01.qgpl.' contains more than the
    > > maximum number of prefixes. The maximum is 3.
    >
    > So that is a plain syntax error.
    >
    > > *****EXEC as4cs01.as4cs01.qgpl.sp_run
    > > RETURNS:
    > > Server: Msg 7212, Level 17, State 1, Line 1
    > > Could not execute procedure 'a2' on remote server 'as4cs01'.
    > > [OLE/DB provider returned message: SQL0104: Token { was not valid. Valid
    > > tokens: ( END SET CALL DROP FREE HOLD LOCK OPEN WITH ALTER BEGIN CLOSE.
    > > Cause . . . . . :
    >
    > Gosh! What an error message! I'm afraid that I am completely lost
    > here. Something appears to go very wrong where, and I have a feeling
    > that it takes some knowledge about AS400 to understand why. Is there
    > a tool on AS400 corresponding to Profiler that you could run to see
    > what your OLE DB provider is feed the AS400 with?
    >
    > One thing strikes me as funny, and that is that the error messages
    > says 'a2' and not 'sp_run'. Could the OLE DB provider be generating
    > some temporary stored procedure?
    >
    > I think you may need a forum with some knowledge about this
    > IBMDA400 provider. Maybe there are alternative providers you can use?
    >
    > --
    > Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
    >
    > Books Online for SQL Server SP3 at
    > http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
    >

  • Next message: MacDuff: "Re: Jet 4.0 / Oledb intall problem"

    Relevant Pages

    • Re: Classic ASP connectionstring to SQL Server 2005
      ... So this connection string is in the VB6 dll? ... What is the error message? ... Provider cannot be found. ... can you ping the sql server? ...
      (microsoft.public.inetserver.asp.db)
    • VSS Errors using NTBackup
      ... Microsoft OLE DB Provider for SQL Server ... Error message: ...
      (microsoft.public.windows.server.sbs)
    • Re: How to syncronize two tables?
      ... What is the error message? ... Pro SQL Server 2000 Database Design - ... > want to sync them with trigger. ...
      (microsoft.public.sqlserver.programming)
    • Re: Linked Server in SQL Server 2000 Evaluation Version
      ... That error message usually comes with an error message from the provider, ... You could check the event log on the SQL Server machine for messages. ... is that it does not really support Oracle 10 ...
      (microsoft.public.data.oledb)
    • Re: Error on Trigger Launch
      ... It was an error message from Microsoft SQL Server Managment Studio ... trigger, ... If an UPDATE statement affects multiple rows, ...
      (comp.databases.ms-sqlserver)