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

ryankahan

Asked: 2006-11-07

Advertise Here

System Programming

1 Solution

LVL 22

mahesh1402Commented: 2006-11-08

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

ryankahanAuthor Commented: 2006-11-08

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

LVL 22

mahesh1402Commented: 2006-11-08

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

ryankahanAuthor Commented: 2006-11-10

This example is proving difficult to integrate into my existing app.

LVL 22

mahesh1402Commented: 2006-11-10

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.

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.

Expand your skills with this month's free Premium course.

ODBC Inserting a Record into a MSSQL DB for MFC APP

Join & Write a Comment Already a member? Login.

Featured Post