Those were the fastest replies ever.

Thank you very much Adam and Matt!!

Sorry, please consider his_amount as Amount. I mistyped.

Here is my code:

------

CREATE VIEW

AS

SELECT

CASE WHEN Amount > 0 THEN his_amount ELSE '' END as [AmountIn],

CASE WHEN Amount < 0 THEN his_amount ELSE '' END as [AmountOut],

TransDate

FROM Payments

------

Error:

Server:...

CLIENT SIDE:

If the query is reading from large table, (100 columns x 20000 rows)

I have no problem getting results using SQL Query Analyzer on the Client side.

However,...

I changed the timeout settings to umlimited (timeout = 0)

Still getting the same error for the large tables.

I don't thing the error is related with the security because when I...

Any other ideas?

The client is SQL client.

FoxPro database is located on the shared drive.

My problem is accesing to the datasource from SQL using the link server.

For FoxPro, there is no client/server application type. Basically, All data stored in the server as FoxPro database files (*.dbc).

Thanks Luke,

I have already tried those suggestions. The link server works fine on the same machine with FoxPro. I couldn't solve the problem that I am having with the link...

Finally,

I have solved my problem.

That was a WIN Server 2K3 security issue. This corresponds to MSDAINITIALIZE DCOM component. The The Solution is:

Change permission settings for the component.

{2206CDB0-19C1-11D1-89E0-00C04FD7A829}.

Thanks everyone.

Hi Janet,

I have the latest (MDAC) version.

However, (MDAC) 2.8 release does not include Microsoft Jet, the Microsoft Jet OLE DB Provider or ODBC driver, the Desktop Database ODBC Drivers, or...