Results 1 to 3 of 3

Thread: E_fail

  1. Dec 10th, 2001, 05:55 AM #1
    stm
    stm is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Mar 2001
    Posts
    416

    E_fail

    Hi,

    When I using ADO to access a SQL Server table, I got this error:
    "Data provider or other service returned an E_FAIL status"

    From MS, it points out that when using MS Access ODBC driver, LEFT JOIN and table with boolean column will cause this error.

    In my case, I'm accessing SQL Server, also using LEFT JOIN and with boolean field, but only when reach the record with NULL value on some fields (not sure include the boolean field or not). Any idea how to fix it??

    Thx a lot!!!
    Reply With Quote Reply With Quote
  2. Dec 10th, 2001, 10:29 AM #2
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333
    Post the code. Sometimes, when viewing code, a answer jumps out.
    Reply With Quote Reply With Quote
  3. Dec 10th, 2001, 09:24 PM #3
    Beacon
    Beacon is offline
    PowerPoster Beacon's Avatar
    Join Date
    Jan 2001
    Location
    Pub Floor
    Posts
    3,188
    Try getting mdac 2.7 from ms website solved a lot of e_fail errors!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width