Hi Andrew

I am assuming that you are using Access to view a SQL database via linked tables and that on the SQL server you have created a linked server to...

Hi...update

solved the problem by using the variable in OPENQUERY against the linked server.

this issue only appeared to manifest against large source tables (>1M rows)....still dont know why, but the...

Hi

We are trying a similar project..SQL2005 (Std), SSRS and WSS3 SP1 on Windows2008 (32-bit)...so far unsuccessfully.

Here is a link that you might find useful:

http://blogs.msdn.com/sharepoint/archive/2007/08/02/microsoft-sql-server-reporting-services-installation-and-configuration-guide-for-sharepoint-integration-mode.aspx

and the Word doc...

Hi Jerry

Thanks for your thoughts.....and yes we have been reading and searching:)

SQL 2005 SSRS also has a SharePoint Integration Mode ......you also need to download the reporting services add in...will...

Jason...you can get the same result using your timestamp

SELECT tm.Business_unit_id, tm.Download_Type, tm.transmit_status_code,TM.Transmit_Timestamp

FROM Transmit_Manifest TM

INNER JOIN

(SELECT MAX(Transmit_timestamp) AS MaxTimeStamp

FROM Transmit_Manifest

Where download_type = 'A'

GROUP BY Business_unit_id ) MAXTIME

ON TM.Transmit_Timestamp=MAXTIME.MaxTimeStamp

gah

SELECT tm.Business_unit_id, tm.Download_Type, tm.transmit_status_code,TM.Transmit_Timestamp

FROM Transmit_Manifest TM

INNER JOIN

...

Thank you Gail.

I thought as much, but needed some clarification.

Will probably create them now anyway as they will assist other users in understanding the schemas.

Graham

Hi Richard

I was interested to read your post because we are considering building a solution that sounds similar to yours.

I have a system developed using sql 2005. It allows users...

make sure that any 3rd party ODBC drivers you intend to use are 64-bit.

You can install 32bit drivers on Win64 (odbcad32.exe)..but SQL64 will not be able to use them.

regards gah

Thank you very much Marios...that has clarified it.

regards gah

Thanks for the reply Marios

- enable AWE to max memory of 4 GB, to enable the data buffer of your SQL instance to 'see' 4 GB of memory and leave...

Apologies if I should have created a new topic....

Having read thro this thread and a multitude of others on here and elsewhere, I must confess to still being confused....

We need...

Thanks for the info, it is appreciated.

regards gah

jgrubb (10/29/2008)

---

There should be 64 bit options for progress. Progress should support it, and I used to work for Openlink www.openlinksw.com which did support it with a choice...

Hi

I havent tested the code but the comments posted against the artice say

"usp_GetIndexKeys should have been usp_GetIndexColumns"...that script is there in the post.

gah