Oracle factory problem with developing from SDK

Vote:
 
Hi, I do not have SQL Express on my dev machine so I have taken the EpiServer DB from the VS project and restored this to SQL Server and changed the connection string accordingly. I am getting an exception, Expecting non-empty string for 'providerInvariantName' parameter and the stack trace has these calls, System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName) +18 EPiServer.DataAccess.OracleDatabaseFactory..ctor(ConnectionStringSettings connectionSettings) +174 EPiServer.DataAccess.DataAccessBase.get_DatabaseFactory() +217 EPiServer.DataAccess.DataAccessBase.get_IsOracle() +20 EPiServer.Global.SetupBaseLibrary() +234 Can you tell me what is causing the DA to try to instatiate the Oracle factory as opposed to the SQL one - I cannot find any reference to where this is set. Many Thanks in advance Mike
#15946
Mar 25, 2008 19:07
Vote:
 
In case anyone else is trying to use SQL Server from the SDK and not SQL Express, you need to add this attribute to the connection string, providerName="System.Data.SqlClient" Then it works fine. Mike
#16674
Mar 25, 2008 19:13
This thread is locked and should be used for reference only. Please use the Episerver CMS 7 and earlier versions forum to open new discussions.
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.