Running in Access the type mismatches are "self handled" by Access
Running in ASP you need to be explicit on declaring variable types (dates vs #'s vs txt)
Test your variable types using
response.write TypeName(yourvariablename) & "<br>" 'Debug testing only
| Thanks for the input Stefan. I'm sorry I wasn't clear about my server. The
| error is occuring on my localhost, so maybe permissions are the issue. I'm
| using a query that was developed within Access, and I'm reasonably certain
| their are no data type missmatches since the query runs just fine in Access.
| Any suggestions on how to insure that my permissions are correct? Or any
| other suggestions? Thanks
| --
| Tom
|
|
| "Stefan B Rusynko" wrote:
|
| > The issue w/ temp/tmp is the same on all version of Windows (XP Pro and 2003)
| > - but since you are getting it on a hosted server (not your localhost) it may be a
permissions problem by your host
| >
| > But often a Type mismatch indicates your data in the query does not match the field type you
are using
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| >
http://www.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| > | Thanks Mark.
| > |
| > | I read the URL you referenced, and while my inititial error message indeed
| > | matches the subject article, both recommended solutions dealt with either WIN
| > | 2000 or NT neither of which I'm using. However, if the root of my problem
| > | is, in fact, due to temp file access depending on whether I'm authoring or
| > | browsing, then I'm thinking that this must be a very common issue that would
| > | be encountered by virtually anyone who is using IIS on their local machine to
| > | test their FP ASP pages prior to "going live". So, I'm still stuck. Any
| > | suggestions?
| > | --
| > | Tom
| > |
| > |
| > | "Mark Fitzpatrick" wrote:
| > |
| > | > See if the following KB article helps:
| > | >
http://support.microsoft.com/default.aspx?scid=kb;en-us;243331
| > | >
| > | > It may solve both problems actually but it's a good place to start as errant
| > | > issues with a conenction string can lead to very odd ADO and ASP behavior.
| > | >
| > | > Hope this helps,
| > | > Mark Fitzpatrick
| > | > Microsoft MVP - FrontPage
| > | >
| > | > | > | > > After publishing my .asp page that utilizes a simple 2 field query with 10
| > | > > records that works fine in Access, the results when calling the page in
| > | > > the
| > | > > browser (using IIS and XP Pro), the first field in the search results
| > | > > table
| > | > > returns:
| > | > >
| > | > > "Microsoft VBScript runtime error '800a000d'
| > | > >
| > | > > Type mismatch: 'FP_FieldVal'
| > | > >
| > | > > /cemetery/test.asp, line 123"
| > | > >
| > | > > Returning to FP to explore, when highlighting the field name within the
| > | > > database results table, I get the following database connection error:
| > | > >
| > | > > "Server error: Unable to retrieve the list of record sources from a
| > | > > database
| > | > > using the connection string:
| > | > > DRIVER={Microsoft Access Driver
| > | > > (*.mdb)};DBQ=URL=fpdb/CemeteryRegistry.mdb.
| > | > > The following error message comes from the database driver software; it
| > | > > may
| > | > > appear in a different language depending on how the driver is configured.
| > | > > Source: ADO
| > | > > Number: -2146824584 (0x800a0e78)"
| > | > >
| > | > > Can anybody give me a clue what this is about and how to fix it? Thanks.
| > | > > --
| > | > > Tom
| > | >
| > | >
| > | >
| >
| >
| >