给个连接 SQL SERVER 的例子

Question

给个连接 SQL SERVER 的例子 
要有连接 
执行SQL 语句。
不要 ODBC 的 

Answer 1

http://www.vckbase.net/code/listcode.asp?mclsid=11&sclsid=1111
希望对你有用!

Answer 2

提供两种：ADO
m_pConnection->Open("driver={SQL Server};Server=211.64.156.98;DATABASE=pubs;UID=sa;PWD=0829","","",adModeUnknown);m_pConnection->Open("Provider=sqloledb ;Data Source="机器名";persist security info=false;Initial Catalog="数据库名";User Id=sa;Password=;");

Answer 3

看这个精华帖子
http://community.csdn.net/Expert/topic/3283/3283231.xml?temp=.2042505

Answer 4

HRESULT hr;
try
{
  hr = m_pConnection.CreateInstance(_uuidof(Connection));
  if(!SUCCEEDED(hr))
    AfxMessageBox("初始化失败!");
  hr = m_pConnection->Open("Driver={SQL Server};Server=ServerName;UID=UserName;PWD=password","","",adModeUnknown);
  if(!SUCCEEDED(hr))
    AfxMessageBox("连接失败!");
  else
    AfxMessageBox("连接成功!");
}
catch(_com_error e)//捕捉异常
{
   AfxMessageBox(e.ErrorMessage());
}m_pConnection->Close();

Answer 5

Driver={SQL Server};Server=ServerName;UID=UserName;PWD=password","","",adModeUnknown

Answer 6

/* 使用用于 ODBC 的 OLE DB 提供者(不使用 ODBC DSN) */ //使用SQL Server 身份验证
//CString sqlstr="Driver={SQL Server};Server=10.89.161.122;Database=mytestdb;Uid=sa;pwd=;"; //使用 Windows 身份验证(信任连接)
//CString sqlstr="Driver={SQL Server};Server=10.89.161.122;Database=mytestdb;Trusted_Connection=yes"; /* 使用用于 SQL Server 的 OLE DB 提供者： */ //使用SQL Server 身份验证
CString sqlstr="Provider=sqloledb;Data Source=10.89.161.122;Initial Catalog=mytestdb;User Id=sa;Password=";

//使用 Windows 身份验证(信任连接)
//CString sqlstr="Provider=sqloledb;Data Source=10.89.161.122;Initial Catalog=mytestdb;Integrated Security=SSPI";

HRESULT hr;
try
{
hr = m_pConnect.CreateInstance("ADODB.Connection");//创建Connection对象
if(SUCCEEDED(hr))
hr=m_pConnect->Open((_bstr_t)sqlstr,"","",adModeUnknown);///连接数据库
}
catch(_com_error e)
{
MessageBox(NULL,e.ErrorMessage(),"Error",MB_ICONINFORMATION);
}

Answer 7

pdb->Open(
"driver={SQL Server};
Server=localhost;
DATABASE=pubs;
UID=sa;
PWD= ","","",adModeUnknown);

Answer 8

cnne->Open("driver={SQL Server};Server=localhost;DATABASE=pubs;UID=sa;PWD= ","","",adModeUnknown);