How to create connection to MSSQL?

avmesquita · Post by **avmesquita** » 20.08.2007, 16:02

How to create connection to MSSQL?

What params, DLLs, etc?

tnks,

Andre

Post by **Michael** » 27.08.2007, 06:07

Hi Andre,

in case you didn't solve your prolem, yet: The connection to any MSSQL Server is done by using the Microsoft OLE DB Provider for SQL Server. Be sure to have this provider installed. If this is done, the only thing you have to do is to drop a TZConnection on your data module or form and choose "ado" as protocol then click the "..." button found with the "Database" property of the TZConnection. Process the dialog that will pop up:

Provider: "Microsoft OLE DB Provider for SQL Server"

Connection: 1) the server(name) if resolved via DNS or its IP-address 2) username and password 3) the database to be used

Test your connection ... and confirm your setting by clicking "OK" ... that'll be all ...

avmesquita · Post by **avmesquita** » 27.08.2007, 13:32

Thanks!

Exists two kinks of "protocol" property: ADO and MSSQL.

ADO works fine. MSSQL didn't work.

Post by **Michael** » 28.08.2007, 05:24

Hi,

to use the MSSQL protocol you have to install the MSSQL Client Software

ADO (SQL OLE DB) runs without any installations ...

avmesquita · Post by **avmesquita** » 28.08.2007, 13:44

Tnks!

I will install it.... :>

victorgugo · Post by **victorgugo** » 16.08.2009, 20:52

Hi!
I have installed ms sql server 2008 express edition and using "Microsoft OLE DB Provider for SQL Server" generates error: this driver doesn't exist! Can anyone explaine me how to connect to this version of server!

____________
Lazarus 9.0.27
ZEOSDBO 6.6.5 Stable

Post by **seawolf** » 16.08.2009, 22:32

Which protocol have you set? ADO or MSSQL?

victorgugo · Post by **victorgugo** » 16.08.2009, 22:35

Which protocol have you set? ADO or MSSQL?

ADO!