Hi all,
I've just got back from a baffling client visit. The problem they were
having was the Exception runtime error as commonly seen when the server
requires the latest MDAC installed.
The client decided to carry out a complete server reinstall (inlcuding
reformat and reinstall NT4.0) for reasons unknown.
The site (intranet) was working 100% perfectly before carrying out the
reinstall. It was running on NT4.0, SP6a, IIS4.0, CF4.5Ent, MDAC 2.5 using
Access datasources. Also residing on the same machine was Lotus Domino and
SQL 7.0 and several other services, which I think may have had something to
do with their decision to reformat etc.
They reinstalled everything to exactly same configuration as above and are
now receiving the Exception Runtime error. I've checked through the
following:
Latest MDAC installed - yes
Query in question runs fine in Access - yes
Templates in question run fine on another server - yes
Is Service Pack 6a causing problem? - Can't be as this was present in
previous install
Are correct url variables being passed to the template - yes
Can anyone else suggest any other things i should have looked into as I'm
totally stumped by this one. The client needs this running asap as the query
"aparently" causing the error drives the entire intranet's navigation menu
system. I didn't build this site so intimate knowledge of the code base is
not available either, however, the query in question is shown below:
SELECT (main_area.main_area_name + ' \ ' + sub_area.sub_area_name) as
Location
FROM main_area INNER JOIN sub_area ON main_area.main_area_id =
sub_area.main_area_id
WHERE (((sub_area.sub_area_id)=#url.id#))
Any help appreciated,
Dave
Dave Wilson
Internet Technology Manager,
BizNet Solutions
<Allaire Premier Partner>
Co-Founder CFUG Ireland
http://www.cfug.ie
224, Lisburn Road
Belfast BT9 6GE
Tel: 02890 225 776
Fax: 02890 223 223
web: http://www.biznet-solutions.com
email: [EMAIL PROTECTED]
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
