C# Signature:

[DllImport("odbc32.dll",CharSet=CharSet.Unicode)]
static extern short SQLConnect (int connectionHandle, string serverName,
   short nameLength1, string userName, short nameLength2,
   string authentication, short nameLength3);

VB Signature:

<Runtime.InteropServices.DllImport("odbc32.dll", CharSet:=Runtime.InteropServices.CharSet.Unicode)> _
    Private Function SQLConnect(ByVal hDBc As IntPtr, ByVal servername As String, ByVal serverlen As Short, _
    ByVal username As String, ByVal userlen As Short, ByVal pwd As String, ByVal pwdlen As Short) As Short
    End Function

Notes:

None.

Tips & Tricks:

Please add some!

Sample Code:

int RetCode;
int hdbc = 0;
int hEnv = 0;
...
if ( SQLAllocEnv(ref hEnv) != SQL_ERROR)
{
     RetCode = SQLAllocConnect(hEnv,ref hdbc);
     RetCode = SQLConnect(hdbc, "Northwind",-3,null,-3,null,-3);
     ...
}
...

Alternative Managed API:

Do you know one? Please contribute it!

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