//C連接SQL SERVER

#include <stdio.h>

#include <stdlib.h>

void main()

{

  CString SQL; 
     ::CoInitialize(NULL); 
     _RecordsetPtr PRs("ADODB.Recordset");
     _ConnectionPtr PConn("ADODB.Connection");
     _variant_t RecordsAffected;

     try
  {
   PConn.CreateInstance("ADODB.Connection"); 
      PRs.CreateInstance(__uuidof(Recordset));

SQL.Format("provider=SQLOLEDB;server=(%s);database=s;Uid=s;pwd=s;",ServerName,DbName,UserID,Password);
PConn->Open((_bstr_t)SQL,"","",adModeUnknown);//這里用到了變量來代替連接參數,根據自己改動.
  if(PConn==NULL)
   {
       printf("Connect Sqlserver error!\n");
   }
         else
   {
       printf("Connect Sqlserver success!\n");

}

      PConn->Close;
      PRs->Close;

}

     catch(_com_error e)  //異常
  {
      printf("Connect Error: %s\n",(char *)e.ErrorMessage());
  }

}