C语言使用ODBC连接SQL Server报错SQLSTATE IM008，疑为连接字符串问题

运行下方C语言ODBC代码连接SQL Server时，返回"Dialog failed"提示，且SQLSTATE为IM008。连接字符串格式与可正常运行的Python实现完全一致，printf输出显示连接字符串符合预期，怀疑登录凭证问题但不确定具体错误点。

出错的C语言代码 #

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

int main() {
    SQLHENV hEnv;
    SQLHDBC hDbc;
    SQLRETURN ret; /* ODBC API return status */

    SQLCHAR* connStr = (SQLCHAR*)"DRIVER={ODBC Driver 17 for SQL Server}; SERVER={tcp:xxx.xxx.xxx.xxx,xxxx}; UID=****; PWD=*****; DATABASE={SDC};\0";

    printf("%s\n", connStr);


    // Allocate an environment handle
    ret = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &hEnv);
    if (ret != SQL_SUCCESS && ret != SQL_SUCCESS_WITH_INFO) {
        printf("Error allocating environment handle\n");
        return -1;
    }

    // Set the ODBC version environment attribute
    ret = SQLSetEnvAttr(hEnv, SQL_ATTR_ODBC_VERSION, (SQLPOINTER)SQL_OV_ODBC3, 0);
    if (ret != SQL_SUCCESS && ret != SQL_SUCCESS_WITH_INFO) {
        printf("Error setting environment attribute\n");
        SQLFreeHandle(SQL_HANDLE_ENV, hEnv);
        return -1;
    }

    // Allocate a connection handle
    ret = SQLAllocHandle(SQL_HANDLE_DBC, hEnv, &hDbc);
    if (ret != SQL_SUCCESS && ret != SQL_SUCCESS_WITH_INFO) {
        printf("Error allocating connection handle\n");
        SQLFreeHandle(SQL_HANDLE_ENV, hEnv);
        return -1;
    }

    // Set login timeout to 5 seconds
    SQLSetConnectAttr(hDbc, SQL_LOGIN_TIMEOUT, (SQLPOINTER)5, 0);

    // Connect to the SQL Server
    ret = SQLDriverConnect(hDbc, NULL, connStr, SQL_NTS, NULL, 0, NULL, SQL_DRIVER_COMPLETE);

    if (ret == SQL_ERROR) {
        SQLCHAR sqlState[12] = { 0 };  // 5 characters + null terminator
        SQLINTEGER nativeError;
        SQLCHAR messageText[2048] = { 0 };  // Message buffer
        SQLSMALLINT messageLength;

        // Fetch diagnostic information
        ret = SQLGetDiagRec(SQL_HANDLE_DBC, hDbc, 1, sqlState, &nativeError, messageText, sizeof(messageText), &messageLength);

        // Null-terminate the message if it exceeds the buffer size
        if (messageLength > sizeof(messageText) - 1) {
            messageText[sizeof(messageText) - 1] = '\0';
        }

        printf("SQLSTATE: %s\n", sqlState);
        printf("Native Error Code: %d\n", nativeError);
        printf("Message: %s\n", messageText);
    }
    else if (ret == SQL_SUCCESS_WITH_INFO) {
        printf("Connection successful with info!\n");
    }
    else if (ret == SQL_SUCCESS) {
        printf("Connection successful!\n");
    }
    else {
        printf("Error connecting to the database\n");
        SQLFreeHandle(SQL_HANDLE_DBC, hDbc);
        SQLFreeHandle(SQL_HANDLE_ENV, hEnv);
        return -1;
    }

    // Close the connection and free handles
    SQLDisconnect(hDbc);
    SQLFreeHandle(SQL_HANDLE_DBC, hDbc);
    SQLFreeHandle(SQL_HANDLE_ENV, hEnv); 

    return 0;
}

可正常运行的Python代码 #

import pyodbc as sql
import pandas as pd
import sys
import warnings
from time import (strftime, strptime)


server = 'tcp:xxx.xxx.xxx.xxx,xxxx'
db = 'SDC'

string = "DRIVER={ODBC Driver 17 for SQL Server}; SERVER={"+server+"}; UID=****; PWD=*****; DATABASE={"+db+"}; "

print(string)

try:
    db = sql.connect(string)
    print('It worked!')
except Exception as ex:
    print(ex)

问题原因与解决方法 #

• 核心原因：SQLSTATE IM008对应“对话框失败”，是因为你调用SQLDriverConnect时使用了SQL_DRIVER_COMPLETE参数。该参数会在连接信息不完整或验证失败时，弹出GUI对话框让用户补充/修正信息，但你的程序是控制台环境，无法显示这个对话框，直接导致连接失败。而Python的pyodbc内部默认使用无交互模式（类似SQL_DRIVER_NOPROMPT），不会触发对话框，因此能正常连接。
• 解决方法：将SQLDriverConnect的最后一个参数改为SQL_DRIVER_NOPROMPT，强制不弹出对话框，直接使用提供的连接字符串完成连接。如果连接字符串本身有问题（如凭证错误、服务器地址无效），会直接返回对应的错误信息，方便排查。

修改后的连接代码行：

ret = SQLDriverConnect(hDbc, NULL, connStr, SQL_NTS, NULL, 0, NULL, SQL_DRIVER_NOPROMPT);

如果修改后仍报错，再逐一排查：

• 确认SQL Server的IP、端口是否可访问
• 验证登录账号（UID）和密码（PWD）的正确性
• 检查本地是否已正确安装ODBC Driver 17 for SQL Server

内容的提问来源于stack exchange，提问作者Fulvio