Spring.NET / Hibernate / Sybase

[Whatty]

Good morning,

Has anyone got any experience in using Spring.NET / Hibernate and Sybase and
can direct me to the best setup.

I am assuming that the ADO.NET provider is most likely a better choice than
the OLEDB driver but am not 100% sure.

Additionally if I am going to use the ADO.NET provider what is the
configuration that Spring / Hibernate is expecting for the connection
parameters.

I am currently using the following but am not having much luck with it:

<db:provider id="Sybase_Provider" provider="SybaseAse-AdoNet2"
connectionString="Server=[omitted];Port=5000;Initial Catalog=[omitted];User
ID=[omitted];Password=[omitted]"/>

Did not have much luck with the following either:

<db:provider id="Sybase_Provider" provider="SybaseAse-15"
connectionString="Server=[omitted];Port=5000;Initial Catalog=[omitted];User
ID=[omitted];Password=[omitted]"/>

Thanks in advance.

Whatty

[gg]

never used spring.net
basing on .net I would guess you should be able to use oledb connection:
similar to DreamU's
take a look DreamU's thread, you just may be able to customize to your need
after some transform.

You may also want to post the question to the forums in spring.net

good luck