http://forums.asp.net/t/423869.aspx/1?Using+ODP+net+in+Visual+StudioWed, 07 Jan 2004 12:42:08 -0500423869423869http://forums.asp.net/p/423869/423869.aspx/1?Using+ODP+net+in+Visual+Studio Hi, I have downloaded the ODP.net driver from Oracle and am starting to use it in my applications. However I am finding that the ODP components added to my toolbox are not that user friendly. If anyone is using this component, do you know if you need to configure something so that there are some wizards available with it? (i.e. like OleDBDataAdapter Component?) Mike 2003-12-19T16:58:07-05:00425463http://forums.asp.net/p/423869/425463.aspx/1?Re+Using+ODP+net+in+Visual+Studio Welcome to Larry's world. It seems Oracle assumes you can do this without training wheels, so you are on your own now. As such, there may not be any wizards available, period. If you have documentation that there are, check the installation doc (which Oracle usually has) and see if there are any suggestions. If the docs do not mention wizards, there are none. We have an app that I built in SQL Server that is in Oracle in production. My method was to go through and change Sql to Oracle, ala SqlConnection becomes OracleConnection, and add a Provider to the Oracle conn string. If the ODP naming convention is similar, you may be able to design some portions in OleDb and change to ODP convention. This will not help drag and drop, but will at least give you a template to pull code from for other pages. An even better option would be to create a generic data layer, but you may not have time to accomplish this. Good luck! I planned on using ODP, but getting approval to install software at this gig takes an act of Congress. 2003-12-22T15:12:53-05:00435887http://forums.asp.net/p/423869/435887.aspx/1?Re+Using+ODP+net+in+Visual+Studio I've used ODP.Net as well. It's pretty much the same syntax as using Microsoft's SqlClient, OleDb or the Oracle provider by Microsoft. Cowboy is right when it comes to documentation and there is far less out there on the Internet as to how to use it (because not too many people are using it). Overall the performance is supposed to be better but the installation requirements are painful and can cause companies to steer away from using it on a large scale unless they have already made the commitment to Oracle. -Mathew Nolton 2004-01-07T12:42:08-05:00