Member Avatar for Papa_Don

Hi group,

I've looked all over the internet to find my solution without luck. Hopefully you can help.

I need to add an Oracle server to my data sources in Visual Studio (if it matters, I'm using VB.net). Per the best instructions I've found so far, I've selected "Data Sources" and have chosen to "Add New Data Source". I've chosen "Database" as to where the application will get data from. "Dataset" is the database model chosen. When trying to add the new connection, my choices are "Microsoft Access Database File", "Microsoft SQL Server", "Microsoft SQL Server Database File" and "<other>". I do not see a choice for an Oracle Database. I believe that is what I need to add. I do have a drop down box for the "Data provider". In that it give options for .Net framework providers in SQL and OLE DB. Again, nothing for Oracle. Clearly I must be doing something wrong. But what? Can you help??

In advance, thanks for all you do.

Don

  • 1 Contributor
  • 1 Reply
  • 462 Views
  • 23 Hours Discussion Span
  • Latest Post Latest Post by Papa_Don
Member Avatar for Papa_Don

I did find the solution on my own. I kept trying different things. It all came down to choosing "<other>" and loading the Oracle OLE DB.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.