Error 2147217900 in VB6

Posted on 2009-04-15
Last Modified: 2012-05-06
Hi one of our users is getting an Error -2147217900 while trying to read some data from the database. the application is in vb6 with SQL Server 2005 database.

Please if anyone of you could help me sort out this issue?
Question by:SreenishKrishnan
    LVL 10

    Accepted Solution

    Do you have any code?  On which line it cause this error?  Any error description?

    Is the connection opened?
    What does your SQL query look like?
    Make sure that all the fields you are trying to read exists in the database
    Make sure that when you read values and assign them to variables, that all columns have values to not get "Null's"

    Please, post some code

    Author Closing Comment

    Thanks Sir..!!i got the solution..!! ' :)

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that undeā€¦
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    734 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

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now