Forum > Databases
how to connect msSql server version 16
rcmz:
hi,
What component do you recommend to connect to msSql server version 16?
some samples are wellcome.
TIA
Ramiro
Handoko:
Have you tried mssqlconn or Zeos?
https://wiki.lazarus.freepascal.org/mssqlconn
https://wiki.freepascal.org/Zeos_tutorial
toby:
hi
since you appear to be at the very beginning of you sql journey you should immediately switch to mariadb - in term of reliability and speed and security it runs rings around ms nonsense
you will get tremendous already written code for mariadb/mysql in the fpc examples and this forum has great code in it's history to
paweld:
@rcmz: as @handoko wrote: Zeos or SqlDB.
In the attachment is a simple example using Zeos components - the MSSQL OleDB driver must be installed.
Zvoni:
--- Quote from: toby on July 08, 2024, 08:39:47 pm ---hi
since you appear to be at the very beginning of you sql journey .....
--- End quote ---
Whatevery gave you that impression?
--- Quote ---you should immediately switch to mariadb - in term of reliability and speed and security it runs rings around ms nonsense
you will get tremendous already written code for mariadb/mysql in the fpc examples and this forum has great code in it's history to
--- End quote ---
What utter nonsense.
Do you know, if his requirements are predefined? Like working in a company, where he is required to write a tool accessing there Database-Server, which runs MS SQL?.
I do work for a company, which runs a DB2 on an IBM iSeries.
If i would post a question like "Which component/classes to use to access DB2?" and i would see an answer like yours, you would go straight to my ignore list.
So please refrain from non-answers.
It's just polluting the forum
Navigation
[0] Message Index
[#] Next page