Need help to connect to MS SQLServer.

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Need help to connect to MS SQLServer.

sits
This post was updated on .
Hi all,
       I'm new in Orbeon. I’m trying to connect to MS SQL Server. Can someone help me out for this. And please give me the file details where I need to make changes.
Reply | Threaded
Open this post in threaded view
|

Re: Need help to connect to MS SQLServer.

Alessandro  Vernet
Administrator
Hi,

Orbeon Forms doesn't yet support SQL Server out-of-the-box, at least for forms you create in Form Builder, which I assume is what you're interested in. Right now Orbeon Forms supports eXist, Oracle, MySQL, and DB2. You can find those implementation in:

https://github.com/orbeon/orbeon-forms/tree/master/src/resources/apps/fr/persistence

I think the best way to support SQL Server would be to take one of these implementations, "clone it", and adapt the SQL statement as necessary for SQL Server. To do so, I would start from the MySQL or DB2 version (which are very very similar).

Alex
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet