OleDB Client-side

[Marcio_cota]

Is possible to connect into client-side using oleDB and SqlServer?

[Jeff Luther]

Yes. I haven't used this to connect to MS SS, but I got this Provider string back from one of the developers:

[oledb]
; Everything after this line is an OLE DB initstring
Provider=SQLOLEDB.1;Password=<password>;Persist Security Info=True;User ID=<user>;Initial Catalog=<DB_Name>;Data Source=<Source_Name>

If you save those 3 lines to a file with UDL extension, then double-click on the file name, a Data Link Properties dlg. editor will open. To use in TD, check Help for the system var. SqlUDL.