Ôõôͨ¹ýODBCʹÓÃwxWidgetsÁ¬½ÓAccessÊý¾Ý¿â
Ôõôͨ¹ýODBCʹÓÃwxWidgetsÁ¬½ÓAccessÊý¾Ý¿â
1¡¢wxWidgets¿âÖÐODBCµÄ±àÒë
ĬÈϱàÒëʱ£¬ODBC¿âÖеÄûÓе¼³ö£¬ÖÂʹµ÷ÓÃwxDbConnectInf£¬wxDbTableµÈÀຯÊýÊÇʱ³öÏÖÁ´½Ó´íÎóµÄÎÊÌ⣬¹ÊÊ×ÏÈÒª±àÒëODBC¿âΪµ¼³ö Àà¿â£¬ÕâÐèÒªÔÚ"Include"Ŀ¼ÏµÄ"Setup.h"ÖжÔ#define wxUSE_ODBC 0ÉèÖÃΪ1£¬ÖØÐ±àÒë¼´¿É.
2¡¢Êý¾Ý¿âµÄÁ´½ÓÓëÊý¾ÝµÄ¶ÁÈ¡
//Æô¶¯ºÍÅäÖÃÊý¾Ý¿â»·¾³
wxDbConnectInf *ConnectConfig = new wxDbConnectInf(NULL, wxT("DB1"), wxT(""), wxT("")); //(DB1¾ÍÊÇODBCÊý¾ÝÔ´) //Á´½ÓÊý¾Ý¿â
wxDb *theConnect = wxDbGetConnection(ConnectConfig);
//±íµÄ´ò¿ª
wxDbTable *tbl = new wxDbTable(theConnect,wxT("S1"),2,wxT(""), !wxDB_QUERY_ONLY, wxT("")); //(S1¾ÍÊÇDB1ÖеıíÃû)
//Êý¾ÝºÍ±äÁ¿°ó¶¨(ID,theNameÊDZíÖеÄ×ֶΣ¬ theID,theName¾ÍÊÇÀ¦°óÊý¾Ý)
tbl->SetColDefs(0, wxT("ID"), DB_DATA_TYPE_INTEGER, &theID, SQL_C_LONG, sizeof(theID), false, true);
tbl->SetColDefs(1, wxT("theName"), DB_DATA_TYPE_VARCHAR, theName, SQL_C_WXCHAR, sizeof(theName), false, true);
//ÅжÏÊÇ·ñÕýÈ·´ò¿ª±í
if (!tbl->Open()) {
//ÅжÏÊÇ·ñÕýÈ·´ò¿ª±í
wxMessageBox("error1");
return;
}
//ÅжÏÊÇ·ñÕýÈ·»ñÈ¡±íÊý¾Ý
if (!tbl->GetDb())
{
//ÅжÏÊÇ·ñÕýÈ·»ñÈ¡±íÊý¾Ý
wxMessageBox("error2");
return;
}
//²éѯÊý¾Ý
tbl ->Query();
wxString wxx;
while (tbl ->GetNext())
{
strcat(theName,"\n");
wxx += theName;
}
3¡¢ºóÐø´¦Àí(ÂÔ)
Ïà¹ØÎĵµ£º
[oledb]
; Everything after this line is an OLE DB initstring
Provider=Microsoft.Jet.OLEDB.4.0;Password=ypbwkfyjhyhgzj;User ID=morningstar;Data Source=C:\Program Files\Kingdee\KIS\BZB\±±¼«ÐÇ.AIS;Persist Security Info=True;Jet OLEDB:System database=C:\Program Files\Kingdee\KIS\BZB\system.mda
......
Ò»¡¢SQL SERVER ºÍACCESSµÄÊý¾Ýµ¼Èëµ¼³ö
³£¹æµÄÊý¾Ýµ¼Èëµ¼³ö£º
ʹÓÃDTSÏòµ¼Ç¨ÒÆÄãµÄAccessÊý¾Ýµ½SQL Server£¬Äã¿ÉÒÔʹÓÃÕâЩ²½Öè:
¡¡¡¡¡ð1ÔÚSQL SERVERÆóÒµ¹ÜÀíÆ÷ÖеÄTools£¨¹¤¾ß£©²Ëµ¥ÉÏ£¬Ñ¡ÔñData Transformation
¡¡¡¡¡ð2Services£¨Êý¾Ýת»»·þÎñ£©£¬È»ºóÑ¡Ôñ czdImport Data£¨µ¼ÈëÊý¾Ý£©¡£
¡¡¡¡¡ ......
OPENDATASOURCE ´ò¿ªexcel¡¢access¡¢qsl
use test
insert into OPENDATASOURCE('SQLOLEDB', 'Data Source=192.168.2.200;User ID=sa;Password=110').test.dbo.adf--´ò¿ªÔ¶³ÌÊý¾Ý¿â
select * from OpenRowSet('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;HDR=Yes;IMEX=1;Database=c:\2003.xls', [kg$])
--²éѯԶ³ÌÊý¾Ý ......
Ò»¡¢ADO¼ò½é
ADO(Active Data Object£¬»î¶¯Êý¾Ý¶ÔÏó)ʵ¼ÊÉÏÊÇÒ»ÖÖ»ùÓÚCOM(×é¼þ¶ÔÏóÄ£ÐÍ)ÖеÄ×Ô¶¯»¯½Ó¿Ú(IDispatch)¼¼Êõ£¬²¢ÒÔOLE DB(¶ÔÏóÁ¬½ÓºÍÏâÈëµÄÊý¾Ý¿â)Ϊ»ù´¡£¬¾¹ýOLE DB¾«Ðİü×°ºóµÄÊý¾Ý¿â·ÃÎʼ¼Êõ£¬ÀûÓÃËü¿ÉÒÔ¿ìËٵĴ´½¨Êý¾Ý¿âÓ¦ÓóÌÐò¡£
ADOÌṩÁËÒ»×é·Ç³£¼òµ¥£¬½«Ò»°ãͨÓõÄÊý¾Ý·ÃÎÊϸ½Ú½øÐзâ×°µÄ¶ÔÏó¡£ÓÉÓ ......
----±È½Ï¸´ÔÓµÄÊý¾Ý¿âÖÐÒ»°ã»áÓÐλͼÊý¾Ý£¨±ÈÈçÏàÆ¬£©¡£ËäÈ»ÕâÀà“OLE¶ÔÏó”µÄ²åÈ롢ɾ³ýÒÔ¼°Ìæ»»²Ù×÷ÔÚACCESSÀïÈÝÒ×ʵÏÖ£¬ÔÚVCÖÐÈ´ÏԵø´ÔÓ¶øÇÒÆÄ·ÑÖÜÕÛ¡£ÒÔϰÑ×÷ÕßÓÃVC´¦ÀíACCESSÊý¾Ý¿âÖеÄλͼÊý¾ÝµÄÌå»á¼òµ¥ÐðÊöһϣ¬ÒÔÇë½ÌÓÚ´ó¼Ò¡£
----ÔÚCdaoRecordsetÅÉÉúÀàµÄ¶ÔÏóÖУ¬VC×Ô¶¯ÎªACCESSµÄ“OLE¶ÔÏó&r ......