Zeoslib Portal

Posted: **20.08.2007, 16:02**

How to create connection to MSSQL?

What params, DLLs, etc?

tnks,

Andre

Posted: **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 ...

Posted: **27.08.2007, 13:32**

Thanks!

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

ADO works fine. MSSQL didn't work.

Posted: **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 ...

Posted: **28.08.2007, 13:44**

Tnks!

I will install it.... :>

Posted: **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

Posted: **16.08.2009, 22:32**

Which protocol have you set? ADO or MSSQL?

Posted: **16.08.2009, 22:35**

Which protocol have you set? ADO or MSSQL?

ADO!