Cannot Create OraDirect 3.5 Data Source in VS 2005

murfdude · Post by **murfdude** » Wed 19 Apr 2006 16:58

I am having difficulty creating a Data Source based on OraDirect 3.5 in VS 2005. Here is the sequence of events leading to the failure:

1. Create new connection in Server Explorer (data can be viewed directly from Server Explorer)
2. Click "Add New Data Source" in the Data Source window
3. Select the connection defined in step 1
4. Select one or more tables to include in the Data Source

After selecting tables and clicking OK, the following 2 errors are thrown:

"Some updating commands could not be generated automatically. The database returned the following error: Failed to find or load the registered .NET Framework Data Provider"

"An error occurred while creating the new data source: Could not get type information for ''" (where is the name of the dataset specified in the wizard)

The .XSD file is created but does not successfully retrieve data from the database.

Paul · Post by **Paul** » Thu 20 Apr 2006 09:21

We cannot reproduce this problem with OraDirect .NET 3.50.9. Please check that you use "OraDirect.NET Data Provider" in "Add Connection"\"Change Data Source" dialog.

Please check that machine.config have the following line in DbProviderFactories section

Code: Select all

murfdude · Post by **murfdude** » Thu 20 Apr 2006 13:39

Followed instructions above. Also added license file to project root. Same result.

Paul · Post by **Paul** » Tue 25 Apr 2006 08:28

Send us please small demo project to demonstrate the problem to OraDirect .NET support address and include script to create server objects.