Re: Request User ID and password every time



On 4 Jun, 14:59, "Bob Barrows [MVP]" <reb01...@xxxxxxxxxxxxxxx> wrote:
mo_in_france wrote:
Hello All,

I'm using the following connection string in a VB application. You can
see that I'm trying to connect to an I-series database using an ODBC
connection.

I wish to amend this connection string, so that the user is obliged
everytime to enter their login and password to connect to the
database. This must be done regardless of what has been speciifed as
default login on I-series Navigator.

"Provider=MSDASQL;Persist Security Info=FALSE;Extended
Properties=""DRIVER=Client Access ODBC Driver (32-

bit);SYSTEM=mysystem;DBQ=xxx;DFTPKGLIB=yyy;XLATEDLL=;LANGUAGEID=ENU;TRAN
SLATE=1;PWD=;UID=;"";Initial

Catalog=zzz"

I've tried a few things and I'm not geetting the effect I'm after.

Any suggestions would be appreciated.

Why not prompt them yourself and supply the user id and password in the
connection string?

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

It would seem that you are reading my mind.... I had this suggestion
down as plan B. The reason why it's plan B (and not Plan A) is because
I have in my mind that my original needs can be met with simply
changing the connection string (this remains to be seen for the
moment), and to change the connection string requires no additional
program modifcations whatsoever. Although I do appreciate at the same
time, that requesting the ID and Password myself would require very
little additonal programming effort.

Reagrds

.



Relevant Pages

  • Re: Industry Standard Security and guest wifi access best practice
    ... usage policy and a login screen. ... Connection is simple for the end user and requires no VPN client ... Wireless subnet roaming would be really nice as well. ... implementing 802.1X as the complexity in supporting tennants would ...
    (alt.internet.wireless)
  • Re: Industry Standard Security and guest wifi access best practice
    ... usage policy and a login screen. ... Connection is simple for the end user and requires no VPN client ... Wireless subnet roaming would be really nice as well. ... implementing 802.1X as the complexity in supporting tennants would ...
    (alt.internet.wireless)
  • Industry Standard Security and guest wifi access best practice
    ... usage policy and a login screen. ... Connection is simple for the end user and requires no VPN client ... login pages (Authentication and then VPN) which would be necessary it I ... implementing 802.1X as the complexity in supporting tennants would ...
    (alt.internet.wireless)
  • RE: Getting Challenged when using SQL connection on .aspx page
    ... What would happen if i removed integrated security=sspi from the connection ... Just want the login token to be passed, ... Have webpage with following connection in the ... I have account to the database on the SQL server. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Permit only one network logon per user
    ... intend to prevent a second local login. ... allow a second connection to it using the same creds. ... network logon per user. ...
    (microsoft.public.windows.server.security)