Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 Á¬½Ó²éѯ£¨ÄÚÁ´½Ó ÍâÁ¬½Ó£©


Á¬½Ó²éѯ 
¡¡¡¡Í¨¹ýÁ¬½ÓÔËËã·û¿ÉÒÔʵÏÖ¶à¸ö±í²éѯ¡£Á¬½ÓÊǹØÏµÊý¾Ý¿âÄ£Ð͵ÄÖ÷ÒªÌØµã£¬Ò²ÊÇËüÇø±ðÓÚÆäËüÀàÐÍÊý¾Ý¿â¹ÜÀíϵͳµÄÒ»¸ö±êÖ¾¡£ 
¡¡¡¡ÔÚ¹ØÏµÊý¾Ý¿â¹ÜÀíϵͳÖУ¬±í½¨Á¢Ê±¸÷Êý¾ÝÖ®¼äµÄ¹ØÏµ²»±ØÈ·¶¨£¬³£°ÑÒ»¸öʵÌåµÄËùÓÐÐÅÏ¢´æ·ÅÔÚÒ»¸ö±íÖС£µ±¼ìË÷Êý¾Ýʱ£¬Í¨¹ýÁ¬½Ó²Ù×÷²éѯ³ö´æ·ÅÔÚ¶à¸ö±íÖеIJ»Í¬ÊµÌåµÄ ......

̽ÌÖPHP SQL×¢ÈëµÄ½â¾ö˼·

˼·:SQLÀᄀ¿ÉÄܵIJÉÓÃÁ½¸öÒýºÅ±ÕºÏ±äÁ¿;¶Ô±äÁ¿ÖеÄÒýºÅתÒå;¶Ô²»ÄܲÉÓÃ2¸öÒýºÅ±ÕºÏµÄ±äÁ¿,ÏÈÔ¤ÏÈÅжϱäÁ¿ÀàÐÍ;  
   
  ·½°¸:  
  1   ËùÓзÇÊýÖµÔËËã(Èç×Ö·û,¼òµ¥ÊýÖµÐ͵ȵÈ)µÄSQL±äÁ¿¶¼¼ÓÒýºÅ;  
  2   ËùÓзÇÊýÖµÔËËãµÄSQL±äÁ¿µÄÖµ¶¼²ÉÓÃmagic_quotes_gpc» ......

LinuxѹËõÓë½âѹËõ²ÎÊý˵Ã÷

tarÃüÁ tar [-cxtzjvfpPN] ÎļþÓëĿ¼ ....
# f+ E' `# d' W( {²ÎÊý£º & e( U# Y4 x; c$ b2 O; j/ p
-c £º½¨Á¢Ò»¸öѹËõÎļþµÄ²ÎÊýÖ¸Áî(create µÄÒâ˼)£»
. E' {. v5 ^  \' v3 O5 H, C' @- p& ^-x £º½â¿ªÒ»¸öѹËõÎļþµÄ²ÎÊýÖ¸Á 3 |& u2 z: k( A# ?% c
-t £º²é¿´ tarfile ÀïÃæµÄÎļþ£¡
9 ......

linux socket Ïê½â

Í·Îļþ£ºsys/socket.h
Ïà¹Ø½á¹¹Ì壺
struct sockaddr
{
    unsigned short sa_family;   //µØÖ·×å
    char sa_data[14];   //14×Ö½ÚЭÒ鵨ַ
};
struct sockaddr_in
{
    short int sin_family;   //µØÖ·×å
    u ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ