1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Connecting to mysql database via ASP

Discussion in 'Plesk for Windows - 8.x and Older' started by EnenDaveyBoy, Jan 28, 2005.

  1. EnenDaveyBoy

    EnenDaveyBoy Guest

    0
     
    Hello

    I have created a mysql database on my plesk control panle and created a user with name and password.

    But for what ever reaosn my dnsless connection does not work.

    I have used both drivers MySQL ODBC 3.51 Driver and mySQL, but neither worked

    my connection string is:

    Conn = "Driver={MySQL ODBC 3.51 Driver}; Server=localhost; Database=visits; UID=callum; PWD=russell;"

    Which I have used many times without the plesk control panel, but for some reason its not working, I noticed that on my hosted companies help files it mention setting permissions but i keep getting this error message:

    Microsoft OLE DB Provider for ODBC Drivers error '80004005'

    [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

    /Index.asp, line 8

    Any help or advice would be appriciated

    Cheers
    Dave
     
  2. jvinson

    jvinson Guest

    0
     
    I am having the exact same problem and have not been able to figure it out.

    If you find a resolution please post it here.
     
  3. EnenDaveyBoy

    EnenDaveyBoy Guest

    0
     
    It seems to be a common problem I have found many posts for it, but no answers, i though PLESK would have this sorted via means of a patch or something by now, the amount of old posts on here, or at least has it mention in the FAQ.
     
  4. rick_snow

    rick_snow Guest

    0
     
    Not sure if this helps or not, but you are calling on MySQL ODBC 3.51 which does not seem to be installed on my server hosting Plesk. I can only imagine that the driver is not installed on the Plesk installation and might need to be installed first before you call on it. Unless you have done that already.


    You can download it from here :
    http://www.mysql.com/products/connector/odbc/
     
  5. jvinson

    jvinson Guest

    0
     
    Already installed the 3.51 ODBC Driver. I can connect with it through Administrative Tools/Data Sources and it connects just fine.

    Still get the same error through ASP
     
  6. jvinson

    jvinson Guest

    0
     
    Solution Found

    I have discovered that if you use the 3.51.8 ODBC Driver everything works .

    You can download it HERE
     
  7. EnenDaveyBoy

    EnenDaveyBoy Guest

    0
     
    Thanks for the help everyone.

    We final get some luck my host accepts its the driver and now someone elses comes along and says its my code(from the host ompany that is) and i need to set a ODBC which well have already told him in the same help desk ticket its using DSNless connection, grrrrrrrrrrrrrrrrrrrrrrr. and the control panle doesn't have a selection of mysql.

    If i was only there to do it myself I have been told i can add drivers via the control panle anyone know how?

    Cheers
     
  8. jvinson

    jvinson Guest

    0
     
    Drivers

    I don't believe you can do that. I have a dedicated server that I had no problem installing it on.
     
  9. EnenDaveyBoy

    EnenDaveyBoy Guest

    0
     
    Cheers for that- I didn't think so either, my hosting is suplied by a company on shared hosting, but i dont see the problem, its easy to instal would take 5 mins, and bebfit everyone on ther server, they just being a apin at the mo, if they dont hurry up, i'm asking for my money back grrrrrrrrrrrr

    glad you got it sorted, i shall have to wait and see.
     
  10. EnenDaveyBoy

    EnenDaveyBoy Guest

    0
     
    Woohooo, they do speak engliah lol after getting somoeone esle to speck to i got them to install your drive and yep it worked, for ppl in the future you do have to use:

    Driver={MySQL ODBC 3.51 Driver}; Server=localhost; Database=visits; UID=callum; PWD=russell;


    and not the simple driver={mySQL}

    And install the driver in jvinson's post.

    Thanks for the help good luck
     
  11. AbsolutelyFreeW

    AbsolutelyFreeW Guest

    0
     
    which one is it that is not working?

    does 3.51.11 work?
     
  12. jvinson

    jvinson Guest

    0
     
    Anything newer than 3.51.8 does not work.

    It has something to do with the way they encrypt the passwords in MySql's ODBC Driver.
     
  13. EnenDaveyBoy

    EnenDaveyBoy Guest

    0
     
    lol

    Anything older than 3.51.8 does not work.
     
  14. AbsolutelyFreeW

    AbsolutelyFreeW Guest

    0
     
    not older and not newer, I see, I checked and 3.51.8 is made for mysql 4.0.20 exactly the one used with plesk. yep, better use that one.

    I installed it to run winmysqladmin though, that didnt seem to help
     
  15. mikebottom

    mikebottom Guest

    0
     
    Thanx this information really helpful
     
Loading...