Re: [snapdal-devel] ODBC?

[Philip N. <pan...@ya...>]

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 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.

<?xml version="1.0" encoding="utf-8" ?> 
<DataFactory>
  <Provider name="ODBC" assembly="System.Data">
    <Connection type="System.Data.Odbc.OdbcConnection" />
    <Command type="System.Data.Odbc.OdbcCommand" />
    <Parameter type="System.Data.Odbc.OdbcParameter" />
    <DataAdapter type="System.Data.Odbc.OdbcDataAdapter" />
    <DataReader type="System.Data.Odbc.OdbcDataReader" />
    <ParameterTypes>
	    <ParameterType name="int" enum="System.Data.Odbc.OdbcType.Int" />
	    <ParameterType name="bigint" enum="System.Data.Odbc.OdbcType.BigInt" />
	    <ParameterType name="bigint" enum="System.Data.Odbc.OdbcType.BigInt" />
	    <ParameterType name="binary" enum="System.Data.Odbc.OdbcType.Binary" />
	    <ParameterType name="bit" enum="System.Data.Odbc.OdbcType.Bit" />
	    <ParameterType name="char" enum="System.Data.Odbc.OdbcType.Char" />
	    <ParameterType name="date" enum="System.Data.Odbc.OdbcType.Date" />
	    <ParameterType name="datetime" enum="System.Data.Odbc.OdbcType.DateTime"
/>
	    <ParameterType name="decimal" enum="System.Data.Odbc.OdbcType.Decimal" />
	    <ParameterType name="double" enum="System.Data.Odbc.OdbcType.Double" />
	    <ParameterType name="image" enum="System.Data.Odbc.OdbcType.Image" />
	    <ParameterType name="nchar" enum="System.Data.Odbc.OdbcType.NChar" />
	    <ParameterType name="ntext" enum="System.Data.Odbc.OdbcType.NText" />
	    <ParameterType name="numeric" enum="System.Data.Odbc.OdbcType.Numeric" />
	    <ParameterType name="nvarchar" enum="System.Data.Odbc.OdbcType.NVarChar"
/>
	    <ParameterType name="real" enum="System.Data.Odbc.OdbcType.Real" />
	    <ParameterType name="smalldatetime"
enum="System.Data.Odbc.OdbcType.SmallDateTime" />
	    <ParameterType name="smallint" enum="System.Data.Odbc.OdbcType.SmallInt"
/>
	    <ParameterType name="text" enum="System.Data.Odbc.OdbcType.Text" />
	    <ParameterType name="time" enum="System.Data.Odbc.OdbcType.Time" />
	    <ParameterType name="timestamp" enum="System.Data.Odbc.OdbcType.Timestamp"
/>
	    <ParameterType name="tinyint" enum="System.Data.Odbc.OdbcType.TinyInt" />
	    <ParameterType name="uniqueidentifier"
enum="System.Data.Odbc.OdbcType.UniqueIdentifier" />
	    <ParameterType name="varbinary" enum="System.Data.Odbc.OdbcType.VarBinary"
/>
	    <ParameterType name="varchar" enum="System.Data.Odbc.OdbcType.VarChar" />
    </ParameterTypes>
  </Provider>
</DataFactory>

If this doesn't work for you, get back to the list and it'll prompt me to
release the beta I've been sitting on for almost a month now.

--- Cory Foy <Cor...@mo...> wrote:

> Hi All,
> 
> I don't know if anyone is still checking this list - but if so, has 
> anyone written the Odbc provider for SnapDAL? I've got it partially 
> working now, but if someone has it already completed that would be 
> excellent. Thanks!
> 
> Cory
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by Yahoo.
> Introducing Yahoo! Search Developer Network - Create apps using Yahoo!
> Search APIs Find out how you can build Yahoo! directly into your own
> Applications - visit http://developer.yahoo.net/?fr=offad-ysdn-ostg-q22005
> _______________________________________________
> Snapdal-devel mailing list
> Sna...@li...
> https://lists.sourceforge.net/lists/listinfo/snapdal-devel
> 


Philip - http://blogs.xcskiwinn.org/panmanphil
"There's a difference between righteous anger and just being crabby" - Barbara