November 2, 2011 at 11:55 am
Hello,
I have both Oracle 11g 32 bit/64 bit installed on my Windows 7 machine. Using VS 2008 BIDS.
I am getting this error when i open up the connection manager to create a new connection:
===================================
Could not get provider invariant name from the connection type qualifier "System.Data.OracleClient.OracleConnection, System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089". You may need to manually edit the 'Qualifier' property of the connection manager if the default one selected is different from what you want. (Microsoft Visual Studio)
===================================
Could not create a DbProviderFactory class for the provider invariant name 'Oracle.DataAccess.Client'. Verify that this provider is installed correctly on this computer. (Microsoft.DataTransformationServices.Design)
------------------------------
------------------------------
Program Location:
at Microsoft.DataTransformationServices.Design.ConnectionManagerUtils.GetConnectionTypeFromInvariantName(String providerInvariantName)
at Microsoft.DataTransformationServices.Design.ConnectionManagerUtils.GetInvariantNameFromConnectionType(String connectionType)
at Microsoft.DataTransformationServices.Design.ConnectionManagerUtils.EditAdoNetConnectionString(String qualifier, String connectionString, IServiceProvider serviceProvider, String& newConnectionString, String& newConnectionProvider)
===================================
Exception has been thrown by the target of an invocation. (mscorlib)
------------------------------
Program Location:
at System.RuntimeFieldHandle.GetValue(Object instance, RuntimeTypeHandle fieldType, RuntimeTypeHandle declaringType, Boolean& domainInitialized)
at System.Reflection.RtFieldInfo.InternalGetValue(Object obj, Boolean doVisibilityCheck, Boolean doCheckConsistency)
at System.Reflection.RtFieldInfo.GetValue(Object obj)
at System.Data.Common.DbProviderFactories.GetFactory(DataRow providerRow)
at System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName)
at Microsoft.DataTransformationServices.Design.ConnectionManagerUtils.GetConnectionTypeFromInvariantName(String providerInvariantName)
===================================
The type initializer for 'Oracle.DataAccess.Client.OracleClientFactory' threw an exception.
===================================
The provider is not compatible with the version of Oracle client (Oracle Data Provider for .NET)
------------------------------
Program Location:
at Oracle.DataAccess.Client.OracleInit.Initialize()
at Oracle.DataAccess.Client.OracleClientFactory..cctor()
I have been bouncing around. I am trying to figure out if this is an issue with my machine.config or something else entirely. Please let me know if you have come accross this issue and also if you have a resolution.
I am also getting a Connection Manager error that pops up just before:
TITLE: Connection Manager
------------------------------
The connection string is not valid. Keyword not supported: 'unicode'.
------------------------------
BUTTONS:
OK
------------------------------
And i am not familiar with where this error would be coming from. I am also believe that this might be a config file somewhere.
Thanks for your time.
Sam
February 8, 2012 at 3:42 pm
Were you able to fix this ?
February 8, 2012 at 6:08 pm
Hello,
Yes i was able to fix this. It seems that the Oracle 11g R2 client install (11.2.0.1) does not update the <DbProviderFactories> in the machine.config files found
C:\Windows\Microsoft.NET\Framework\<version>\CONFIG
C:\Windows\Microsoft.NET\Framework64\<version>\CONFIG
The resolution was to download the ODAC 11.2 Release # (11.2.0.#.0) with Oracle Developer Tools for Visual Studio
from
http://www.oracle.com/technetwork/database/windows/downloads/index-101290.html
Unfortunately that means that if you were using 11.2.0.1 you will have to upgrade your version of Oracle to a more recent build.
Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply