Advertisement

05.17.2006 at 03:06PM PDT, ID: 21854558
[x]
Attachment Details

ODBC Count Field Incorrect

Asked by hustedj in Microsoft Visual Interdev

Tags: field, incorrect, count

I moved my webserver from one server to another. My operating system on my old server was Windows NT. My new server has windows 2000 server. I have visual interdev 6.0. My problem is when I try to run an application, I get an error.

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

--------------------------------------------------------------------------------

Technical Information (for support personnel)

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error
/contactinfoapp/_ScriptLibrary/Recordset.ASP, line 636

I have installed the Front Page extension, I have updated to the latest MDAC.

I'm using a statement select * from table where field = ? and I am using a recordset to pass a paramenter into the question mark. If I hard code it select * from table where field = 'yellow' then the application works just fine. I have a feeling it has something to do with my data connection, but I just can't seem to figure it out.

Thanks in advance.
Start Free Trial
[+][-]05.17.2006 at 03:09PM PDT, ID: 16704237

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.17.2006 at 05:11PM PDT, ID: 16705032

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.18.2006 at 11:43PM PDT, ID: 16715555

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.19.2006 at 04:57AM PDT, ID: 16717135

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.19.2006 at 05:09AM PDT, ID: 16717205

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.22.2006 at 09:15AM PDT, ID: 16735485

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.22.2006 at 09:17AM PDT, ID: 16735513

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.22.2006 at 09:18AM PDT, ID: 16735521

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.22.2006 at 09:36AM PDT, ID: 16735723

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.22.2006 at 11:11AM PDT, ID: 16736522

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.22.2006 at 11:32AM PDT, ID: 16736710

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.22.2006 at 02:02PM PDT, ID: 16737857

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.22.2006 at 02:26PM PDT, ID: 16738030

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Microsoft Visual Interdev
Tags: field, incorrect, count
Sign Up Now!
Solution Provided By: bigbillydotcom
Participating Experts: 3
Solution Grade: B
 
 
[+][-]05.22.2006 at 05:55PM PDT, ID: 16739046

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32