OleDB Client-side

General discussion forum about all databases other than SqlBase.

OleDB Client-side

Post by Marcio_cota » 05 Apr 2010, 14:50

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

Jeff Luther

Re: OleDB Client-side

Post by Jeff Luther » 05 Apr 2010, 19:47

Yes. I haven't used this to connect to MS SS, but I got this Provider string back from one of the developers:
; 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.

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 1 guest