How can we create and save a data connection in library?
You can do this using Tools --> Manage Data connections.
I used that , but it was not working as the ODP.NET was not installed in the client system...
So, now you would have installed ODP.NET on machine and able to save data connection in library as it is faster and better than the default data provider for Oracle.
This Question already has a 'Best Answer'. If you believe this answer is better, you must first uncheck the current Best Answer