Can I connect with Windows Authentication Mode

[Tugrul Tamturk]

Hi,

I downloaded UniDAC trial and testing it. I use ADO at the moment and I am looking for a replacement. I am seeking better performance and cross database platform..

My first problem is that connecting with UniConnection. Ms SQL windows has authentication connection (or Windows NT Integrated security) mode. But UniConnection seems like not to connect without usename / password..

Is there a way to connect via W/A mode?

One more question : I use UDL files to define connection rules while using ADO. Is there a similar method with UniDAC?

Thanks

[Joao Cadilhe]

1 - "But UniConnection seems like not to connect without usename / password.."

Double click Uniconnection component, go to Options:
If Authentication = auWindows no password required (Windows authentication mode).
If Authentication = auServer, you must type user and password.
In this case don't forget to set Uniconnection.LoginPrompt = False.
See Unidac Help.

2 - "One more question : I use UDL files to define connection rules while using ADO. Is there a similar method with UniDAC?"

Use .Ini file, or Windows registry to store connection information and load this information, before open Uniconnection.


Joao Cadilhe.

[Tugrul Tamturk]

Thanks for help!

[Tugrul Tamturk]

I could not find help files for Delphi2007. Is it because of Trial or what?

I understand that Authentication and other options are available on Designtime.. What about runtime? How can I change these options from code. I can not find help files properly installed in Delphi2007, I can not find any other documentation...

UniConnection1.Options.Authentication or similar property does not exist...

Thanks for interest...

[Joao Cadilhe]

Hi, Tugrul:
From Unidac Help:

UniConnection.SpecificOptions.Values['ApplicationName'] := 'My application';

There are a lot of Uniconnection and Uniquery SpecficOptions for SQL Server, documented in Unidac Help. Look in your Unidac Install folder, maybe you can find help files there.

Regards.

Joao Cadilhe.

[Tugrul Tamturk]

Hi Joao,

Thanks for fast and helpful reply.

During my investigation, I am able to get help files (another download link). And I must say, documentation is quite good. While learning unidac components, I am geting very excited.

Now I seriously plan to purhcase and use these powerfull components.

Sincerely
Tugrul