Professional Web Applications Themes

Access - retriving primary key ... - ASP Database

Hi, I'm trying to get a primary key from a table via openSchema method, but it seems that I can do that on Access DB. I only get a error: "ADODB.Connection (0x800A0CB3) Object or provider is not capable of performing requested operation." Code: ************************** set rs = Server.CreateObject("ADODB.Recordset") set Conn = Server.CreateObject("ADODB.Connection") Conn.Open ConnString Set rs = Conn.OpenSchema(adSchemaPrimaryKeys) for each element in rs.fields Response.Write element & "<br>" next rs.Close: set rs = nothing Conn.Close: set Conn = nothing...

  1. #1

    Default Access - retriving primary key ...

    Hi,

    I'm trying to get a primary key from a table via openSchema method, but it
    seems that I can do that on Access DB.
    I only get a error:
    "ADODB.Connection (0x800A0CB3)
    Object or provider is not capable of performing requested operation."

    Code:
    **************************
    set rs = Server.CreateObject("ADODB.Recordset")
    set Conn = Server.CreateObject("ADODB.Connection")
    Conn.Open ConnString

    Set rs = Conn.OpenSchema(adSchemaPrimaryKeys)

    for each element in rs.fields
    Response.Write element & "<br>"
    next


    rs.Close: set rs = nothing
    Conn.Close: set Conn = nothing


    Neven Klofutar Guest

  2. #2

    Default Re: Access - retriving primary key ...

    Two options, neither of which I've tried (I always seem to know which field
    is the primary key in the tables i've designed for some reason <wink>)

    1. Open a recordset on the table using a sql statement with "WHERE 1=2" so
    you get an empty recordset. Then loop through the Fields collection,
    checking the Attributes property until you find the dey field(s).

    2. Use ADOX.

    HTH,
    Bob Barrows
    Neven Klofutar wrote:
    > Hi,
    >
    > I'm trying to get a primary key from a table via openSchema method,
    > but it seems that I can do that on Access DB.
    > I only get a error:
    > "ADODB.Connection (0x800A0CB3)
    > Object or provider is not capable of performing requested operation."
    >
    > Code:
    > **************************
    > set rs = Server.CreateObject("ADODB.Recordset")
    > set Conn = Server.CreateObject("ADODB.Connection")
    > Conn.Open ConnString
    >
    > Set rs = Conn.OpenSchema(adSchemaPrimaryKeys)
    >
    > for each element in rs.fields
    > Response.Write element & "<br>"
    > next
    >
    >
    > rs.Close: set rs = nothing
    > Conn.Close: set Conn = nothing


    Bob Barrows Guest

Similar Threads

  1. Primary Scratch & Windows Primary Paging file?
    By Tommy Oberst in forum Adobe Photoshop 7, CS, CS2 & CS3
    Replies: 14
    Last Post: April 15th, 10:26 PM
  2. Storing and Retriving Data Locally
    By The Other White Meat in forum Macromedia Flash Data Integration
    Replies: 2
    Last Post: June 20th, 05:26 PM
  3. setting and retriving the correct text member height!
    By garwspeed in forum Macromedia Director Lingo
    Replies: 2
    Last Post: November 19th, 09:17 PM
  4. Putting/retriving files into a database
    By Eric Kincl in forum PHP Development
    Replies: 4
    Last Post: November 10th, 06:05 PM
  5. Access the primary key while inserting a record
    By Nick in forum PHP Development
    Replies: 3
    Last Post: July 20th, 10:48 PM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139