ODP.NET

Hello There,

I am running Oracle 11g on windows 7 32 bit machine. I am using SSIS packages to connect to the database from a windows 7 64 bit client machine with the Oracle 11g 32 bit client installed. I have noticed some that when I select more than 25 records from a table within SSIS the results are not returned to the SSIS package, it is like they are being dropped before they reach the client and the SSIS package just hangs. I can run the same queries using SQL*Plus on the client machine and the results are returned instantly.

I am guessing this symptom is something Oracle or network related, because when we moved the Oracle database to the same vlan as the client the results can be returned to SSIS. For example the client (192.168.2.55) was originally on a different vlan than the database (192.168.3.45). The resultsets would be not be returned. When we moved the client to (192.169.3.55) the results would return to the SSIS client. Now that we moved it back the resultsets are hanging. Looking at v$sessions and using trace I can see that the query is making it to the server.

Is their any restriction on how Oracle returns resultsets to clients based on where they are? I haven't changed any settings on the db server, I did a complete default installation. Any help is appreciated.

thanks,

CK