FiveTech Support Forums

Which dll file do I need to connect MSSSQL using ADO?

All recent Windows versions have the drivers installed by default.
You do not have to do anything.
Just use FW_OpenAdoConnection () and provide teh parameters correctly.

Why are you asking? Are you experiencing problems in connecting?
What is the Windows version of your PC?

I have Windows 7...I would like to connect with SQL Server 2014

I'm not sure if decide between FWH ODBC Class or ADO class....I'm not sure if query speed is granted by the drivers itself instead the class.

Please, advise

ODBC is the oldest technology
ADO is based on OLEDB which is a later development.

ADO works the best with MSSQL. There is no better option than ADO for MSSQL.

Thanks

Which is the most complete fwh sample with all ado functions to learn?