dts from DB2 on AS/400 to SQL 2000

Last Post 30 Aug 2004 10:52 AM by bigelectricmac. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
bigelectricmac
New Member
New Member

--
27 Aug 2004 07:59 AM
Hello,
I am running dts script from DB2 on AS/400 to SQL Server. If I use
"iSeries Access ODBC Drive" by setting up DSN, then I get complete
records. However, if I use linked server via "Microsoft OLE DB Provider
for ODBC Driver" calling same DSN (as above), then I get incomplete
records. FYI, the linked server property doesn't let me choose "iSeries
Access ODBC Drive" as provider.

Any suggestions?

Just clarify complete records vs. incomplete records...
I know that query should bring in 147 records, but the incomplete records
only bring in 101 records.

Junho
bigelectricmac
New Member
New Member

--
30 Aug 2004 10:52 AM
Do you mean the iSeries Access? Yes, we intall the iSeries Access on Server. If you mean something else, I am not sure what "client access express " is.

Thanks
Shafiq
New Member
New Member

--
02 Sep 2004 07:11 AM
This happend to me too.

here is the workaround I did.

Under the ODBC-DSN, Select your DSN Name then click Performance Tab then Click Advance then check off "Use Blocking with a fetch of 1 row" Then try your query again.

Thanks
Shafiq
You are not authorized to post a reply.

Acceptable Use Policy