Database Link problems

  • I've got a sql 2000 server (server A) which had database links to two peoplesoft servers (which also have sql 2000 installed). Server A has standard default collation set. The peoplesoft servers are set to binary sort order.

    I recently had to reinstall server A. I restored the Master database on Server A so that I did not lose all my settings on the server. Then I restored all the other databases. Everything has been working fine except for one thing -- Database links to the Peoplesoft servers. These links worked before I reinstalled Server A, but not now.

    Thinking I had trouble with the database links, I dropped the links and recreated them from Query Analyzer (QA). Now, I do a select statement from the peoplesoft server (using the option "COLLATE database_default" because of the differet sort orders) and Query Analyzer, my results come back just fine.  No trouble at all. However, when my programmer's uses Peoplesoft's  SQR to run a create a report which accesses the table from Server A, it simply hangs. I've run a trace on both servers, and it doesn't show ME any meaningful information. Hopefully one of you guys could find something meaningful out of it. It's simply so frustrating that it ran fine before but doesn't now.

    While me developer runs his application, here is the trace results from the peoplesoft server:

    EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters

    exec sp_datatype_info -10

    exec sp_datatype_info -8

    declare @P1 int

    set @P1=1

    exec sp_prepexec @P1 output, NULL, N'SET DATEFORMAT MDY '

    select @P1

    declare @P1 int

    set @P1=2

    declare @P2 int

    set @P2=4097

    declare @P3 int

    set @P3=8193

    exec sp_cursorprepare @P1 output, NULL, N'SELECT A.EMPLID  FROM PS_PERSONAL_DATA A WHERE A.EMPLID = ''11111'' ', 1, @P2 output, @P3 output

    select @P1, @P2, @P3

    Here is the trace from the linked server.

    -- network protocol: TCP/IP

    set quoted_identifier on

    set implicit_transactions off

    set cursor_close_on_commit off

    set ansi_warnings on

    set ansi_padding on

    set ansi_nulls on

    set concat_null_yields_null on

    set language us_english

    set dateformat mdy

    set datefirst 7

    SELECT @@SPID

  • This was removed by the editor as SPAM

  • Are you sure there wasn't something else added to Server A by the PSFT product?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply