I've had a similar issue for 2 different situations in the past.

1) The base oracle client had been installed, but the server not rebooted post install. (SQL+ was fine querying)

2) The Oracle drivers (10g) had been installed and not been patched correctly.

Hope any of the above is useful.

Cheers