SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Enthusiast
    Join Date
    Apr 2005
    Posts
    45
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    problem with updation using odbc connection

    hi guys.

    I am using access database. i can insert data using odbc connection.

    my code is as follows:
    $con=odbc_connect('rvg','','');
    $sql="insert into....."; // this works fine........
    odbc_exec($con,$sql) or die("error");

    // after insertion i am updating the table t_id with new id

    $sql="update t_id set id=2001";
    odbc_exec($con,$sql) or die("error");
    // this updation shows no error but the data is not updated in the database.


    all updations i use in the site is not working. any idea about this problem.

    needed help

    anish
    tvm

  2. #2
    SitePoint Member
    Join Date
    Nov 2006
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    be sure that you have user rights to update the databse in question

  3. #3
    SitePoint Enthusiast
    Join Date
    Apr 2005
    Posts
    45
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    i can insert into database but updation is not working

    also note thatw when i updated using direct code (with directly inserting strings ) to database its not working. when i use variables its not working

    i also displayed the sql query using print(). the syntax is correct.



    bye
    anish
    tvm

    Quote Originally Posted by adroite
    be sure that you have user rights to update the databse in question


Bookmarks

Posting Permissions

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