SQL Connection string

Results 1 to 3 of 3

Thread: SQL Connection string

  1. #1
    Join Date
    Dec 1969

    Default SQL Connection string

    I have encountered a strange problem, my connection string for sql server is as follow: <BR><BR>Driver={SQL Server};Server=abc;uid=user;pwd=upwd;database=abc <BR><BR>if everything in the connection string is correct, then this string works fine, but if I blank out the user id in the connection string, I still can access to the database.... That means I can access the database as long as the user id is blank..

  2. #2
    Join Date
    Dec 1969

    Default Good for you.

    Is there a question there somewhere?

  3. #3
    Join Date
    Dec 1969

    Default RE: SQL Connection string

    better to do validation for user id in connection string( its just prevention only). say when the user-id is blank or the user name is wrong one(compare the username with existing users by select---- whre clause. )<BR>if record set is null<BR>response.write " user does not exists"<BR>exit sub<BR>else<BR> YOUR remaining code<BR>end if<BR>this is just a prevention ...not cure

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts