VS2012 连接localdb
为了学习c++数据库编程相关知识、但是又不想下载额外的数据库程序,了解到VC2012中自带数据库localdb(关于locaaldb的相关知识、参见: https://docs.microsoft.com/zh-cn/sql/database-engine/configure-windows/sql-server-express-localdb?view=sql-server-ver15.
Example
这是第一个使用localdb的例子:
下面展示一些 内联代码片
。
// localdb连接测试
#include "stdafx.h"
#include <string>
#include <iostream>
using namespace std;
int _tmain(int argc, _TCHAR* argv[])
{
::CoInitialize(NULL);
_ConnectionPtr pConn(__uuidof(Connection));
_RecordsetPtr pRec(__uuidof(Recordset));
try{
//_bstr_t strCnn("Data Source=(LocalDB)\\v11.0;AttachDbFilename=D:\\FileData\\visual-studio-2012\\pdb\\ttt.mdf;Integrated Security=True");
//_bstr_t strCnn("Data Source=SqlClient; AttachDbFilename=D:\\FileData\\visual-studio-2012\\pdb\\ttt.mdf;Integrated Security=True;Connect Timeout=30");
_bstr_t strCnn("Provider=SQLNCLI11.1;Integrated Security=SSPI;Persist Security Info=False;User ID="";Initial Catalog=D:\\FILEDATA\\VISUAL-STUDIO-2012\\PDB\\TTT.MDF;Data Source=(LocalDB)\\v11.0;Initial File Name="";Server SPN=""");
pConn->Open(strCnn, "", "", adModeUnknown);
}catch