Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 501
  • Last Modified:

ODBC Inserting a Record into a MSSQL DB for MFC APP

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
ryankahan
Asked:
ryankahan
  • 3
  • 2
1 Solution
 
mahesh1402Commented:
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
 
ryankahanAuthor Commented:
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
 
mahesh1402Commented:
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
 
ryankahanAuthor Commented:
This example is proving difficult to integrate into my existing app.
0
 
mahesh1402Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now