Suggestion on ConnectString of TMSConnection

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Sergio Bertolotti
Posts: 54
Joined: Tue 02 May 2006 12:03
Location: Italy

Suggestion on ConnectString of TMSConnection

Post by Sergio Bertolotti » Fri 23 May 2008 13:46

Dear Support,

why in your TMSConnection component don't use/support a normal file UDL in connectString property ?

Do you plan to support it in the future of SDAC 4.x or 5.x ?

Best regards.

Sergio Bertolotti

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Tue 27 May 2008 15:00

Thank you for your suggestion. We will support UDL files in the nearest SDAC builds.

Sergio Bertolotti
Posts: 54
Joined: Tue 02 May 2006 12:03
Location: Italy

Post by Sergio Bertolotti » Tue 27 May 2008 15:04

Dear Antaeus,

many thank's for your answer.

Best regards.

Sergio Bertolotti

rs0107@seznam.cz
Posts: 1
Joined: Tue 11 Mar 2014 17:33

Re: Suggestion on ConnectString of TMSConnection

Post by rs0107@seznam.cz » Tue 11 Mar 2014 17:57

Hello,
i'm trying to adapt my ado application to SDAC (ver 6.9.18), but have problem with connection through microsoft datalink file (UDL). Cannot use this
connection1.ConnectString:='FILE NAME='+extractfilepath(Application.ExeName)+'myconfile.udl';

exception: invalid character ':' in non-quoted connection parameter value
the udl file is:
[oledb]
; Everything after this line is an OLE DB initstring
Provider=SQLOLEDB.1;Password=har1234;Persist Security Info=True;User ID=sa;Initial Catalog=balocal;Data Source=localhost,1433

This works fine with ado (tadoconnection), but not with TMSconnection.
thank you for advice.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Suggestion on ConnectString of TMSConnection

Post by AlexP » Wed 12 Mar 2014 15:33

Hello,

Currently, SDAC doesn't support this functionality. You can leave a suggestion to implement this feature at our uservoice page: http://devart.uservoice.com/forums/1046 ... components .

Post Reply