Is my password visible when opening a standard user connection from visual basic?

From: Roel Schreurs (schreurs_roel@hotmail.com)
Date: 10/31/02 

From: schreurs_roel@hotmail.com (Roel Schreurs)
Date: 31 Oct 2002 07:32:07 -0800

Hi all,

My Visual Basic application uses ADO to connect to a SQL Server 7. I
am opening a connection for a user that has a standard login (not an
NT user). I have to supply the username an password in the statement:
  
Dim myConnection As Connection

  Set myConnection = New Connection

  myConnection.Open "<connect_string>", "<user_name>", "<password>"

Can this password be seen on the network with some packet sniffer or
anything? If so, is there a way to avoid this?

With the related problem of using an application role, the visibility
of the password can be avoided by modifying the tSQL statement from

  EXEC sp_setapprole '<user_name>', '<password>'

into

  EXEC sp_setapprole '<user_name>', {Encrypt N '<password>'}, 'odbc'

Is there something similar?

Thanks in advance,

Roel Schreurs

Relevant Pages

  • Please help with ASP.NET Database Connection
    ... >DataGridEmail.aspx (Connection String) ... >Dim myConnection as NEW ... >Sub Page_Load ...
    (microsoft.public.dotnet.framework.adonet)
  • ADO recordset returns -1
    ... I have a connection to the Northwind database from ... Dim myConnection As String ... Dim rsData As ADODB.Recordset ... 'Create a connection to Northwind DB ...
    (microsoft.public.excel.programming)
  • Re: ADO.NET and Sleeping processes
    ... What I'm trying to figure out is why my connection is not being release back to the pool. ... "amerrell" a écrit dans le message de ... > Dim myConnection As New SqlConnection) ...
    (microsoft.public.dotnet.framework.adonet)