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
ryankahanAsked:
Who is Participating?
 
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.

All Courses

From novice to tech pro — start learning today.

Advertise Here