David Briars Posted August 21, 2020 Share Posted August 21, 2020 Up until now we have been using the WebFOCUS Oracle and Netezza adapters. We are now installing MS SQL Server. We also have a requirement to build WF reports against against MSSQL. We are now considering if we should use the MSSQL OLE adapter or ODBC. My DBAs are reviewing which would make the best choice. Does anyone have any experience in making this choice, or have a preference Link to comment Share on other sites More sharing options...
NYCBabak . Posted August 21, 2020 Share Posted August 21, 2020 I used to use OLE but have gradually switched over to SQL Server ODBC. I think it had something to do with Microsoft support. Take a look at this link. https://webfocusinfocenter.informationbuilders.com/wfappent/TL3s/TL_srv_rel/source/mssql_oledb.htm Link to comment Share on other sites More sharing options...
Manoj Chaurasia Posted August 22, 2020 Share Posted August 22, 2020 I checked with Mark Nesson and he recommends the OLE DB configuration. It is more robust that ODBC. Link to comment Share on other sites More sharing options...
Steven Hall Posted August 23, 2020 Share Posted August 23, 2020 We use OLE. (Adding characters so my post is over 20 characters) Link to comment Share on other sites More sharing options...
David Briars Posted August 24, 2020 Author Share Posted August 24, 2020 Thank you for your thoughts Babak, Chuck, and Steven. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now