July 16, 2003 at 6:58 am
I am trying to connect my SQL server to my AS400 running JDE. I have installed Client Access which has installed an ODBC driver. I have created a ODBC connection and then created my linkd server.
I then go into Query analyser and put in this statement
'select * from Linkedserver.catalog.schema.filename'
this returns only the first 48 records from the file however there are 200000 records on the file.
Why is this not returning every record?
Please help
Paul
July 16, 2003 at 9:44 am
I've seen similar issues with this. Is this SQL 2000? Seems to be some Client Access issue, but we have not chased it down. We had a workaround, which I'll try to find out what it was.
One more thing I thought of. If you change the query to return less columns, do you get more rows? It seemed we had some buffer issue where if we returned fewer columns, we got more rows, more columns, less rows.
Steve Jones
July 16, 2003 at 10:22 am
Our workaround was to run the query in a DTS package and it seemed to work. Also worked fine, in SQL 7, same db structure, same linked server connection.
Haven't chased it down any further.
Steve Jones
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply