Dispplay SQL Data in ASP 1

[beaniebear]

I have developed a web site using ASP and a SQL server 7 back end. The site is being set up by another person in America. The ASP pages are not pulling any data back from the database, but are also not causing errors. Therefore the connections must be being made but the recordsets are coing back empty. Are there any settings that need to be set in IIS (4), or maybe service packs that need instaling? I was wondering if this has something to do with MDAC?

 

[chiph]

but are also not causing errors.

Make sure that "On Error Resume Next" has not been coded into the ASP pages. If it is, you will never see an error raised.

Have you verified that the SQL works when pasted into Query Analyzer?

Also, make sure that everyone on your team is running the same level of software. MDAC, SQL Server client software (plus service-packs), the works.

Chip H.

 

[beaniebear]

"On error resume next" has not been coded in the ASP pages.

I have checked the SQL in the query analyser. The problem is that I'm in the UK and trying to instruct someone to set up the site in the US.

As the site wasn't working I sent the simplest script that just selects the contents of a table and writes it to the screen. I took out the error handling for an empty recordset, but no data is displayed to the screen (there is data in the table) and no error message is produced.

How do I find out what version of MDAC running?

 

[mkuan]

To find out what the version of MDAC you have, go to MS's site and search for this article - "HOW TO: Check for MDAC Version", you will the tool and all the instructions you need.