Re: [snapdal-devel] ODBC?

[Cory F. <Cor...@mo...>]

Philip Nelson wrote:
> Actually, the Odbc provider is built on the fly from the metadata in the
> DataFactory.config file. The class is CustomProvider and hasn't changed much in
> the last year and a half. If you can provide a failing test, I may put it in
> the suite.

I'll take a little closer look at that...

>  I did get your off list message and tried to write quick test to duplicate the
> problem, but was unable to do so. One of a couple of possibilities off the top
> of my head.
> 
> - something was fixed between the prerelease and my current version
> - my config file is slightly different, particularly with assembly attribute
> 
> You will also notice that I now support specifying parameter type mappings in
> the config file in case the defaults provided by System.Data aren't exactly
> what you need.

I saw the ODBC DataFactory.config file in the src folder, but it seemed 
configured wrong, particularly because A) the app refused to load the 
System.Data.dll (hence why you saw the full path in my version), and 
because it had System.Data.OdbcConnection and such instead of 
System.Data.Odbc.OdbcConnection.

What I did to work around it was modify the source to have a new 
OdbcProvider class, including changing the ProviderType enum to be aware 
of it. The OdbcProvider class was a duplicate of the OleDbProvider, 
except using only the parameter types supported by Odbc. By doing this, 
I was able to get a simple query to work, but TOP selects are failing 
for some reason.

I'll back out those changes and try using the other ways to see if I can 
get that to work. Thanks for the reply!

Cory