#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    17
    Rep Power
    0

    ODBC Data Connection


    When O use ODBC Data Connection to connect to Access Database the data adapter can't generate the Update and Delete command and the error message says that the primary key column can't be determined. When I use OleDbDataAdapter it just work fine for the same database... Any one know why???
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Location
    Sheffield, UK
    Posts
    94
    Rep Power
    12
    They want you to use ADO on a SQL server database, and as such make everything else insanely hard...
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    17
    Rep Power
    0
    It seems that this is the only logical reason, but I don't connect to SQL I connec to Access database
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Location
    Montreal, Canada
    Posts
    486
    Rep Power
    12
    Originally posted by rasmy
    It seems that this is the only logical reason, but I don't connect to SQL I connec to Access database
    samething ! I believe DAO doesn't exist anymore or kinda hard to use with .Net ! they changed all the way things were working with .net . I believe they want us to use Microsoft uniformity.
  8. #5
  9. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Location
    Sheffield, UK
    Posts
    94
    Rep Power
    12
    Even if they did want us to go completely MS, its still not that versatile

    Gaw, the only thing i've found useful for my version of visual studio, is that its great for writing CSS's

IMN logo majestic logo threadwatch logo seochat tools logo