Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. ODBC Probelm

ODBC Probelm

Scheduled Pinned Locked Moved Database
databasesql-serversysadmin
4 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • S Offline
    S Offline
    SamirSood
    wrote on last edited by
    #1

    Can anyone suggest me the line of codes and the data type of the field through which we can store files in an SQl Server Database through an ODBC Recordset Samir Sood

    E 1 Reply Last reply
    0
    • S SamirSood

      Can anyone suggest me the line of codes and the data type of the field through which we can store files in an SQl Server Database through an ODBC Recordset Samir Sood

      E Offline
      E Offline
      Ed Gadziemski
      wrote on last edited by
      #2

      You question is unclear. Please try again. Do you want to save binary data, i.e. "files", in a field in a SQL Server database? As far as the lines of code, you would use an INSERT statement to store new rows and an UPDATE statement to modify existing rows.

      S 1 Reply Last reply
      0
      • E Ed Gadziemski

        You question is unclear. Please try again. Do you want to save binary data, i.e. "files", in a field in a SQL Server database? As far as the lines of code, you would use an INSERT statement to store new rows and an UPDATE statement to modify existing rows.

        S Offline
        S Offline
        SamirSood
        wrote on last edited by
        #3

        I want to store actual files i.e txt , rtf and doc files in the database . Please Give the ines of code to insert and update them throgh odbc in MFC. Samir Sood

        P 1 Reply Last reply
        0
        • S SamirSood

          I want to store actual files i.e txt , rtf and doc files in the database . Please Give the ines of code to insert and update them throgh odbc in MFC. Samir Sood

          P Offline
          P Offline
          Pavel Klocek
          wrote on last edited by
          #4

          You can store anything into BINARY database fields. Read/Store the file to/from CLongBinary. You can use CLongBinary variable in RFX_LongBinary for typed recordset. Pavel Sonork 100.15206

          1 Reply Last reply
          0
          Reply
          • Reply as topic
          Log in to reply
          • Oldest to Newest
          • Newest to Oldest
          • Most Votes


          • Login

          • Don't have an account? Register

          • Login or register to search.
          • First post
            Last post
          0
          • Categories
          • Recent
          • Tags
          • Popular
          • World
          • Users
          • Groups