SitePoint Sponsor

User Tag List

Results 1 to 8 of 8
  1. #1
    SitePoint Zealot
    Join Date
    Jun 2000
    Location
    Tulsa, OK
    Posts
    134
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    When I try to view live data, I get error 800a0401 which it says is a VBscript compilation error.

    It seems that since UltraDev implemented the VBscript itself, it would be good. Or am I understanding it incorrectly?

    I am using Microsoft Personal Web Server with the tutorial that came with UltraDev.

    Thanks!!

  2. #2
    Your Lord and Master, Foamy gold trophy Hierophant's Avatar
    Join Date
    Aug 1999
    Location
    Lancaster, Ca. USA
    Posts
    12,305
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Actually its a generic ASP error. It means you can't connect to the database for some reason. Without seeing the code and getting a few specifics it would be hard to determine why though.

    ------------------
    Wayne Luke - Sitepoint Forums Administrator
    Digital Magician Magazine - MetaQuark Creations (Coming Soon)
    wayne@sitepoint.com

  3. #3
    SitePoint Zealot
    Join Date
    Jun 2000
    Location
    Tulsa, OK
    Posts
    134
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks!

    Hmmmm. That's strange becuse in UltraDev, it loads an inspector that contains all of the tables in the database. You then just select the record you want in a certain spot and insert it.
    In the inspector (in UltraDev), the database is shown with all of the tables and records and such. This tells me that UltrDev itself is connecting to the database just fine.

    So, you are saying then that the error is not with any of the settings inside of UltraDev, but someplace else. Like PWS?

    I am really a newbie when it comes to database calls and ODBC. I know absolutely nothing about it. Any help is greatly appreciated.

    Thanks!

  4. #4
    Your Lord and Master, Foamy gold trophy Hierophant's Avatar
    Join Date
    Aug 1999
    Location
    Lancaster, Ca. USA
    Posts
    12,305
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    PWS is returning the error. The problem is with how it is parsing the page. If you load the page in your browser by going to http://127.0.0.1/pagename.asp you'll probably get a more detailed error.

    ------------------
    Wayne Luke - Sitepoint Forums Administrator
    Digital Magician Magazine - MetaQuark Creations (Coming Soon)
    wayne@sitepoint.com

  5. #5
    SitePoint Addict djh's Avatar
    Join Date
    Apr 2000
    Location
    Long Beach, CA
    Posts
    333
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    A shot in the dark, but have you copied your database to your inetpub/wwwroot/ folder, where your database is supposed to be?

    Ultradev might be able to point to a db file on your machine, but if you're publishing it on PWS, the db also needs to be in your inetpub folder....

    ------------------
    Dave Han - webmaster@goboatingamerica.com
    "If a question can be put at all, then it can also be answered." - Wittgenstein
    Visit goboatingamerica.com

  6. #6
    SitePoint Zealot
    Join Date
    Jun 2000
    Location
    Tulsa, OK
    Posts
    134
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Wayne:Ok, ran it through my browser like you said. Here is the complete error.

    Microsoft VBScript compilation error '800a0401'

    Expected end of statement

    /tutorial/extranet_news.asp, line 13

    var rsReleaseSummaries = Server.CreateObject("ADODB.Recordset");
    ---------------------------------------------------------------^


    I think maybe we're getting somewhere?
    What to do?

    Dave: Yeah, it's in there. I double checked just to make sure though. Thanks!

    Thanks a lot for all of the help!

  7. #7
    Your Lord and Master, Foamy gold trophy Hierophant's Avatar
    Join Date
    Aug 1999
    Location
    Lancaster, Ca. USA
    Posts
    12,305
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Remove the semi-colon. In Visual Basic, statements are delimited by Carriage returns.

    ------------------
    Wayne Luke - Sitepoint Forums Administrator
    Digital Magician Magazine - MetaQuark Creations (Coming Soon)
    wayne@sitepoint.com

  8. #8
    SitePoint Zealot
    Join Date
    Jun 2000
    Location
    Tulsa, OK
    Posts
    134
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks Wayne! It worked, sort of.

    When I looked the code I found that there were two sets of variables defined at the top. (I think I'm saying this right.)

    I was in JavaScript mode and then switched to VBscript mode, apparently it didn't remove the JavaScript, it just inserted the VBscript.

    It works now, thanks!

    ~Daniel


Bookmarks

Posting Permissions

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