Solved

ODBC Inserting a Record into a MSSQL DB for MFC APP

Posted on 2006-11-07
5
469 Views
Last Modified: 2013-11-20
Please assist me with the process of doing this.

I need to know where to get the DLL's for ODBC drivers.

An example of an insert command using ODBC with the connection settings Etc..

Thanks
0
Comment
Question by:ryankahan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 22

Accepted Solution

by:
mahesh1402 earned 500 total points
ID: 17896400
ODBC driver for MS SQL is included with both Win2000 and WinXP.

For sample look at this ODBC Wrapper :
http://www.codeproject.com/database/ODBC.asp

-MAHESH
0
 

Author Comment

by:ryankahan
ID: 17896696
Thats a very comprehensive link, but what would i take from that page to create a connection,database,recordset and insert a line into the table.

Its a lil over my head.

Thanks
0
 
LVL 22

Expert Comment

by:mahesh1402
ID: 17904246
Ok Look here at this sample :http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vcsample/html/_sample_mfc_ENROLL.asp

Step by step instructions which meets exactly to your needs.

-MAHESH
0
 

Author Comment

by:ryankahan
ID: 17912790
This example is proving difficult to integrate into my existing app.
0
 
LVL 22

Expert Comment

by:mahesh1402
ID: 17912799
you need to look at src code of sample..... about how to add/update records.. when you open workspace you can easily locate needed code.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Expand data scrubbing tool 13 36
conditional code and condition difference 9 87
sum67 challenge 35 128
ERP and the other system process verification 5 25
In this article, I'll describe -- and show pictures of -- some of the significant additions that have been made available to programmers in the MFC Feature Pack for Visual C++ 2008.  These same feature are in the MFC libraries that come with Visual …
Introduction: Ownerdraw of the grid button.  A singleton class implentation and usage. Continuing from the fifth article about sudoku.   Open the project in visual studio. Go to the class view – CGridButton should be visible as a class.  R…
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question