aspÁ´½ÓsqlÊý¾Ý¿â ´úÂë
dim conn,connstr
Set conn = Server.CreateObject("ADODB.Connection")'´´½¨Ò»¸öÊý¾Ý¿âÁ´½Ó¶ÔÏóconn£¬·½±ãºóÃæµ÷ÓÃ
connstr="Provider=SQLOLEDB;Data Source=(local);Initial Catalog=111;User ID=sa;Password=1234;" '´´½¨Ò»¸öÊý¾Ý¿âµÄrecordset¶ÔÏ󣬷½±ãÒÔºóµ÷ÓÃ
conn.Open connstr'´ò¿ªÊý¾Ý¿â
Ïà¹ØÎĵµ£º
·Ö²¼Ê½²éѯ
OPENROWSET
´ÓExcelÈ¡Êý¾Ý
SELECT * from OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=d:\1.xls',[Sheet1$])
´ÓOracleÈ¡Êý¾Ý
SELECT * from OPENROWSET('MSDAORA.1','NetServiceName ......
ÊÊÓû·¾³
²Ù×÷ϵͳ£ºwindows 2003
Êý¾Ý¿â£ºsql server 2000/sql server 2005
ʹÓÃÁ´½Ó·þÎñÆ÷½øÐÐÔ¶³ÌÊý¾Ý¿â·ÃÎʵÄÇé¿ö
Ò»¡¢ ÎÊÌâÏÖÏó
ÔÚÖ´Ðзֲ¼Ê½ÊÂÎñʱ£¬ÔÚsql server 2005ÏÂÊÕµ½ÈçÏ´íÎó£º
ÏûÏ¢ 7391£¬¼¶±ð 16£¬×´Ì¬ 2£¬¹ý³Ì xxxxx£¬µÚ 16 ÐÐ
ÎÞ·¨Ö´ÐиòÙ×÷£¬ÒòΪÁ´½Ó·þÎñÆ÷ "xxxxx" µÄ OLE DB ·ÃÎÊ½Ó¿Ú " ......
Èçͼ1¡¢2£¬id=1µÄÊý¾ÝÊÇNULL£¬ÆäËûµÄΪ·ÇNULLµÄÊý¾Ý¡£
Ò»°ãÇé¿öÏ£¬»áÓÃÁ½ÖÖ·½·¨£¡
·½·¨1.t-sql£ºinsert into E values(1,'NULL')£¬²åÈëºó£¬ÔÚ´ò¿ª±íµÄÇé¿öÏ¿´µ½µÄ
ÊÇ'NULL'£¨ÎÒÏëÊÇΪÁËÇø·ÖNULL£¬²Å¼ÓµÄÒýºÅ£©£¬µ«ÊDzéѯµÄʱºò²»Ó°Ï죬ÏÔʾµÄÊÇNULL£¬
Èçͼ1¡¢2£¬idΪ6µÄÊý¾Ý¡£
Èç¹ûÒª²åÈë´øµ¥ÒýºÅµÄ'NULL'£¬insert i ......
¡¾SQL¡¿ÐÐÁÐת»»
http://space.itpub.net/519536/viewspace-609167
Ò»¡¢ÁбäÐÐ
1.´´½¨²âÊÔ±ítest£¬²¢³õʼ»¯ÊµÑéÊý¾Ý
sec@ora10g> create table test (name_id varchar2(10), name varchar2(10));
sec@ora10g> insert into test values ('01','Andy1');
sec@ora10g> insert into test values ('01','Andy2'); ......
Ò», °²×° unixODBC
ÏÂÔØ°²×°°ü. ÔÚ RedHat °²×°¹âÅÌÉϾÍÓÐ
unixODBC-2.2.11-1.RHEL4.1.i386.rpm
unixODBC-devel-2.2.11-1.RHEL4.1.i386.rpm
unixODBC-kde-2.2.11-1.RHEL4.1.i386.rpm
°²×°
rpm -Uvh unixODBC-2.2.11-1.RHEL4.1.i386.rpm
rpm -Uvh unixODBC-devel-2.2.11-1.RHEL4.1.i386.rpm
Èç¹û°²×°ÖÐÌáʾÓжÔÆäË ......