Re: Configuration of Login and password in VB6 program

Hi all. My customer has suggested to me to use Application Role's
setting in SQL Server 2005.

What i understand is that i will need to configure application role in
SQL Server 2005 which will grant different access rights based on my
program's needs. I should be okay with this part.

How about adding this part inside my code? How can i "link" my progam
with the application role i create?

Thanks.

On Sep 7, 12:54 am, Stefan Berglund <sorry.no.kool...@xxxxxx> wrote:
On Tue, 04 Sep 2007 01:13:21 -0000, albertleng <albertl...@xxxxxxxxx>
wrote:
in <1188868401.161722.170...@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>





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

I'm not sure if this is applicable but I use the following connection
string and access to the database is then controlled by SQL Server.

"Provider=sqloledb;Integrated Security=SSPI;Network
Library=DBMSSOCN;Server="

Google Windows authentication.

---
Stefan Berglund- Hide quoted text -

- Show quoted text -


.

Relevant Pages

  • 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. ... 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: Stored procedure question
    ... Vyas, MVP (SQL Server) ... > where UserID = @UserID ... > Vyas, MVP ...
    (microsoft.public.sqlserver.programming)
  • 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: function as criteria for a query
    ... Write the value to a table with a single record in SQL Server. ... > I have created a public variable called "userId" it stores the user id ... > Public Function fnUserId() ... >> MS Access MVP ...
    (microsoft.public.access.queries)
  • 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)