I get the following Visual Studio error when dragging a table from the DbExplorer to a Dataset:
Mouse drag operation failed. Dataprovider identified by guid '0bd2b57f-bed8-441d-a0d2-1999c7f41123' could not be loaded.
Dragging the same table from Visual Studio's Server Explorer works fine.
OraDeveloper for VS2005 (Trial) error? (v1.70.33)
By default, drag'n'drop is tuned to work with OraDirect .NET data provider. So it looks for DDEX provider shipped with OraDirect.NET and such error comes if you don't have one installed.
To switch to another provider go to Options->Core Lab Developer Tools->Databases->Oracle and choose appropriate provider from list.
To switch to another provider go to Options->Core Lab Developer Tools->Databases->Oracle and choose appropriate provider from list.
VisualStudio Dataset Designer Error
I am also evaluating both OraDirect and OraDeveloper within VS 2005. I get the same error when I use the OraDirect.NET driver for creating my connection and objects. I am able to drag n drop table objects to the dataset designer when I use the MS OracleClient (System.Data.OracleClient). My goal is to move away from the MS library.
Shouldn't I be able to drag n drop to use the designer when I'm working with OraDirect? I installed this library prior to installing OraDeveloper.
Thanks!
Shouldn't I be able to drag n drop to use the designer when I'm working with OraDirect? I installed this library prior to installing OraDeveloper.
Thanks!
VS version
I am running VS 2005 Professional. Version 8.0.50727.42
Thanks
Thanks
I'm sorry for not answering for so long. We couldn't reproduce the problem that you have described. We need you assistance to reproduce it.
Please, check whether OraDirect itself works with Dataset Designer or not.
To perform check open Server Explorer, choose Add Connection and then Change Data Source. Select Oracle Database from list and OraDirect .NET Data Provider from the combo box below it. Then specify logon parameters and submit new connection.
Now you can try to drag table from connection you have created onto Dataset Designer.
Please, inform us of the results.
Please, check whether OraDirect itself works with Dataset Designer or not.
To perform check open Server Explorer, choose Add Connection and then Change Data Source. Select Oracle Database from list and OraDirect .NET Data Provider from the combo box below it. Then specify logon parameters and submit new connection.
Now you can try to drag table from connection you have created onto Dataset Designer.
Please, inform us of the results.