Recent

« previous next »
Pages: [1]

Author Topic: connecting to mssql server  (Read 4624 times)

rcmz

  • Jr. Member
  • **
  • Posts: 70
connecting to mssql server
« on: July 31, 2021, 07:28:13 pm »
hello to all,

I searched the forum for this question and did not find anything helpful.  :(

How can I connect to mssql server ?  %)

TIA
Ramiro
Logged

nouzi

  • Sr. Member
  • ****
  • Posts: 269
Re: connecting to mssql server
« Reply #1 on: August 01, 2021, 02:29:05 am »
Use zeosdb
Logged
My English is  bad
Lazarus last version free pascal last version
Lazarus trunk  free pascal trunk 
System : Linux mint  64bit  Windows 7 64bit

rcmz

  • Jr. Member
  • **
  • Posts: 70
Re: connecting to mssql server
« Reply #2 on: August 01, 2021, 05:09:30 am »
thx,

do you have a sample project ?

TIA
Ramiro
Logged

LacaK

  • Hero Member
  • *****
  • Posts: 682
Re: connecting to mssql server
« Reply #3 on: August 03, 2021, 07:54:46 am »
To connect to MS SQL Server you can use either:
  • native TMSSQLConnection
  • or TODBCConnection
both components are placed on sqlDB tab in Lazarus IDE
Logged

dseligo

  • Hero Member
  • *****
  • Posts: 984
Re: connecting to mssql server
« Reply #4 on: August 03, 2021, 10:14:37 am »
Quote from: rcmz on August 01, 2021, 05:09:30 am
do you have a sample project ?

I also use ZeosDBO for MSSQL. Put TZConnection on form or data module, set database, hostname, protocol and user properties in Object inspector. For protocol I use 'FreeTDS_MsSQL>=2005'. You'll also need library dll (try here: https://sourceforge.net/projects/zeoslib/files/3rd%20party/FreeTDS/).

Then set Connected property to true - if there are no errors you are connected.
Logged
Pages: [1]
« previous next »
 

TinyPortal © 2005-2018