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.
