Lazarus with sql server

[diegolaquino]

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

[kapibara]

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]

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 !