Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2002
    Posts
    4

    Question Unanswered: Authentication failed error

    Receiving authentication failed error on a SQL driven website.
    Basic directory structure

    admin
    |
    |
    |--> inc
    |
    |
    |-->setdefaults.inc

    inc
    |
    |
    |-->setdefaults.inc and database.mdb

    The setdefaults.inc in the admin/inc folder is pointing to the database.mdb in the main inc folder. When I try to access the admin side of the website, I'm getting an authentication failed error. The public side of the website functions properly (displays all files added to the database before the error starting occuring and the search function works properly).

    Our ISP migrated their servers about a month ago. Have been unable to confirm with them if the IP or path to the SQL database changed. I don't think it has because the main site still functions properly and it's the same database.

    Does anyone have any suggestions on how I can troubleshoot this problem further???

    Thanks for your help!


    Deborah

  2. #2
    Join Date
    Apr 2002
    Location
    England
    Posts
    21

    Re: Authentication failed error

    Are you using the same user accounts to log onto the database for both the admin and customer parts of the site?

  3. #3
    Join Date
    Sep 2002
    Posts
    4

    Re: Authentication failed error

    Yes - exactly the same info. The ISP finally got back to me (two months later) and gave me a host name, IP address, database name, UID and PW. The original coding done by my web designer has the fields Server Name, database name, UID and PW.

    Do I just replace the Server name with the IP address and do I need to put the host name anywhere. If so, where?

    Deborah

  4. #4
    Join Date
    Apr 2002
    Location
    England
    Posts
    21

    Re: Authentication failed error

    You should be able to replace the Server with the IP address without any problem. Do you know what type of access your account has for the database? The user account may be limited to read only access (or somthing similar) and as a result will not allow the more advanced sections of the admin (update, insert etc).

    Originally posted by vascorp
    Yes - exactly the same info. The ISP finally got back to me (two months later) and gave me a host name, IP address, database name, UID and PW. The original coding done by my web designer has the fields Server Name, database name, UID and PW.

    Do I just replace the Server name with the IP address and do I need to put the host name anywhere. If so, where?

    Deborah

  5. #5
    Join Date
    Sep 2002
    Posts
    4

    Re: Authentication failed error

    I went line by line through my developers code, it looks like the authentication info on the public side is REMmed out so that solves the mystery as to why it appeared to be authenticating properly on one side and not on the other.

    I tried replacing the server name with the IP address. It doesn't work. I just found out that the ISP provider now uses MySQL. Is that entirely different from MS SQL Server?

    Thanks


    Deborah

  6. #6
    Join Date
    Apr 2002
    Location
    England
    Posts
    21

    Re: Authentication failed error

    It is a different, and as a result I imagine you will need a different connection string.

    You will need somthing like

    oConn.Open "Driver={mySQL};" & _
    "Server=ipAddress;" & _
    "Port=3306;" & _
    "Option=131072;" & _
    "Stmt=;" & _
    "Database=mydb;" & _
    "Uid=myUsername;" & _
    "Pwd=myPassword"

Posting Permissions

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