<?php
$conn = odbc_connect("DRIVER={Progress OpenEdge 10.1B driver};DSN=progress_read;HOST=192.168.0.59;DB=mfgprod;UID=admin;PWD=123;PORT=9999;");
if($conn)
echo "成功!";
else
echo "失败!";
?>
为什么一直都输出失败?
ProgressçODBC并ä¸æ¯éç¨çï¼éè¦ç¨ä¸é¨çODBCå·¥å ·è½¯ä»¶æ¥è¿æ¥ï¼æ常ç¨çæ¯Merant ODBCï¼æ¤ä»¥Merant3.7æ¥ä»ç»å¦ä½è¿æ¥progressæ°æ®åºï¼ç±äºå¯è½åå¨ä¸åçæä½ç³»ç»ï¼å½ç¶è¿æ¥æ¹å¼æäºä¸å.使ç¨Merant3.7éè¦å¨å®¢æ·ç«¯å®è£ Progressæ°æ®åºæå¯ä»¥.
ããæå¡ç«¯unixï¼å³æ°æ®åºåæ¾å¨unixä¸ï¼ï¼å®¢æ·ç«¯window2000æå¡å¨é ç½®ï¼
ãã1.å¨/etc/servicesé ç½®æ件ä¸æ·»å ä¸è¡å¯å¨odbcç端å£,ä¾å¦ï¼
ããmerant 6000/tcp # merantODBCç端å£
ãã2.å¨éè¦ä½¿ç¨odbcçç¨æ·ç.profileæ件ä¸å¢å åéåè·¯å¾ä¾å¦ï¼
ããDLC=/dlc/91e /*å®è£ çprogressçè·¯å¾*/
ããPROOIBRK=/dlc/91e/bin/_prooibk /*éè¦è°ç¨çç¨åºçè·¯å¾*/PROOIDRV=/dlc/91e/bin/_prooidv /*éè¦è°ç¨çç¨åºçè·¯å¾*/PATH=/dlc/91e/bin:$PATH
ããexport PATH
ããexport DLC
ããexport PROOIBRK
ããexport PROOIDRV
ãã3.æ§è¡å¯å¨odbcçå½ä»¤
ããä¾å¦ï¼
ãã/dlc/91e/bin/_prooibk -SV -S merant /*æ ¹æ®progresså®è£ çç®å½ä¸åä¼ä¸åï¼merantæ¯servicesä¸å¢å ç端å£å称ï¼ä¸¤è¾¹å¯ä»¥é便åååä½å¿ é¡»ä¸æ ·*/客æ·ç«¯é ç½®ï¼
ãã1.åæå¡ç«¯é ç½®ä¸æ ·éè¦å¨C:WINNTsystem32driversetcçservicesæ件ä¸å¢å ä¸è¡ä¾å¦ï¼
ããmerant 6000/tcp # merantODBCç端å£
ãã2.å¨ç³»ç»æ§å¶å°å¢å ç¯å¢åéï¼å»ºè®®å¢å ç³»ç»çç¯å¢åéï¼æ ¹æ®å®¢æ·ç«¯progresså®è£ çç®å½ä¸åï¼å¯è½ææä¸åDLC c:dlc The directory where you installed the Progress client piecesIDLC c:dlc Required only for 8.1 or higher clientsPROMSGS c:dlcpromsgs The directory and name of the message fileIPROMSGS c:dlcpromsgs Required only for 8.1 or higher clientsPATH c:dlcbin;c:dlc;c:winNTsystem32;%path% Example for Windows NTTEMP c:temp
ãã3.å¨odbcæ°æ®æºä¸ä½å¦ä¸é ç½®:
ããgeneralï¼
ããdata source name:èªå·±åå
ããdescription:é便
ããdatabase name:æ°æ®åºçåå
ããuser idï¼ä¸å¡«
ããoid/oib options:
ããprotocol:tcp
ããservice name:å¨servicesæ件ä¸å çmerantodbcç端å£å称host nameï¼æå¡å¨çå称æipï¼å»ºè®®ç¨ipï¼å¦åè¿è¦å¨hostsæ件ä¸å 解æï¼database options:
ããdatabase access mode:via server
ããprotocol:tcp
ããservice name:å¯å¨æ°æ®åºç端å£åï¼æ¯å¨æå¡ç«¯å¯å¨æ°æ®åºæå¡ç端å£åä¹æ¯å¨æå¡ç«¯çservicesæ件ä¸ï¼host name:å¯å¨æ°æ®åºæå¡çæºå¨åæipï¼æ¨èipï¼å®æååºè¯¥å¯ä»¥è¿æ¥ä¸äº
追é®æçODBCæ¯å·²ç»å»ºç«å¥½äºçï¼å¹¶ä¸æµè¯è¿æ¥æåçï¼ç¨ACCESSæ°æ®åºé½å¯ä»¥ç´æ¥è°ç¨ï¼ä¸æå¾æ¯ä¸æ¯ODBCè¿æ¥å符串çé®é¢ï¼