----- Original Message -----
From: "Greg Partin" <GPartin@c...>
To: "professional vb" <pro_vb@p...>
Sent: Wednesday, December 19, 2001 4:26 PM
Subject: [pro_vb] RE: authenticate sql via vb


> Here's a small twist on that.  Is there a way that I can guarantee that
the
> username they supplied is a system administrator username?
>
> Greg
>
> -----Original Message-----
> From: Greg Partin [mailto:GPartin@c...]
> Sent: Wednesday, December 19, 2001 3:19 PM
> To: professional vb
> Subject: [pro_vb] RE: authenticate sql via vb
>
>
> I knew it was easy...I wasn't thinking outside of the box enough!  Thanks
> Kyle.
>
> Greg
>
> -----Original Message-----
> From: Kyle Burns [mailto:kburns@c...]
> Sent: Wednesday, December 19, 2001 1:18 PM
> To: professional vb
> Subject: [pro_vb] RE: authenticate sql via vb
>
>
> One thing that you could do is pass the username and password as part of
the
> connection string.  Trap the error returned if the combination is not
valid.
>
> E.G., The code:
> <%
> strConn = "provider=SQLOLEDB;Data Source=MYSQLSERVER;Initial
> Catalog=MYDATABASE;User Id=" & Request.Form("UID") & ";Password=" &
> Request.Form("PSWD")
> cn.Open strConn
> %>
>
> will fail if incorrect userid and password parameters are passed.
>
>
> =================================
> Kyle M. Burns, MCSD, MCT
> ECommerce Technology Manager
> Centra Credit Union
> kburns@c...
>
>
>
> >> -----Original Message-----
> >> From: Greg Partin [mailto:GPartin@c...]
> >> Sent: Wednesday, December 19, 2001 9:55 AM
> >> To: professional vb
> >> Subject: [pro_vb] authenticate sql via vb
> >>
> >>
> >> Hi folks,
> >>
> >> This is probably an easy 'trick' but I haven't found much on
> >> the web.  Is it
> >> possible for me to have the user enter the SQL 7 Server username and
> >> password into a form and authenticate (make sure the
> >> username and password
> >> are valid).  If the username and password are not found or
> >> incorrect I need
> >> to display a error message saying something like 'Sorry, the
> >> username and
> >> password you entered for SQL Sever is not found or is incorrect'.
> >>
> >> Thank you and much obliged,
> >>
> >> Greg
> >>
> >> ---
> >> Outgoing mail is certified Virus Free.
> >> Checked by AVG anti-virus system (http://www.grisoft.com).
> >> Version: 6.0.309 / Virus Database: 170 - Release Date: 12/17/2001
> >>
> >>
> >> $subst('Email.Unsub').
> >>
>
>
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.309 / Virus Database: 170 - Release Date: 12/17/2001
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.309 / Virus Database: 170 - Release Date: 12/17/2001
>
>
>
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.309 / Virus Database: 170 - Release Date: 12/17/2001
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.309 / Virus Database: 170 - Release Date: 12/17/2001
>
>
>