I haven't used the Devart objects before. But to get the text you need for the configuration try to put a line like this at the beginning of your program. Then pull the result out and put it in the text file.
var fullName = typeof(OracleConnection).AssemblyQualifiedName; As for the DbConnectionFactory.... maybe? Is that useful to you? It sounds like you have something working. Do you want to share what that looks like? Nathan On Mon, May 13, 2013 at 2:53 PM, Bill Burton <[email protected]> wrote: > Hello, > > I've been attempting to use Rhino.Etl to import an XML file into an Oracle > database using the Devart dotConnect driver. Ran into problems where the > method: > > public static IDbConnection Connection(ConnectionStringSettings > connectionString) > > could never find the Devart driver. The culprit is the following line in > that method: > > Type type = Type.GetType(connectionString.ProviderName); > > Someone on this list mentioned that a strong name has to be used for the > providerName. So I tried that and it still failed with a different error. > I suppose I didn't specify the strong name correctly but I have no idea > what to change to fix it. > > My only alternative was to then to implement a custom > OutputCommandOperation with it's own connection logic cloned from > Use.Connection but otherwise had a significant amount of redundant code > from the original with the only difference being that it instantiates the > OracleConnection class. > > Then one day while trolling through the machine.config for no good reason, > I stumbled upon a configuration for <DbConnectionFactories>. After looking > into this, patched the Use.Connection method so if the Type.GetType() call > returns null, it will then try DbProviderFactories.GetFactory(). Only if > both these methods fail will an InvalidOperationException be thrown with a > detailed message indicated how the connection attempts were made. > > Does adding DbConnectionFactory support seem like a useful enhancement? > > Thanks, > -Bill > > -- > You received this message because you are subscribed to the Google Groups > "Rhino Tools Dev" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/rhino-tools-dev?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- You received this message because you are subscribed to the Google Groups "Rhino Tools Dev" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/rhino-tools-dev?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
