SQL2000Á¬½Óµ½MySQLµÄÎÊÌ⣬¼±£¡
SQL2000Á¬½ÓMySQL£¬´úÂëÈçÏ£º
-- 2¡¢½¨Á¢Á´½ÓÊý¾Ý¿â
EXEC sp_addlinkedserver @server = 'MySQLTest3 ', @srvproduct= 'MySQL ', @provider = 'MSDASQL', @datasrc = 'myTest2 '
GO
EXEC sp_addlinkedsrvlogin @rmtsrvname= 'MySQLTest3 ',@useself= 'false ',@locallogin= 'sa ',@rmtuser= 'root ',@rmtpassword= '952713 '
-- 3¡¢²éѯÊý¾Ý
SELECT * from OPENQUERY (MySQLTest3 , 'select * from apu_table ' )
ÒѾÔÚÊý¾ÝÔ´ODBCÖн¨Á¢ÏµÍ³DSN£¬²âÊԳɹ¦¡£
ÎÊÌâ1£ºÖ´ÐÐÉÏÃæÓï¾ä£¬Ìáʾ£ºÎ´ÄÜÕÒµ½ OLE DB Ìṩ³ÌÐò 'MSDASQL' µÄ×¢²á±íÏî¡£
ÎÊÌâ2£º×îºóÖ´ÐÐsp_dropserver @server = 'MySQLTest3'£¬Ìáʾ£ºÈÔÓзþÎñÆ÷ 'MySQLTest3' µÄÔ¶³ÌµÇ¼¡£
Çë¸÷λ´óϺ¾ÈÃü£¡
http://hi.baidu.com/lengpiao/blog/item/368a30642a8b16faf6365452.html
===
¿´¿´£¡
http://topic.csdn.net/u/20090610/19/69e9480b-3d30-404a-8aaf-f0014b3fc55c.html
End_rbody_60780599//-->
¸Ã»Ø¸´ÓÚ2009-10-30 09:11:37±»¹ÜÀíԱɾ³ý
¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[0]
ÒýÓÃ
¾Ù±¨
¹ÜÀí
TOP
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿ÎÒÖ¸µÄÊÇfor´¥·¢Æ÷£¬ÄÇÆäËûµÄÄØ£¿£¿
ʲôÒâ˼£¿
¿ÉÒÔµÄ
10¸ö¶¼Ã»ÎÊÌâ
¿ÉÊÇÎÒдÁËÁ½¸öfor insert ´¥·¢Æ÷£¬Ôì³É½ø³Ì×èÈûÁËÄØ£¿Ôõô°ìÄØ£¿Çë¸ßÈËÖ¸µã
......
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
Õâ¸öÊÓÆµ½²µÄºÜÏêϸ, ¶ÔÐÂÊַdz£ÓÐÓÃ, »ù±¾ÉÏÒ»¿´¾Í¶®
ÓÉÓÚÌ«´óÁË(50m, ÎÒÖ»ÄÜÉÏ´«20m), ÎÒÉÏ´«²»ÁË, Ö»ºÃÌù³öÏÂÔØµØÖ·
ÏÂÔØµØÖ·: http://ftel1.3800hk.com/0807/080720djxnzj.rar
ºÃ¶«Î÷,ϸö¿´¿´
......
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......