Results Page-Tring to connect to a ODBC Database

[Jim Harris]

I have SQL Running on my local machine. I have set up and ODBC link to it
and I have no problems quering the data in excel or access. . I have added
the database to front page and I have created a database results page. I
keep getting various errors. Here is n example:
Technical Information (for support personnel)

a.. Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'FP_FieldVal'
/CD.asp, line 48


I have IIS running locally and have no problems getting to the homepage that
I have created. I usally get a ASP error and tells me that ASP is no running
I look in IIS and tells me that ASP is running. One of the tech notes said
to right click on the directory and make sure that there is mark in the
"Allow scripts or programs to be run" for some reason this is greyed out and
i am not allowed to select this item.

Thanks

 

[Jens Peter Karlsen[FP MVP]]

1. Here you have a type mismatch such as a using a string when the DB
expects an integer (common mistake)

2. This may be because you went through the file system (C:\whatever)
instead of through the server (http://whatever )

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.