Recent

Author Topic: ODBC or MSSQLConnection  (Read 894 times)

echi

  • Newbie
  • Posts: 2
ODBC or MSSQLConnection
« on: March 04, 2021, 01:29:24 pm »
Hello,

I have apps that connect to MSSQL via TODBCConnection. I've heard that it is better to connect with TMSSQLConnection.
Is this true? Why is it "better"? What are differences?

Someone told me that an ODBC driver doesn't support the full set of features that the database does...

MarkMLl

  • Hero Member
  • *****
  • Posts: 6676
Re: ODBC or MSSQLConnection
« Reply #1 on: March 04, 2021, 02:08:06 pm »
My preference would be to use ODBC as a fairly well-supported standard API if possible, but I've certainly come across restrictions with PostgreSQL: I don't know whether it's been added, but Postgres has various notification facilities which were alien to ODBC and there are no doubt others.

MarkMLl


MT+86 & Turbo Pascal v1 on CCP/M-86, multitasking with LAN & graphics in 128Kb.
Pet hate: people who boast about the size and sophistication of their computer.
GitHub repositories: https://github.com/MarkMLl?tab=repositories

 

TinyPortal © 2005-2018