vc中如何利用odbc连接sql server 数据库? 如何连接呀?能不能给出具体的代码?或者介绍篇介绍这些内容的文章谢谢了包括对表的操作,在这个过城中,用到那些类呀越具体越好谢谢各位 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 _ConnectionPtr m_pConnection; AfxOleInit(); m_pConnection.CreateInstance(__uuidof(Connection)); try { //m_pConnection->Open("DRIVER={SQL SERVER};SERVER=pc-096s;DATABASE=Message;USER ID=sa;PASSWORD=DEAR41296","","",adModeUnknown); m_pConnection->Open("DRIVER={SQL SERVER};SERVER=192.168.0.21;DATABASE=Message;USER ID=ht;PASSWORD=","","",adModeUnknown); } catch (_com_error e) { AfxMessageBox("Connect database ail"); } James_ht(顺风飞扬) 能给我传一份么?是ODBC连接么?你上面写的应该是ADO吧有odbc的话给我传一份,谢谢 m_pConnection->Open("DRIVER={SQL SERVER};SERVER=pc-096s;DATABASE=Message;USER ID=sa;PASSWORD=DEAR41296","","",adModeUnknown);上面那段跟下面那段都是什么连接什么意思?怎么连接字符串不一样的 m_pConnection->Open("DRIVER={SQL SERVER};SERVER=192.168.0.21;DATABASE=Message;USER ID=ht;PASSWORD=","","",adModeUnknown); "DRIVER={SQL SERVER};SERVER=pc-096s;DATABASE=Message;USER ID=sa;PASSWORD=DEAR41296"跟下面的连接是什么意思?字符串不一样。"Provider=SQLOLEDB;Server=workgroup-1;Database=test;uid=uid;pwd=pwd;" ODBC链接适合数据库类型 链接方式 access "Driver={microsoft access driver(*.mdb)};dbq=*.mdb;uid=admin;pwd=pass;" dBase "Driver={microsoft dbase driver(*.dbf)};driverid=277;dbq=------------;" Oracle "Driver={microsoft odbc for oracle};server=oraclesever.world;uid=admin;pwd=pass;" MSSQL server "Driver={sql server};server=servername;database=dbname;uid=sa;pwd=pass;" MS text "Driver={microsoft text driver(*.txt; *.csv)};dbq=-----;extensions=asc,csv,tab,txt;Persist SecurityInfo=false;" Visual Foxpro "Driver={microsoft Visual Foxpro driver};sourcetype=DBC;sourceDB=*.dbc;Exclusive=No;" MySQL "Driver={mysql};database=yourdatabase;uid=username;pwd=yourpassword;option=16386;" OLEDB链接适合的数据库类型 链接方式 access "Provider=microsoft.jet.oledb.4.0;data source=your_database_path;user id=admin;password=pass;" Oracle "Provider=OraOLEDB.Oracle;data source=dbname;user id=admin;password=pass;" MS SQL Server "Provider=SQLOLEDB;data source=machinename;initial catalog=dbname;userid=sa;password=pass;" MS text "Provider=microsof.jet.oledb.4.0;data source=your_path;Extended Properties'text;FMT=Delimited'" pConnection->Open("Data Source=your-dsn;UID=name;PWD=pwd;","","",adModeUnknown); 分只给一个人,解决了就是你的 WINCE下如何禁止通过标题栏拖动窗口 高手们:VC6.0如何编写用于ASP.net/C#环境下的服务器组件? wmf文件到CBitmap 求波形条的图片(在线等待) 急!CString 类型如何赋值给char数组? 到哪里去查ActiveX控件的属性和方法呢? 问个低级问题,vc中多维数组如何赋值? 当 ToolBar 被移动后,如何得到其中一个按钮的位置(Rect)? 从下到上显示彩条。 CreateFont函数中的字体高度是以像素为单位的吗??? 急:算法高手请进。有一个难题求解?
AfxOleInit();
m_pConnection.CreateInstance(__uuidof(Connection));
try
{
//m_pConnection->Open("DRIVER={SQL SERVER};SERVER=pc-096s;DATABASE=Message;USER ID=sa;PASSWORD=DEAR41296","","",adModeUnknown);
m_pConnection->Open("DRIVER={SQL SERVER};SERVER=192.168.0.21;DATABASE=Message;USER ID=ht;PASSWORD=","","",adModeUnknown);
}
catch (_com_error e)
{
AfxMessageBox("Connect database ail");
}
有odbc的话给我传一份,谢谢
上面那段跟下面那段都是什么连接什么意思?怎么连接字符串不一样的
m_pConnection->Open("DRIVER={SQL SERVER};SERVER=192.168.0.21;DATABASE=Message;USER ID=ht;PASSWORD=","","",adModeUnknown);
跟下面的连接是什么意思?字符串不一样。
"Provider=SQLOLEDB;Server=workgroup-1;Database=test;uid=uid;pwd=pwd;"
access "Driver={microsoft access driver(*.mdb)};dbq=*.mdb;uid=admin;pwd=pass;"
dBase "Driver={microsoft dbase driver(*.dbf)};driverid=277;dbq=------------;"
Oracle "Driver={microsoft odbc for oracle};server=oraclesever.world;uid=admin;pwd=pass;"
MSSQL server "Driver={sql server};server=servername;database=dbname;uid=sa;pwd=pass;"
MS text "Driver={microsoft text driver(*.txt; *.csv)};dbq=-----;extensions=asc,csv,tab,txt;Persist SecurityInfo=false;"
Visual Foxpro "Driver={microsoft Visual Foxpro driver};sourcetype=DBC;sourceDB=*.dbc;Exclusive=No;"
MySQL "Driver={mysql};database=yourdatabase;uid=username;pwd=yourpassword;option=16386;"
OLEDB链接适合的数据库类型 链接方式
access "Provider=microsoft.jet.oledb.4.0;data source=your_database_path;user id=admin;password=pass;"
Oracle "Provider=OraOLEDB.Oracle;data source=dbname;user id=admin;password=pass;"
MS SQL Server "Provider=SQLOLEDB;data source=machinename;initial catalog=dbname;userid=sa;password=pass;"
MS text "Provider=microsof.jet.oledb.4.0;data source=your_path;Extended Properties'text;FMT=Delimited'"