Lazarus with sql server
lazarus / 16-Databases

----------------------------------------------------------------------
diegolaquino · 2017-01-17 01:58

Hi, i need help. I'm begginer and i am having problems with lazarus
and sql server, i'd like to know if anybody have a article step by
step for this? thank you

----------------------------------------------------------------------
fpcoder · 2017-01-17 03:50

Since you're newbie, I guess you need to learn about Lazarus DB
programming in general? The wiki has it:

http://wiki.lazarus.freepascal.org/SQLdb_Tutorial0 (parts 0 - 4)
http://wiki.lazarus.freepascal.org/SqlDBHowto
http://wiki.lazarus.freepascal.org/Working_With_TSQLQuery

http://wiki.freepascal.org/Lazarus_Database_Overview#Lazarus_and_MSSQL
.2FSybase
http://wiki.freepascal.org/mssqlconn

----------------------------------------------------------------------
dbots · 2017-01-24 18:41

First you should create an ODBC filedsn, using ODBC FileDSN wizard.
Then, you place on a form an ODBC connection and SQLQuery component.
Connect SQLQuery with ODBCConnection (Database property)
On ODBCConnection set the FileDSN property to the full path where your
dsn file exists.
Finally use "Open" and "Close" methods to Connect / Disconnect and
"Connected" property to check if you are connected.
It works like a charm !