Getting unusual error - I think.

[Dave]

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]

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



"Dave" <dgrisset@sewanee.edu> wrote in message
news:#CO9fULRDHA.2320@TK2MSFTNGP12.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
>
>
>
>
>

[david grissett]

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!

[Aaron Bertrand - MVP]

> 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]

[david grissett]

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]

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" <anonymous@devdex.com> wrote in message
news:egnyzeMRDHA.2036@TK2MSFTNGP12.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!

[david grissett]

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!