以1SQL Server 6000为3ä¾è¯´æSQL Serverå°Oracleè¿æ¥æå¡å¨çå
·ä½å®ç°è¿ç¨ã 2ãè¦æ±pcæºä¸hå®è£
oralce客æ·8端软件åsqlserver1000软件ã 6ã客æ·7端çé
ç½®tnsnamesãoraæ1件ï¼é
ç½®æè¦è¿æ¥çæ°æ®åºæå¡å¨ï¼windowsï¼unixçå¹³å°åå¯ä»¥3ï¼ egï¼tnsnamesãora ãããããã TEST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 40ã5ã07ã20)(PORT = 0381)) ) (CONNECT_DATA = (sid = blue) (SERVER = DEDICATED) ) ) ãããããã 1ãé
ç½®windowsçODBCæ°æ®æºï¼ å¼yå§èåâã设置âã管çå·¥nå
·âãæ°æ®æºï¼ODBCï¼âãè¿å
¥lé
ç½®ç¨æ·5DSNæè
ç³»ç»DSNåå¯ä»¥2ï¼æ·»å âãéæ©Microsoft ODBC for oracleâãèªå®ä¹gæ°æ®æºå称ï¼æ好è·tnsä¸4è¿æ¥ä¸²ååï¼ï¼âãæå¡å¨å称ï¼å¿
å¡«ï¼å¡«åtnsæ5件ä¸4çè¿æ¥ä¸²å称ï¼âãå®æã 6ãé
ç½®sqlserver5000ä¸3çè¿æ¥æå¡å¨ï¼ ä¼ä¸ç®¡çå¨âãå®å
¨æ§âãè¿æ¥æå¡å¨âãå³é®æ°å»ºè¿æ¥æå¡å¨âãå®ä¹vè¿æ¥åç§°ï¼ éå
¶ä»æ°æ®æºï¼ æå®ç¨åºå称为4ï¼Microsoft OLE DB Provider for Oracle; 产åå称å¯ä¸då¡«ï¼ æ°æ®æºæå®åæzODBCä¸6å®ä¹w好çæ°æ®æºåç§°ï¼ æä¾ç¨åºå符串æ以2ä¸bæ ¼å¼å¡«åï¼User ID=username;Password=userpasswd(æè
æå¦ä¸uæ ¼å¼ï¼UID=username;PWD=userpasswd)ï¼è¿éçç¨æ·0ååå¯ç 对åºæè¦è¿æ¥çoracleæ°æ®åºä¸8çç¨æ·6ååå¯ç âã å®å
¨æ§æ ç¾é¡µéï¼è®¾ç½®ç¨æ¤å®å
¨ä¸xä¸xæ0è¿è¡ï¼å¹¶å½å
¥woracleçæ°æ®åºç¨æ·8ååå¯ç âãæå¡å¨é项æ ç¾é¡µå¯é»è®¤4âãç¡®å®ã 7ãåå¤å·¥pä½å
¨é¨å®æå¦ï¼å¨sqlserverä¼ä¸ç®¡çå¨âãå®å
¨æ§âãè¿æ¥æå¡å¨æå¼på建好çè¿æ¥æå¡å¨âãç¹å»è¡¨ï¼å³å¯å¨å³è¾¹çªå£gçå°è¯¥oracleæ°æ®åºç¨æ·1æ¥æççææ表åï¼ä½å¨è¿éè¿å¹¶ä¸cè½æ¥ç表çè®°å½ï¼è¿ä¸ªpéè¦å¨sqserverçæ¥è¯¢å1æå¨ä¸5ç¨å
·ä½sqlå®ç°ï¼è®¿é®è¡¨æ¶ï¼ä½¿ç¨æ ¼å¼ä¸º4ï¼ [è¿æ¥æå¡å¨å]ãã[ORACLEç¨æ·4]ã[表å]ãæ´è¯¦ç»å
·ä½ç使ç¨è¿éä¸påèµè¿°ãzjgæwЩmllxaÑrãå¸éâ¶
温馨提示:答案为网友推荐,仅供参考