Configuration of Login and password in VB6 program

Dear all,

I have a VB6 project which the program needs to access SQL Server 2005
tables.
As below, the userID is QA and the password is qapl.
The user has requested that to prevent us (the designer) to know the
userID and password of the SQL server, they can configure the userID
and password for the program.

I suggest to give them the source codes to let them change themselves
but they dont want this solution.
They requested that they want a solution which they can change the
login and password of the program without touching the source code but
able to prevent the designer (me) to have idea of login and password
used. Please omit the solution which uses textfile to store the login
and password unless the user can hide those details from the
designer.

Any idea? Thanks.


With csvSQL
.Provider = "MSDASQL"
.ConnectionString = "User ID=QA;" & _
"Password=qapl;" & _
"Data Source = RD178;" & _
"Initial Catalog = RD178"
.Open
End With

Albert

.

Relevant Pages

  • Re: Configuration of Login and password in VB6 program
    ... I have a VB6 project which the program needs to access SQL Server 2005 ... the userID is QA and the password is qapl. ... able to prevent the designer to have idea of login and password ... they should probably still have the source code ...
    (microsoft.public.vb.general.discussion)
  • Re: Configuration of Login and password in VB6 program
    ... I have a VB6 project which the program needs to access SQL Server 2005 ... the userID is QA and the password is qapl. ... able to prevent the designer to have idea of login and password ...
    (microsoft.public.vb.general.discussion)
  • Re: Configuration of Login and password in VB6 program
    ... SQL Server 2005 which will grant different access rights based on my ... the userID is QA and the password is qapl. ... The user has requested that to prevent us (the designer) to know the ... able to prevent the designer to have idea of login and password ...
    (microsoft.public.vb.general.discussion)
  • RE: Login Form Help Needed
    ... rather than the switchboard, make sure that other "development" options are ... When your form is invoked you can do your checks for userid / password ... > that requires the user to enter his/her login information and then click ...
    (microsoft.public.access.forms)
  • Re: Stored procedure question
    ... Vyas, MVP (SQL Server) ... > where UserID = @UserID ... > Vyas, MVP ...
    (microsoft.public.sqlserver.programming)