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
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.
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
Author: ADO.NET and XML: ASP.NET on the Edge
***************************
Strange women lying in ponds distributing swords is no basis for a system of government.
***************************
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
mikemiller99...
Member
20 Points
4 Posts
Using ODP.net in Visual Studio
Dec 19, 2003 04:58 PM|LINK
Cowboy
Member
301 Points
67 Posts
MVP
Re: Using ODP.net in Visual Studio
Dec 22, 2003 03:12 PM|LINK
MVP; MCP: +I, SE, SD, DBA
Author: ADO.NET and XML: ASP.NET on the Edge
***************************
Strange women lying in ponds distributing swords is no basis for a system of government.
***************************
MatiasN
Participant
1660 Points
332 Posts
Re: Using ODP.net in Visual Studio
Jan 07, 2004 12:42 PM|LINK
Website=www.cybral.com
Email=mnolton@cybral.com
Blog=weblogs.asp.net/mnolton