#include "stdafx.h"

#include <windows.h>
#include <sqltypes.h>
#include <sql.h>
#include <sqlext.h>
#include <stdio.h>

#define COMMAND_MAX_SIZE 500

int main(int argc, char *argv[])
{
	SQLHSTMT stmt;
	SQLHENV env;
	SQLHDBC dbc;
	RETCODE retcode;
	SQLWCHAR command[COMMAND_MAX_SIZE];
	// Allocate an environment handle 
	SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &env);
	// We want ODBC 3 support 
	SQLSetEnvAttr(env, SQL_ATTR_ODBC_VERSION, (void *)SQL_OV_ODBC3, 0);
	// Allocate a connection handle 
	SQLAllocHandle(SQL_HANDLE_DBC, env, &dbc);
	SQLDriverConnect(dbc,
		GetDesktopWindow(),
                //(SQLWCHAR*)"DSN=C:\\C_p_p\\test.dsn",
		(SQLWCHAR*)"DRIVER={ODBC Driver 11 for SQL Server};SERVER=ЕВГЕНИЙ\\sql_server; DATABASE=testSQL;Trusted_Connection=Yes;", 
		SQL_NTS,
		NULL,
		0,
		NULL,
		SQL_DRIVER_PROMPT);
	// Check for success 
	printf("Check sql connection:\n");
	// проверяем подключением
	if (SQL_SUCCESS != SQLAllocHandle(SQL_HANDLE_STMT, dbc, &stmt)) {
		printf("SQL connection failed!\n");
	}
	else {																		
		printf("SQL connection Success!\n");
		wsprintf(command, L"INSERT INTO [dbo].[_вспомогательная] ([Число1],[Число2],[Текст1]) VALUES (1,2,'текст');");
		retcode = SQLExecDirect(stmt, command, SQL_NTS);
	}
		system("pause"); 
}

(SQLWCHAR*)"DRIVER={ODBC Driver 11 for SQL Server};SERVER=ЕВГЕНИЙ\\sql_server; DATABASE=testSQL;Trusted_Connection=Yes;",

(SQLWCHAR*)"DSN=C:\\C_p_p\\test.dsn",