Re: TADOConnection using mixed Authenication

I was looking at doing something along the lines of your first solution.
One issue I have is given a DSN name how do I read the configuration for
that DSN so I know if it is using Windows or SQL authenication?

"Guillem" <guillemvicens-nospam@xxxxxxxxxxxxxxxxxx> wrote in message
news:42fb0e6b@xxxxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> "rjg" <nospam_rjg@xxxxxxxxxxxxxxxxx> escribió en el mensaje
> news:42fa5496@xxxxxxxxxxxxxxxxxxxxxxxxx
>>I have an application that will be run on systems that have a DSN setup to
>>connect to a MSSQL 2000 server. Some of these systems use Windows
>>Authenication some use SQL authenication in the DSN setup. For systems
>>with DSNs using SQL authenication I need to prompt for username and
>> password. For systems using DSNs with Windows Authenication I want t o
>> simply connect with no login prompts.
>>
>>
>> How can I do this?
>
> i see 2 options, depending on your needs:
>
> - either you have an ADOConnection and you play with setting LoginPrompt
> and ConnectionString in run-time
>
> - or you have 2 ADOConnections, each one with different LoginPrompt and
> ConnectionString
>
> the 2nd option has the advantage that you don't get any overflow because
> of changes or 2 clients from different kind connecting at the same moment,
> but i'm not sure if 2 ADOConnections trying to connect to the same RDBMS
> coming from the same app could cause thread-safety problems. It depends on
> the structure of your app, on if they connect using the same port, etc.
> Keep in mind that ADO is generally not thread-safe.
> --
> Best regards :)
>
> Guillem Vicens
> Dep. Informática Green Service S.A.
> www.clubgreenoasis.com
> --
> in order to contact me remove the -nospam
>


.

Relevant Pages

  • Re: TADOConnection using mixed Authenication
    ... >I was looking at doing something along the lines of your first solution. ... >that DSN so I know if it is using Windows or SQL authenication? ... Prev by Date: ...
    (borland.public.delphi.database.ado)
  • Re: Configuration - DSN
    ... in der der gewünschte ConnectionString steht: ... >> mit diesem DSN will ich eine SQLConnection erstellen mit new ... Prev by Date: ... Next by Date: ...
    (microsoft.public.de.german.entwickler.dotnet.csharp)
  • Re: TADOConnection using mixed Authenication
    ... >Authenication some use SQL authenication in the DSN setup. ... ConnectionString in run-time ... i'm not sure if 2 ADOConnections trying to connect to the same RDBMS coming ...
    (borland.public.delphi.database.ado)
  • Re: Oracle Tabelle in Access MDB verknüpfen
    ... je nach aigerichtetem DSN musst du den String aufbauen. ... erzeugten ConnectionString für die spätere Verwendung auslesen. ... Erstelle die Verbindung mit der Access-Oberfläche und lies den erzeugten ...
    (microsoft.public.de.vb.datenbank)
  • Re: Manuel for ODBC
    ... >> If security is an issue, ... > be a reason to use a DSN. ... > Instead of setting up the connectionstring, ...
    (microsoft.public.fox.programmer.exchange)