Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2005

    Question HELP! Exception Error 800a01fb

    Ia m installing MySQL on my windows 2003 server. But when trying to run a short vbscript I get error 800a01fb on Conn.Execute. The database seems to work fine from MySQL administrator and ODBC test is successful.

    Please help me with this one!

    I have installed
    * MySQL 5.0
    * MySQL ODBC v5.0
    * MySQL Administrator
    * MySQL Query Browser
    * MDAC 2.8
    * IIS 6.0


    Set Conn = createobject("ADOBD.Connection")
    Conn.Open="Driver={MySQL Connector/ODBC v5.0};Server=Localhost;Database=MyDb;User=root;Pas sword=MyPw;Option=3;"
    MySQL="SELECT * FROM Tablename"
    set rs=Conn.Execute(MySQL)

    set Conn=Nothing
    Last edited by Surre; 12-09-05 at 14:17.

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    My first guess would be that you'd get a lot better response if you posted this in the MySQL forum than you will here.

    The HRESULT of 800a01fb is certainly interesting, and it might help someone to help you, but I'd do a whole lot better with the error message, and even better if you included a short script to reproduce the error.


  3. #3
    Join Date
    Dec 2005
    Sorry if I posted wrong, I am new here not familiar with this large forum and all catagories.

    Well, my guess is that the error is not directly related to MySQL since I have seen other people who got the same error using Access. Maybe there are different solutions depending on which database you use. Or maybe it is something with IIS or MDAC. I hope someone else knows.

    What about a script? I posted the code, very short code. Maybe I missunderstood you.

    Errormessage (translated by me now from swedish)
    "Runtime error in Microsoft VBScript Error 800a01fb. An exception appeared 'Execute'"

    Thanks for any help! Seems to be a great forum this.
    Last edited by Surre; 12-09-05 at 10:21.

  4. #4
    Join Date
    Dec 2005
    I have posted this issue in MySQL-forum as suggested. So please answer in that thread for clearity.


Posting Permissions

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