SQL Server Transact SQL
-
Just wondering what I need to add to a VC++ program to allow me to directly access an SQL Server database using Transact SQL. Is there an SQL Server SDK? Michael Martin Australia mmartin@netspace.net.au "Don't belong. Never join. Think for yourself. Peace" - Victor Stone
-
Just wondering what I need to add to a VC++ program to allow me to directly access an SQL Server database using Transact SQL. Is there an SQL Server SDK? Michael Martin Australia mmartin@netspace.net.au "Don't belong. Never join. Think for yourself. Peace" - Victor Stone
-
Just wondering what I need to add to a VC++ program to allow me to directly access an SQL Server database using Transact SQL. Is there an SQL Server SDK? Michael Martin Australia mmartin@netspace.net.au "Don't belong. Never join. Think for yourself. Peace" - Victor Stone
You can use the dbengine of sql server or my ado classes Regards.... Carlos Antollini. Sonork ID 100.10529 cantollini I have yet to meet a C compiler that is more friendly and easier to use than eating soup with a knife.
-
You could add an ADO class found in CodeProject somewhere and in there you can create strings which consist of your T-SQL then you get a recordset back. you dont need an sql sdk. I hope thats what you wanted;) The Wudan Master
ADO or ADO.NET (as required) are excellent choices. If however you are looking for more low level access then take a look at DBLib. This is the native accessibility layer for SQL*Server. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vcsample98/html/vcsmpdblib.asp Success is measured by ones ability to mask complexity with simplicity.