Does anyone know the way to use C++

[drchrisco]

Does anyone know the way to use C++ program call a SQL query based on user based information. I know how to C++ act like EM but couldn't figure out how to access the database in a program setting.

Thanks
Chrisco

 

[BobLoblaws]

Create an ADO connection in C++ to your SQL Server.
Set the connection parameters.

Use a string to contain the information. ie strSQL = "exec sp_Something " + var1 + "," + var2"

Then execute the information. ie adConn.Execute strSQL

I don't have the correct syntax infront of me, but I am pretty sure this is how it works.
Hope this helps.