Ways to update a sql server database from a VC++ win32 project?

Question

Hello

I'm in the process of creating a Password Filter as described here. I can manage to write the VC++ code. My issue is that i need to update SQL Server database from that code. I dont have any past experience in VC++ Win32 project. My assumptions are

1. Linking an external dll (compiled C#.net code) which will take care of the database update

2. Hitting a windows service which will take care of the update

   Any insights?

Answer 1

Why are those your only two options?

You can use ADO from directly within C++ by #import(ing) msado15.dll, which exposes lots of useful objects and methods from ADO. See: Visual C++ ADO Programming

There are other options here: Data Access Programming in Visual C++

Answer 2

Okay. Since i dont have good working in knowledge in VC++ i found this solution to be more easy for me to do. Just followed this Microsoft KB to register a managed dll and create a type library and to use it in the VC++ code.

Anyways thanks for your reply joe.

NLV