.

Summary

This function is used to work with the ODBC Datasources

C# Signature:

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

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

VB Signature:

TODO

User-Defined Types:

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

More

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcsqlconfigdatasource.asp

lpszAttributes:

Supports Name value pairs.

More

http://www.schemamania.org/jkl/booksonline/SQLBOL70/html/odbc_c_4.htm

Notes:

None.

Tips & Tricks:

Please add some!

Sample Code:

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);

}

Alternative Managed API:

Do you know one? Please contribute it!

Documentation

SQLConfigDataSource on MSDN