Cannot Create OraDirect 3.5 Data Source in VS 2005

Cannot Create OraDirect 3.5 Data Source in VS 2005

Postby 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.
murfdude
 
Posts: 12
Joined: Fri 24 Mar 2006 14:09
Location: Florida, US

Postby 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
              description="CoreLab OraDirect .NET Data Provider" type="CoreLab.Oracle.OraDirectFactory, CoreLab.Oracle, Version=3.50.9.0, Culture=neutral, PublicKeyToken=09af7300eec23701" />
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Postby murfdude » Thu 20 Apr 2006 13:39

Followed instructions above. Also added license file to project root. Same result.
murfdude
 
Posts: 12
Joined: Fri 24 Mar 2006 14:09
Location: Florida, US

Postby 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.
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06


Return to dotConnect for Oracle