I have an Oracle 9i server. To access the data in Oracle, I setup an ODBC connection to it and am able to return data from it using WinSQL (a general ODBC database client). The SQL statement is simply "SELECT * FROM COLOR" and all 133 records returned properly.
I need to copy the data from the Oracle server to SQL Express, therefore I set up linked server (by Microsoft ODBC provider) using the same ODBC connection as described above.
The problem is: only 32 records returned.
May I ask if there is any problem to this linked server setup?
Thanks.
Does any one has any idea..please help.^^
|||I forwarded this to a linked-server guru here at Microsoft and here's the reply he gave:
Usually provider bugs. Updating the client versions for Oracle's code often fixes this class of issue.
Note that Kagera isn't really fully supported anymore either.
Oracle's native OLE/DB provider is the usual choice instead of ODBC.
Hope this is helpful.
|||Same problem here,
created a query within Oracle SQLplus that returns 344.743 records. When I use the same query within the SSIS package it only returns 60.000 records? I'm connected with OLE DB and installed the latest Oracle 9i client. When I add a count within the query in SSIS is also concludes that there are 344.743 records.
Urgent help needed because we are migrating from DTS to SSIS.
Any idea what the problem can be?
Thankz
Ron Killaars
IT Engineer Energie
irect BV
No comments:
Post a Comment