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

ÔÚlinuxÉÏÅäÖÃunixODBCºÍFreeTDS·ÃÎÊMS SQL Server


Ò», °²×° 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
Èç¹û°²×°ÖÐÌáʾÓÐ¶ÔÆäËü°²×°°üµÄÒÀÀµ,Ôò°´ÕÕÌáʾÏȰ²×°
ÄÄЩ°ü.
»òÕß´ÓÔ´Âë°²×° unixODBC
ÏÂÔØÔ´Â뼯
unixODBC-2.2.11.tar.gz
# tar xzf unixODBC-2.2.11.tar.gz
# cd unixODBC-2.2.11
# ./configure
# make
# make install
./configure µÄʱºòÒ²ÓпÉÄÜÌáʾÕÒ²»µ½Ä³Ð©ÒÀÀµ¿â.
ÏÂÔØÕâЩÒÀÀµ¿âµÄÔ´Âë,±àÒë,°²×°.
rpm °²×°ºÍÔ´Âë±àÒë°²×°µÄ²î±ðÔÚÓÚÅäÖÃÎļþ odbc.ini, odbcinst.ini
µÄλÖò»Í¬. ǰÕßΪ /etc , ºóÕßΪ /usr/local/etc
¶þ, °²×° FreeTDS
unixODBC ÌṩÁËLinux ¶ÔODBC µÄÖ§³Ö,µ«ËüÖ»ÊÇÒ»¸ö ODBCµÄ¹ÜÀíÆ÷, ÒªÁ¬½Ó
ʵ¼ÊµÄÊý¾Ý¿â»¹µÃÌṩÕâÖÖÊý¾Ý¿âµÄ ODBC Çý¶¯.
FreeTDS¾ÍÊÇLinux Ï ÓÃÓÚÁ¬½ÓMS SQL Server ºÍ Sybase µÄÃâ·ÑODBC Çý¶¯
×¢Òâ, ±ØÐëÏÈ×° unixODBC, ÔÙ×° freetds
freetds-0.64 ÊÇĿǰµÄ×îÐÂÎȶ¨°æ.
ÏÂÔØÔ´Âë°ü freetds-stable.tgz
# tar xzf freetds-stable.tgz
# ./configure --with-unixodbc=/usr/local --with-tdsver=8.0
# make
# su
# make install
½«°²×°µ½ /usr/local ÏÂ
Èç¹û unixODBCÊÇÔ´Âë°²×°, Ôò
--with-unixodbc=/usr/local
Èç¹û unixODBCÊÇrpm°²×°, Ôò
²»ÐèÒª¸ÃÑ¡Ïî
Èý, ÅäÖà unixODBC ºÍ FreeTDS
3.1 ÏòunixODBC µÇ¼Ç FreeTDS Çý¶¯
    ÐÞ¸Ä /etc/odbcinst.ini (»òÕß/usr/local/etc/odbcinst.ini)
    ÔÚÎļþÖÐÌí¼Ó
=========================== /etc/odbcinst.ini  ======================
# Driver from FreeTDS package
# setup from FreeTDS package
[FREETDS]
Description     = ODBC of FreeTDS for MS SQL 2000
Driver          = /usr/local/lib/libtdsodbc.so
Setup           = /usr/local/lib/libtds.so
FileUsage       = 1
===================================================================
3.2  ÔÚ FreeTDS µÄÅäÖÃÎļþÖÐÌí¼ÓÖ¸Ïò¾ßÌåÊý¾Ý¿âµÄ·ÃÎÊÐ


Ïà¹ØÎĵµ£º

sql server 2005 µ¼³öÓû§±íÊý¾Ý×Öµä(×ªÔØ)

-----------------------------------------------------
--×÷ÓãºÓÃÓÚsql server 2005 µ¼³öÓû§±íÊý¾Ý×Öµä
--1 ĬÈϵ¼³öµ±Ç°Êý¾Ý¿âÖÐËùÓÐÓû§±í(xtype = 'u')µÄÊý¾Ý×ֵ䣻
--2 ¿ÉÒÔÔÚxtype = 'u'Ìæ»»ÎªÈçÏÂËùʾÓï¾äxtype = 'u' and name in ('son','Person') µ¼³ö×Ô¶¨ÒåµÄ±íµÄÊý¾Ý×ֵ䣻
--3 ¿ÉÒÔÀûÓü¯³É·þÎñSSISµ¼³ ......

sql server·Ö²¼Ê½ÊÂÎñ½â¾ö·½°¸

ÊÊÓû·¾³
²Ù×÷ϵͳ£ºwindows 2003
Êý¾Ý¿â£ºsql server 2000/sql server 2005
ʹÓÃÁ´½Ó·þÎñÆ÷½øÐÐÔ¶³ÌÊý¾Ý¿â·ÃÎʵÄÇé¿ö
Ò»¡¢  ÎÊÌâÏÖÏó
ÔÚÖ´Ðзֲ¼Ê½ÊÂÎñʱ£¬ÔÚsql server 2005ÏÂÊÕµ½ÈçÏ´íÎó£º
ÏûÏ¢ 7391£¬¼¶±ð 16£¬×´Ì¬ 2£¬¹ý³Ì xxxxx£¬µÚ 16 ÐÐ
ÎÞ·¨Ö´ÐиòÙ×÷£¬ÒòΪÁ´½Ó·þÎñÆ÷ "xxxxx" µÄ OLE DB ·ÃÎÊ½Ó¿Ú " ......

SQL »ñȡϵͳÎļþ

--»ñµÃµ±Ç°ËùÓÐÇý¶¯Æ÷
exec master.dbo.xp_availablemedia
--»ñµÃ×ÓĿ¼Áбí
exec master.dbo.xp_subdirs 'c:\'
--»ñµÃËùÓÐ×ÓĿ¼µÄĿ¼Ê÷½á¹¹
exec master.dbo.xp_dirtree 'c:\'
--¶©ÔÄÎļþɾ³ý
declare @tempTable table (Cont varchar(50))
declare @strTemp varchar(50)
declare @dirPath varchar(50)
declar ......

SQL ¶à±íÁªºÏ²éѯ

ºÜÉÙÓÃjoin£¬Õâ´Îѧѧ£¬²¢±¸ÍüÁ½ÆªÎÄÕ£¡
ת×Ô£ºhttp://hcx-2008.javaeye.com/blog/285661
Á¬½Ó²éѯ
ͨ¹ýÁ¬½ÓÔËËã·û¿ÉÒÔʵÏÖ¶à¸ö±í²éѯ¡£Á¬½ÓÊǹØÏµÊý¾Ý¿âÄ£Ð͵ÄÖ÷ÒªÌØµã£¬Ò²ÊÇËüÇø±ðÓÚÆäËüÀàÐÍÊý¾Ý¿â¹ÜÀíϵͳµÄÒ»¸ö±êÖ¾¡£
ÔÚ¹ØÏµÊý¾Ý¿â¹ÜÀíϵͳÖУ¬±í½¨Á¢Ê±¸÷Êý¾ÝÖ®¼äµÄ¹ØÏµ²»±ØÈ·¶¨£¬³£°ÑÒ»¸öʵÌåµÄËùÓÐÐÅÏ¢´æ·ÅÔÚÒ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ