Results 1 to 5 of 5

Thread: Database error

  1. #1
    Join Date
    Mar 2004
    Posts
    8

    Unanswered: Database error

    I am using vb.net and a ms sql database. I can create datasets for every table in my database except for 1 table. Vb.net says that i have an error in my database. What can i do? is there a site that lists common database errors? Its driving me crazy, it just tells me my database has an error. It doesnt specify it. Any suggestions?


    thanks

  2. #2
    Join Date
    May 2004
    Posts
    5
    Take the SQL from the connection and run it in Query Analyzer. Does it produce any errors there?

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    How about showing us what the code is?

    The list is long

    http://support.microsoft.com/default...b;EN-US;306908
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Mar 2004
    Posts
    8

    query analyzer

    I ran it though the query analyzer and it produced no errors. So the error must be in VB.net? All i am doing is using the data adapter wizard to create the connection and adapters. then i use the wizard to generate the dataset.
    any suggestions? i have 12 other tables that work fine. but its just this one table that never works.

  5. #5
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    Quote Originally Posted by djsuperz
    I ran it though the query analyzer and it produced no errors. So the error must be in VB.net? All i am doing is using the data adapter wizard to create the connection and adapters. then i use the wizard to generate the dataset.
    any suggestions? i have 12 other tables that work fine. but its just this one table that never works.
    Create copy of your problem table and try to open it (removing columns by one) - I bet you'll finally find what is wrong....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •