Any errors in the eventviewer/sql server logs?

Possible reasons for memory leaks

Cursors aren't properly released

Any calls with sp_OACreate not properly released.

Lingering transactions

Can you test it with a very simple query, specifying a timeout if necessary?

Start a trace with sql profiler on the linked server and look how far the query got.

Start a sql trace with SQL profiler.

With a bit of luck you can catch the hostname.

Because the local user accounts aren't validated by the domain controller -> untrusted.

Is the mdac level the same on both servers?

On what OS are the servers running? Sql server service pack?

Why do you connect with sa? (and even a blank password?)

UPDATE DCR

SET FG_AZ=ISNULL(FG.FG_AZ,0)

,FG_ty = ISNULL(FG.FG_ty,0)

from DCR

LEFT JOIN FG

ON fg.CustomerID = DR.Customer

Glad you found it !

(@newRecnum)

 FROM Project01Tmp3

WHERE <A href="mailtoroject01ID=@id">Project01ID=@id /*new*/

*thinking of a cursor less solution

DECLARE @highRecnum bigint

set @highRecnum = (select ISNULL(MAX(RECNUM),0)+1 from [ALL])

INSERT INTO [ALLtmp4](FIRSTNAME, LASTNAME, HOMEPHONE, WORKPHONE,

  EXT,...

/*top 25 customers*/

select sales.customerid as customerid,sales.sale As TOTAL,1 AS semirank,customers.customername as customername

from dbo.sales sales

inner join

 (

  select TOP 25 customerid,sum(sale) as Z/*needed for union?*/

  from sales

  group by customerid

  order by sum(sale) desc

) thebestcustomers

ON...

What hardware difference is there between the  integration-test and production/development server?

Are you restoring through the enterprise manager or query analyzer or ...?

Sql dmo errors can spring up when the servicepack level of the client tools mismatches the server servicepack level.

Have you checked that collation compatible option is on for the linked server?

The following links have a colorlistbox using a subform to implement the coloring

http://www.candace-tripp.com/pages/access_downloads.aspx

http://www.candace-tripp.com/download/colorlistbox.zip

Otherwise I would think it was a custom control.

I don't have experience with MSOLAP but

http://support.microsoft.com/default.aspx?scid=kb;en-us;218592

To query a local or a remote OLAP server database from SQL Server, you have to install the MSOLAP OLE DB provider on...

and the question is?