Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    3

    Unanswered: calling another server connection through a stored procedure

    anybody have an idea how to call a server through a stored procedure....

    ex)
    from my asp, i connect to sql server then call a stored procedure....in the stored procedure i want to connect to a remote database (jdedwards) and bring back tables to use in that procedure that eventually is used for output.

    how do you make the connection to jde?

  2. #2
    Join Date
    Dec 2002
    Posts
    12
    You can do it through either linked server or remote server. Either way, you need to register the 2nd server on the first server. Provided permision is granted, you then run query in the 'select * from serverName.dbName.owner.tableName' format.

  3. #3
    Join Date
    Aug 2003
    Posts
    3

    Angry

    thanks!

    but now HOW DO I register my sql server to connect to a non Sql Server.....the only way I can connect to the other Database is through ODBC? In other words, I need my sql server's stored procedure to ODBC to a non SQL server; i.e., AS/400.

Posting Permissions

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