Understanding MS SQL connection

cmatrix · Post by **cmatrix** » 04.08.2009, 22:00

Please indicate if my understanding is correct. The mssql protocol cannot be used with MS SQL 2005 and above. For MS SQL 2005 and up you need to use ado protocol. If so, how can I have the Data Link Properties dialog pop-up during run-time when a user selects the ado protocol from my options screen?

Post by **mdaems** » 08.08.2009, 07:15

Hi,

I think your understanding is correct. But I have no idea how you can launch this settings screen. I suppose you could check how this dialog is launched from the Windows menu's and do the same call from your program.

Someone did this before?

Mark

teo · Post by **teo** » 02.10.2009, 07:59

Yes. Zeoslib did. It's simply in one of the units of the zeoslib distribution..

there is a routine called PromptDatasource in \src\dbc\ZDbcAdoUtils.pas wich will bring up the dialog.