Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

dbf±íµ¼Èëµ½sql server2000±íÎÊÌâ

ÇëÎÊ£º
1,ÈçºÎ½«Ò»ÕÅdbf±íµ¼Èëµ½sql server2000ÖеÄÒ»ÕÅ±í¡£Ê¹ÓÃDTS¸ÃÔõÑùʵÏÖ£¿
2,ʹÓÃÍøÉÏ´úÂ룺
Insert Into Tb_cj Select * from openrowset('MSDASQL','Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=c:','select * from F:\MyWeb\094ʵ¼ù³É¼¨.DBF')
±¨´í£º
OLE DB Ìṩ³ÌÐò 'MSDASQL' ±¨´í¡£
[OLE/DB provider returned message: [Microsoft][ODBC Çý¶¯³ÌÐò¹ÜÀíÆ÷] Çý¶¯³ÌÐò²»Ö§³Ö´Ë¹¦ÄÜ]

ÇëÎʸ÷λ¸ßÈËÈçºÎ½â¾ö¸ÃÎÊÌ⣬ÏÈл¹ý¡£
¹¤¾ßµ¼Èë1£ºÍ¨¹ýSQL ServerµÄ¡°µ¼Èëµ¼³öÊý¾Ý¡±¹¤¾ß£¨DTS£©

1¡¢½¨Á¢Visual FoxProµÄÊý¾ÝÔ´£º

ÔÚODBCÖн¨Á¢Ò»¸öVisual FoxProµÄÊý¾ÝÔ´(ODBC-Microsoft Visual FoxPro Driver)µÄ²½ÖèÈçÏ£º
´ò¿ªODBCÅäÖÆ´°¿Ú ->
Ñ¡Ôñ¡°Óû§DSN¡±Ò³Ãæ»ò¡°ÏµÍ³DSN¡±Ò³Ã棬½¨ÒéÓúóÕß ->
µã»÷¡°Ìí¼Ó¡±°´Å¥ ->
Ñ¡Ôñ¡°Microsoft Visual FoxPro Driver¡±Õâ¸öÇý¶¯ ->
ÔÚData Source Name£¨ÊýÔ´Ô´Ãû³Æ£©´¦ÊäÈë´ËÊý¾ÝÔ´Ãû³Æ£¬¿É×Ô¶¨£¬±¾ÀýÈçLjDbf£¬Database Type£¨Êý¾Ý¿âÀàÐÍ£©´¦Ñ¡Ôñ¡°Free Table directory¡±(×ÔÓɱí·¾¶)£¬È»ºóÔÚÏÂÃæµÄPath£¨Â·¾¶£©´¦ÉèÖÃÄãÒªµ¼ÈëµÄDBF±íËùÔڵķ¾¶£¬±¾ÁÐÈç¡°D:¡± ->
µã»÷¡°OK¡±£¨È·¶¨£©ÅäÖÆÍê³É ->
¹Ø±ÕODBCÅäÖÆ´°¿Ú

2¡¢Í¨¹ýSQLµÄµ¼Èëµ¼³öÊý¾Ý£¨DTS£©À´°ÑDBF±íµ¼³ÉSQL±í£º

¿ªÊ¼ ->
³ÌÐò ->
Microsoft Sql Server£­µ¼Èëµ¼³öÊý£¨DTS£©->
ÏÂÒ»²½ ->
´Ë²½Îª¡°Ñ¡ÔñÊý¾ÝÔ´¡±µÄ´°¿Ú£¬¡°Êý¾ÝÔ´¡±Ñ¡¡°Microsoft Visual FoxPro Driver¡±£¬Í¬Ê±ÔÚ"Óû§/ϵͳDSN"´¦Ñ¡ÔñÄã¸


Ïà¹ØÎÊ´ð£º

ÈçºÎÓÃc#£¬sql2000 ¿ª·¢c/sÏµĹ¤×÷Á÷£¿

±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï°
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......

sql ÎÊÌâ

PBÖпª·¢µÄ¡£

DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)

string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+&q ......

oracle sql developer ²éѯÏÔʾÖÐÎÄÂÒÂë

»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£ ......

ÇóÒ»¸ösql Óï¾ä

  table1
  Ãû³Æ      Èë¿âÊý
  CT»ú        3   
  CT»ú        5
  X¹â»ú      4 ......

SQL ¶à±í²éѯ²é³öËùÒªµÄÊý¾Ý£¿

ÒÑÖª´ÓB,±íÖÐÕÒ³öID, NAMEÁ½ÏîÓëC±íÏàͬµÄÊý¾Ý£¬ÔÙÒÀ¾ÝB±íÖо­¹ý²éѯ³öÀ´µÄID,CODEÁ½ÏîÊý¾Ý²éѯÓëA±íID,CODEÁ½ÏîÏàͬµÄÊý¾ÝÖжÔÓ¦µÄEMAILÀ´£¬²¢ÁгöÈçÏÂD±íµÄÐÎʽ£¬²»ÖªÎÒÊÇ·ñ±íʾÇå³þ£¿Âé·³°ïÎÒÁÐһϹ«Ê½ºÃÂð£¿Íò· ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ