Professional Web Applications Themes

Getting unusual error - I think. - ASP Database

Running W2K, Access 2000 with all updates prior to SP4. Running into two errors. Attempting to recreate a Microsoft ASP "Guestbook" example. (About 3/5ths of the way down this page: [url]http://msdn.microsoft.com/library/en-us/dnasp/html/asptutorial.asp?frame=tru[/url] e) Set up the DB and ODBC. Editted the ASP pages to my specific directory tree. The errors, defined below, seem out of place. The coding presented on Microsoft's site seems to define strTB1 as a function and StrSrt as a string variable of TB1. Guestbook.asp Error: Error Type: Microsoft VBScript runtime (0x800A01F4) Variable is undefined: 'strTB1' /dpg/guestbook.asp, line 16 guestbookedit.asp Error: Error Type: Microsoft VBScript runtime (0x800A01F4) Variable ...

  1. #1

    Default Getting unusual error - I think.

    Running W2K, Access 2000 with all updates prior to SP4. Running into two
    errors.
    Attempting to recreate a Microsoft ASP "Guestbook" example. (About 3/5ths of
    the way down this page:
    [url]http://msdn.microsoft.com/library/en-us/dnasp/html/asptutorial.asp?frame=tru[/url]
    e) Set up the DB and ODBC. Editted the ASP pages to my specific directory
    tree. The errors, defined below, seem out of place. The coding presented on
    Microsoft's site seems to define strTB1 as a function and StrSrt as a string
    variable of TB1.


    Guestbook.asp Error:

    Error Type:
    Microsoft VBScript runtime (0x800A01F4)
    Variable is undefined: 'strTB1'
    /dpg/guestbook.asp, line 16


    guestbookedit.asp Error:

    Error Type:
    Microsoft VBScript runtime (0x800A01F4)
    Variable is undefined: 'StrSort'
    /dpg/guestbookedit.asp, line 19





    Dave Guest

  2. #2

    Default Re: Getting unusual error - I think.

    Comment out the "option explicit" line, temporarily...



    "Dave" <dgrissetsewanee.edu> wrote in message
    news:#CO9fULRDHA.2320TK2MSFTNGP12.phx.gbl...
    > Running W2K, Access 2000 with all updates prior to SP4. Running into two
    > errors.
    > Attempting to recreate a Microsoft ASP "Guestbook" example. (About 3/5ths
    of
    > the way down this page:
    >
    [url]http://msdn.microsoft.com/library/en-us/dnasp/html/asptutorial.asp?frame=tru[/url]
    > e) Set up the DB and ODBC. Editted the ASP pages to my specific directory
    > tree. The errors, defined below, seem out of place. The coding presented
    on
    > Microsoft's site seems to define strTB1 as a function and StrSrt as a
    string
    > variable of TB1.
    >
    >
    > Guestbook.asp Error:
    >
    > Error Type:
    > Microsoft VBScript runtime (0x800A01F4)
    > Variable is undefined: 'strTB1'
    > /dpg/guestbook.asp, line 16
    >
    >
    > guestbookedit.asp Error:
    >
    > Error Type:
    > Microsoft VBScript runtime (0x800A01F4)
    > Variable is undefined: 'StrSort'
    > /dpg/guestbookedit.asp, line 19
    >
    >
    >
    >
    >

    Aaron Bertrand - MVP Guest

  3. #3

    Default Re: Getting unusual error - I think.

    Aaron,
    Thanks for your reply. I created two new copies of both files.
    Guestbook.asp and guestbookedit.asp (Both have Option Explicit removed).
    I looked at [url]www.aspfaq.com[/url] article 2009, system is up to date on all
    suggested Microsoft upgrades. Permissions have been given to the folder
    and file. I'm not familiar with "IUSR_machineName". Would you go into
    more depth?
    Also, switching from ODBC to OLE-DB, do you know of an informative
    website discussing implementation?


    Guestbook.asp is replying with error:

    Error Type:
    Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    [Microsoft][ODBC Microsoft Access Driver]General error Unable to open
    registry key 'Temporary (volatile) Jet DSN for process 0x358 Thread
    0x9e8 DBC 0x2ea30e4 Jet'.
    /dpg/guestbook.asp, line 25

    Guestbookedit2.asp is responding with:

    Error Type:
    Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    [Microsoft][ODBC Microsoft Access Driver]General error Unable to open
    registry key 'Temporary (volatile) Jet DSN for process 0x358 Thread
    0x9e8 DBC 0x2ea4a6c Jet'.
    /dpg/guestbookedit.asp, line 34


    *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
    Don't just participate in USENET...get rewarded for it!
    david grissett Guest

  4. #4

    Default Re: Getting unusual error - I think.

    > Also, switching from ODBC to OLE-DB, do you know of an informative
    > website discussing implementation?
    There is no "implementation" you just use a different connection string (see
    [url]www.aspfaq.com/2126[/url]).
    > Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    > [Microsoft][ODBC Microsoft Access Driver]General error Unable to open
    > registry key 'Temporary (volatile) Jet DSN for process 0x358 Thread
    > 0x9e8 DBC 0x2ea30e4 Jet'.
    > /dpg/guestbook.asp, line 25
    This is a permissions issue.
    [url]http://www.aspfaq.com/2154[/url]


    Aaron Bertrand - MVP Guest

  5. #5

    Default Re: Getting unusual error - I think.

    Thanks again.
    I read somewhere that an OLE-DB connection could be created by doing the
    following.

    Create blank .txt file
    Rename it to .udl
    Right click and open properties
    Configure necessary settings

    I've never configured any settings but the process seems easy. I assume
    the .udl file would be stored in the wwwroot folder.


    *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
    Don't just participate in USENET...get rewarded for it!
    david grissett Guest

  6. #6

    Default Re: Getting unusual error - I think.

    Why would you want to go through all that extra work? Isn't it much easier
    to just edit the path (about the only thing that would ever change) in an
    #include file???



    "david grissett" <anonymousdevdex.com> wrote in message
    news:egnyzeMRDHA.2036TK2MSFTNGP12.phx.gbl...
    > Thanks again.
    > I read somewhere that an OLE-DB connection could be created by doing the
    > following.
    >
    > Create blank .txt file
    > Rename it to .udl
    > Right click and open properties
    > Configure necessary settings
    >
    > I've never configured any settings but the process seems easy. I assume
    > the .udl file would be stored in the wwwroot folder.
    >
    >
    > *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
    > Don't just participate in USENET...get rewarded for it!

    Aaron Bertrand - MVP Guest

  7. #7

    Default Re: Getting unusual error - I think.


    Didn't realize it was that easy. I like, I like!

    *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
    Don't just participate in USENET...get rewarded for it!
    david grissett Guest

Similar Threads

  1. unusual cfquery problem
    By feral99 in forum Coldfusion - Advanced Techniques
    Replies: 0
    Last Post: May 9th, 12:13 AM
  2. Unusual Application Error when saving
    By cassie_white@adobeforums.com in forum Adobe Illustrator Windows
    Replies: 1
    Last Post: June 1st, 04:15 PM
  3. Unusual sort in datagrid
    By Jim Nugent in forum ASP.NET Data Grid Control
    Replies: 1
    Last Post: September 24th, 12:29 PM
  4. [HELP] Unusual script timeout error
    By Hendry J in forum PHP Development
    Replies: 0
    Last Post: August 12th, 07:33 AM
  5. unusual behaviour of program under linux....
    By Artie Gold in forum UNIX Programming
    Replies: 7
    Last Post: June 26th, 04:56 PM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139