SQLConfigDataSource

[DllImport("ODBCCP32.DLL",CharSet=CharSet.Unicode)]

internal extern static int SQLConfigDataSource (int hwndParent, int fRequest, string lpszDriver, string lpszAttributes);

fRequest:

ODBC_ADD_DSN

ODBC_CONFIG_DSN

ODBC_REMOVE_DSN

ODBC_ADD_SYS_DSN

ODBC_CONFIG_SYS_DSN

ODBC_REMOVE_SYS_DSN

ODBC_REMOVE_DEFAULT_DSN

lpszAttributes:

Supports Name value pairs.

Example:

public static bool CreateSQLDSN(string dsnName, string serverName, string dbName)

{

    string Driver;
    string attribs;
    Driver = "SQL Server";
    attribs = "SERVER=" + serverName + Convert.ToChar(0);
    attribs = attribs + "DESCRIPTION=Test DSN" + Convert.ToChar(0);
    attribs = attribs + "DSN=" + dsnName + Convert.ToChar(0);
    attribs = attribs + "DATABASE=" + dbName  + Convert.ToChar(0);
    attribs = attribs + "Trusted_Connection=yes"  + Convert.ToChar(0);
    int intRet = win32apis.SQLConfigDataSource(0, win32apis.ODBC_ADD_DSN, Driver, attribs);
    if (intRet == 1)
        return true;
    return false;

}

internal class win32apis

{

    internal const int ODBC_ADD_DSN = 1;    
    [DllImport("ODBCCP32.DLL",CharSet=CharSet.Unicode)]
    internal extern static int SQLConfigDataSource (int hwndParent, int fRequest, string lpszDriver, string lpszAttributes);

}

Please edit this page!

Do you have...

• helpful tips or sample code to share for using this API in managed code?
• corrections to the existing content?
• variations of the signature you want to share?
• additional languages you want to include?

Select "Edit This Page" on the right hand toolbar and edit it! Or add new pages containing supporting types needed for this API (structures, delegates, and more).