Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- microsoft_sql_server [2025/12/10 09:56]
jango [Downloads]
+++ microsoft_sql_server [2025/12/10 10:31] (aktuell)
jango [Code]
@@ Zeile 123: / Zeile 123: @@
     std::string conn =
         //"Driver={ODBC Driver 18 for SQL Server};"
-		"Driver={SQL Server};"
+	"Driver={SQL Server};"
         //"Server=tcp:VIE-CLU-SQL04\\SEMACORE,1433;"
-		"Server=VIE-CLU-SQL04\\SEMACORE;"
+	"Server=VIE-CLU-SQL04\\SEMACORE;"
         "Database=AUDIT_DATA;"
-        "Uid=semacore_admin;"
+        "Uid=admin;"
         "Pwd=W@s1dochnet!;"
         //"Encrypt=yes;"
@@ Zeile 146: / Zeile 146: @@
     check(SQLExecDirectA(stmt, (SQLCHAR*)sql, SQL_NTS), stmt, SQL_HANDLE_STMT, "Exec");
-    // 4) Results lesen (1. Spalte als Text)
+    // 4) Results lesen (1. und 3. Spalte als Text)
+    char id[256];
+    SQLLEN idInd = 0;
     char name[256];
     SQLLEN nameInd = 0;
-    check(SQLBindCol(stmt, 1, SQL_C_CHAR, name, sizeof(name), &nameInd),
+    check(SQLBindCol(stmt, 3, SQL_C_CHAR, name, sizeof(name), &nameInd), stmt, SQL_HANDLE_STMT, "BindCol");
-          stmt, SQL_HANDLE_STMT, "BindCol");
+    check(SQLBindCol(stmt, 1, SQL_C_CHAR, id, sizeof(id), &idInd), stmt, SQL_HANDLE_STMT, "BindCol");
     while (SQLFetch(stmt) == SQL_SUCCESS) {
-        std::cout << name << "\n";
+        std::cout << id << " == " << name << "\n";
     }

MBCDN