Forum OpenACS Q&A: MS SQLServer setup

Collapse
1: MS SQLServer setup
Posted by Marty Israelsen on 09/24/24 12:41 AM
Hi Gustaf, We currently have a naviserver instance that connects to both PostgreSQL and Oracle. We are now wanting to configure naviserver to connect up to MS SQLServer. Is there a good resource that shows how to configure this? Does it require a compile step too?
Collapse
2: Re: MS SQLServer setup (response to 1)
Posted by Andrew Piskorski on 09/24/24 06:03 PM
Do you plan to use the nsdbtds database driver? nsodbc might also work. (But I'm not sure, I've never used MS SQL Server.)
Collapse
3: Re: MS SQLServer setup (response to 2)
Posted by Marty Israelsen on 09/24/24 07:03 PM
Thanks Andrew for pointing me in the right direction! I am not sure which one would work best either? I will first try the nsdbtds to see how that works. Again many thanks for pointing me to these repositories:)
Collapse
4: Re: MS SQLServer setup (response to 1)
Posted by Antonio Pisano on 09/30/24 12:53 PM

Another possibility, depending on your use case, may be TDBC.

All the best