Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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"´¦Ñ¡ÔñÄã¸


Ïà¹ØÎÊ´ð£º

ÃÅÍ⺺ÇóÖú...¹ØÓÚºǫ́+SQL+ASP

....½Óµ½Ò»¸öС³ÌÐò..¹¤×÷Ô­À´´ó¸ÅÊÇÕâÑùµÄ...ǰ̨ÊÇWEB·þÎñÆ÷.¼Ü¹¹¾ÍÊÇASP+SQL..ǰ̨ÓÉASPÏòSQLÌí¼Ó·þÎñÀà±ð(±íµ¥).È»ºóÓÖºǫ́³ÌÐò¶ÁÈ¡±íµ¥..Ҫʵʱ¶ÁÈ¡..È»ºóÏÔʾÔÚ·þÎñÆ÷ÉÏÃæ..´ÓÀíÂÛÉÏÃæÄÜÐÐͨ²»?Èç¹û¿ÉÒÔ..ºǫ́ ......

×Ü»áÅöµ½¹ÖµÄÎÊÌ⣬sqlÎÊÌâ

sql2005
select *from v_ddxx where d_sfsc='0' and (g_ssbm='1001' or g_ssbm='1002') and (xxf>0 and  xxfwzf <>0 ),Ö´ÐÐËÙ¶ÈÂýµÄÒªËÀ£¬µ«ÊÇÈç¹û°Ñ(xxf>0 and  ......

sqlÎļþ£¨Êý¾Ýº¬ÖÐÎÄ£©DOSÃüÁî´°¿ÚÎÞ·¨µ¼ÈëÎÊÌâ

ÎÒÓõÄÊÇmysql5.1£¬Êý¾Ý¿â×Ö·û¼¯Îªutf8

ͨ¹ýdosÃüÁîÐе¼ÈëSQLÎļþ ³ö´í£¬ÎÞ·¨µ¼Èë¡£

½«SQLÎļþÖеÄÊý¾ÝÈ«²¿Ê¹ÓÃÓ¢ÎÄ ¿ÉÒÔµ¼Èë

ÇëÎÊÎÊÌâÔÚÄÄ£¿
×°¸öÖÐÎÄÈí¼þ¼´¿É.

ºÜ¶àÄêÒÔǰ,Óùý¸öÒ»¸ ......

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

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

²»Ã÷°×µÄSQL×¢ÈëÎÊÌâ

ÎÒÊý¾Ý¿âÊÇMSSQLµÄ£¬×òÌìËùÓÐµÄ±í±»×¢ÈëJS½Å±¾´úÂë,Óиö²»Ã÷°×µÄµØ·½À´ÎÊÎÊ´ó¼Ò

ÎÒ·¢ÏÖÓÐЩ±íÎÒ¸ù±¾Ã»Ê¹Óã¬Ò²Ã»ÓÐÈë¿âµÄASPÒ³ÃæºÍÓï¾ä£¬ËüÊÇÔÛ¸ö×¢ÈëµÄÄØ£¿
Ã²ËÆselectÓï¾äÊÇ¿ÉÒÔǶÌ׵İɣ¿
¿ÉÄÜÊÇwhere ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ