oracle½¨¶à¸ödblink

ÓÃtg4mssqlÁ´½Óoracle.
¹ý³Ì²»ÔÚÃèÊö£¬googleºÜ¶à¡£
ÎÊÌ⣺
1¡¢mssql expressµÄʱºò£¬Ê§°Ü
½«serverÓÃתÒå×Ö·ûд³ö£¬³É¹¦¡£
HS_FDS_CONNECT_INFO="SERVER=SHAM0415\\SQLEXPRESS;DATABASE=GMT_KJ"
2¡¢½¨¶à¸öµÄʱºò£¬²»ÄܽâÎö¡£ tnsping ÃüÁî×ܲ»Í¨¹ý¡£
ÕÒÁ˺ܶ࣬ͬһ¸öÌû×Ó£¬×ªÁËÎÞÊý´Î¡£¡£
°¦¡£¡£ÖйúµÄ¼¼Êõ°¡¡£¡£
×Ô¼ºÑо¿£¬×îºó·¢ÏÖ
MSSQL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    (CONNECT_DATA =
        (SID = MSSQL))
        (HS= OK)
  )
MSSQLÒª¶¥¸ñд£¬Ç°Ãæ²»ÔÊÐíÓпոñ¡£
²éÁËһϣ¬³ýÁ¬½Ó´®Ãû×Ö£¨È磺MSSQL£©Í⣬ÆäËûÐУ¨Ã¿Ò»ÐУ©Ê×Ó¦¸ÃÓпոñ(space)¡£
(HS= OK) ²»¿Éȱ¡£
תһ¸öÀý×Ó£º
oracle.net.config.ServiceAliasException:10
´ð£º
ÕâÊÇÓÉÓÚtnsnames.oraÎļþ¸ñʽ²»¶Ô£¬
ӦעÒâ³ýÁ¬½Ó´®Ãû×Ö£¨È磺BCV£©Í⣬ÆäËûÐУ¨Ã¿Ò»ÐУ©Ê×Ó¦¸ÃÓпոñ(space)¡£
¸½¼þ£º
°Ñtnsnames.oraÎļþÖеÄ
BCV=
(space)[ (DESCRIPTION_LIST = # Optional depending on whether u have
(space)# one or more descriptions
(space)# If there is just one description, unnecessary ]
(space)(DESCRIPTION=
(space)[ (SDU=2048) ] # Optional, defaults to 2048
(space)# Can take values between 512 and 32K
(space)[ (ADDRESS_LIST= # Optional depending on whether u have
(space)# one or more addresses
(space)# If there is just one address, unnecessary ]
(space)(ADDRESS=
(space)[ (COMMUNITY=) ]
(space)(PROTOCOL=tcp)
(space)(HOST=)
(space)(PORT=)
(space))
(space)[ (ADDRESS=
(space)(PROTOCOL=ipc)
(space)(KEY=)
(space))
(space)]
(space)[ (ADDRESS=
(space)[ (COMMUNITY=) ]
(space)(PROTOCOL=decnet)
(space)(NODE=)
(space)(OBJECT=)
(space))
(space)]
(space)... # More addresses
(space)[ ) ] # Optional depending on whether ADDRESS_LIST is used or not
(space)[ (CONNECT_DATA=
(space)(SID=)
(space)[ (GLOBAL_NAME=) ]
(space))
(space)]
(space)[ (SOURCE_ROUTE=yes) ]
(space))
(space)(DESCRIPTION=
(space)[ (SDU=2048) ] # Optional, defaults to 2048
(space)# Can