Thanks. I really did not have to use Linked Server thru VB code. A straight query to AS400 through ADO works fine

Thankf for...

My Linked Server name and sql query change. Even if I write multiple queries to fulfill all the conditions, I am still left with the linked server name as a...

Thanks a lot for your help.

As for the int variable, I am using

CREATE PROCEDURE proc1 @v1 int

AS

INSERT INTO destTable SELECT * FROM ssourceTable WHERE col2 < @v1

I checked the...

I am told Linked Servers are faster than DTS. I use linked server through ODBC driver (DSN).