Solved

IIS Application/SQL

Posted on 2002-03-27
3
168 Views
Last Modified: 2008-03-17
Hi
The webclass I developed in VB6 has worked fine both in compiled and running in IDE.  However the same version once deployed worked fine apart from one function which provides a keyword/freetext db search and the error is    -2147217887 Invalid character value for cast specification
Any ideas?
Using ADO 2.0 and the data environment
Thanks
Brandon
0
Comment
Question by:Brandon1032399
3 Comments
 
LVL 4

Accepted Solution

by:
RichW earned 200 total points
ID: 6902398
This is an obscure error message.  Look here http://support.microsoft.com/default.aspx?scid=kb;en-us;Q168354 for help on debugging this error.

I would suggest you download the latest MDAC file, I believe it's 2.7, but I could be behind.

Sorry I couldn't be of more help.  I never encountered this error.

Good luck!
RichW




0
 
LVL 49

Expert Comment

by:DanRollins
ID: 7637904
Hi Brandon1,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

    Accept RichW's comment(s) as an answer.

Brandon1, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you.  DO NOT accept this comment as an answer.
==========
DanRollins -- EE database cleanup volunteer
0
 

Expert Comment

by:SpideyMod
ID: 7754810
per recommendation

SpideyMod
Community Support Moderator @Experts Exchange
0

Featured Post

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SSRS expression Issue finding a string 10 91
Error when passing an argument to a vb6 that contains  '/' 7 40
MsgBox 4 68
RUNRMTCMD from AS/400 12 69
Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question