客户端在不安装oracle client的前提下，如何连接远程oracle server ？需要什么文件呢？

我的想知道如何配置客户端的软件环境来完成和oracle server 的通讯，
比如client 环境如下：win98或者winxp，其他软件什么都没有安装
软件开发环境是delphi＋oracle9i＋ado连接，请问这样的c/s程序在客户端需要怎样来配置软件环境呢？

解决方案 »

  1.   

    delphi 可以用ODAC，不装ORACLE客户端
    但是需要OCI.dll
    并且有BUG
      

  2.   

    to  nebulaly(极高明而道中庸) ：谢谢。再问，除此之外还有没有其他方法？
      

  3.   

    还有？楼主这些还不够吗
    1。ado、odbc都连接必须安装客户端
    2。java可以用jdbc
    3。c++builder和delphi可以用odac
    其他的没有了
    除非你自己写socket。
      

  4.   

    多谢各位指点。我有下面这样的连接想法，不知道是否可行，望指点：做个multitier－>remote data module 程序，在这个程序中有adoconnection、datasetprovider、adoquery,adostoreproc等组件， 暂时命名他为OraConnServer.exe在客户端就用DCOMConnect进行连接这个程序，这样的话，在客户端是不是就不用安装oracle client，也不用ODAC，不知道这样的想法是否正确。也就是说，在运行OraConnServer.exe的机器上安装连接oracle client即可，而不用把oracle client 安装到各个客户端。
      

  5.   

    DELPHI中ODAC4.0以上版本可以不要装client,指定IP就可以
      

  6.   

    to 52768361(涵清V3.0) ：
      多谢指点。
    我的意思是，把程序分发给用户时，用户的client端连ODAC也不安装，连接的任务全部交给appserver程序来搞定，也就是说在安装appserver的机器上应该安装oracle client，这样的想法是否对呢？
      

  7.   

    简单的程序设计问题
    client只负责数据的简单处理和网络传输在服务端完成数据的suid
      

  8.   

    我的意思是，把程序分发给用户时，用户的client端连ODAC也不安装，连接的任务全部交给appserver程序来搞定，也就是说在安装appserver的机器上应该安装oracle client，这样的想法是否对呢？
    [回复]
    基本正确。对比一下Web Server就知道了。
    其实，你可以做一个Oracle的客户端 的。
      

  9.   

    to iihero(阿黑哥)：
      多谢黑哥！自己做哥客户端，我还没这个信心，不知道黑哥是否已经完成这个自己的oracle 客户端呢？有的话说说思路，有代码那就更好了。：）
      

  10.   

    to vipxch：
    　　不客气。我说的做客户端的意思，不是写程序实现。而是从Oracle安装文件中提取一些文件，组合成客户端程序包。尽管Oracle公司不主张那样做，也不支持。但是确实是可行的。
    　　我一般很少直接去安装客户端，那样安装完以后文件夹容量大得惊人，可能有600多M，但是提取一些有用文件，Oracle9i里，也就10多M吧。
    　　至于方法，你能上http://youngcow.net吗？里边有几个已经做好的客户端包，你可以下载试用一下。youngcow是smth上的老版主，大拿级的人物。
    　　我的blog上也有：http://ehero.mblogger.cn　随笔里的数据库技术中有一篇简要的说明了如何做。可以参考一下。
      

  11.   

    what cause you to do this?????
      

  12.   

    to iihero(阿黑哥) ：感谢的不行了，呵呵to koskinen(因果关系)：我说的很清楚，意思是：把程序部署到客户端时，不安装oracle的client程序。
      

  13.   

    ===我备份的文件列表，从服务器获得
     F:\ORA81客户端发布 的目录2004-07-15  13:17       <DIR>          .
    2004-07-15  13:17       <DIR>          ..
    2004-07-15  13:17       <DIR>          BIN
    2004-07-15  13:17       <DIR>          network
    2004-07-15  13:17       <DIR>          ocommon
    2004-07-15  13:17       <DIR>          oracore
    2004-07-15  13:17       <DIR>          sqlplus
                   2 个文件          4,537 字节
                   7 个目录 21,490,073,600 可用字节
     F:\ORA81客户端发布\bin 的目录2004-07-15  13:17       <DIR>          .
    2004-07-15  13:17       <DIR>          ..
    1999-12-21  17:04               57,344 com81.dll
    1999-12-20  08:51              138,940 COREJAVA.DLL
    1999-08-30  14:22               68,608 debmp.dll
    1999-08-30  14:22              201,216 demet.dll
    1999-08-30  14:22               67,072 exgdsf.dll
    1999-08-30  14:22              231,424 exhtml.dll
    1999-12-02  12:12              163,877 irpc.dll
    1999-08-30  14:22            1,215,488 isgdi32.dll
    1999-07-21  07:36               40,448 JNLSLib3.dll
    1999-07-21  07:36               30,720 JNLSTool.dll
    1999-08-30  14:22              105,472 ltscsn10.dll
    1999-08-30  14:22            1,567,232 lwpapin.dll
    1999-12-02  12:14            1,654,822 nav32.dll
    2000-01-25  17:54              146,432 njssl8.dll
    2000-01-21  13:26              557,056 nmi.dll
    1999-12-02  12:15              581,671 nvbase.dll
    1999-12-02  12:17               81,960 nvdbdbc.dll
    2000-02-10  17:57               94,248 nvdbole.dll
    2000-01-25  18:28               89,088 oci.dll
    2000-02-12  23:17               37,136 ocijdbc8.dll
    2000-02-07  12:03               20,992 OCIW32.DLL
    2000-02-17  17:05              659,456 oip8.dll
    2000-02-16  14:42               24,576 oraansi.dll
    2000-01-25  18:02                9,216 OracleAdNetConnectRCUS.dll
    2000-01-26  19:40                9,728 OracleAdNetConnectRCZHS.dll
    2000-01-25  18:03                9,728 OracleAdNetTestRCUS.dll
    2000-01-26  19:40               10,240 OracleAdNetTestRCZHS.dll
    2000-02-10  15:46              998,160 oraclient8.dll
    2000-02-02  09:01              225,280 oraclm32.dll
    2000-02-07  17:33              397,072 oracommon8.dll
    2004-04-06  09:00              519,440 ORACORE8.DLL
    2000-02-05  18:12            1,176,336 oractxx8.dll
    2000-01-09  09:14               66,320 ORADBICX8.DLL
    1998-08-26  00:12                7,680 ORAEVRUS8.DLL
    2000-01-25  17:40            1,155,344 orageneric8.dll
    2000-02-19  12:28            3,327,760 ORAJOX8.DLL
    2000-02-02  09:27               99,600 oraldapclnt8.dll
    2000-02-23  14:35              658,192 oran8.dll
    2000-01-25  18:01              299,176 oranad8.dll
    2000-01-25  17:56               16,656 oranbeq8.dll
    2000-01-25  17:57                4,880 ORANCDS8.DLL
    2004-04-06  09:12               48,912 orancrypt8.dll
    2000-01-25  17:56               48,912 ORANCRYPT8E.DLL
    2000-01-25  17:57                5,392 oranent8.dll
    2000-02-23  14:35                7,440 oranhost8.dll
    2000-01-25  17:56               17,680 oranipc8.dll
    2000-01-25  18:04              127,488 oranjni8.dll
    2000-01-25  17:56              187,152 ORANK58.DLL
    2000-02-23  14:35              163,088 oranl8.dll
    2000-01-25  17:57               47,376 oranldap8.dll
    2000-01-25  18:04               11,776 oranldapj8.dll
    1999-11-29  22:24              277,264 ORANLS8.DLL
    2000-01-25  17:57               28,432 ORANLU628.DLL
    2000-02-23  14:35               16,656 orannds8.dll
    2000-02-23  14:35               17,680 orannmp8.dll
    2000-02-03  13:00              101,376 orannms8.dll
    2000-02-23  14:35               10,512 orannss8.dll
    2004-04-06  09:00               39,696 orannts8.dll
    2000-02-02  14:33              373,008 orannzsbb8.dll
    2000-02-23  14:35                7,952 oranoname8.dll
    2000-01-25  18:05               39,424 oranoncj8.dll
    2000-01-25  17:56               30,992 ORANRAD8.DLL
    2000-02-21  19:14              210,704 oranro8.dll
    2000-02-23  14:35               26,896 oransgr8.dll
    2000-01-25  17:56               39,696 ORANSID8.DLL
    2000-02-23  14:35               33,040 orantcp8.dll
    2000-02-02  14:33               32,016 ORANTCPS8.DLL
    2000-02-23  14:35                7,952 orantns8.dll
    2000-01-31  17:54              327,680 OraOLEDB.dll
    2000-01-31  17:54               45,056 oraoledbgmr.dll
    2000-01-31  17:54               32,768 OraOLEDBPUS.dll
    2000-01-31  17:54               24,576 OraOLEDBrfc.dll
    2000-01-31  17:54               24,576 OraOLEDBrmc.dll
    2000-01-31  17:54              110,592 OraOLEDBrst.dll
    2000-01-31  17:54               24,576 OraOLEDBus.dll
    2000-01-31  17:54               24,576 OraOLEDButl.dll
    2000-01-14  12:07               24,576 OraOLEDBzhs.dll
    2000-02-03  14:01              275,216 oraordim8.dll
    2000-02-10  14:12              118,544 oraordvir8.dll
    2000-01-03  15:58               45,328 ORAPLC8.DLL
    1999-12-22  13:55              542,480 ORAPLP8.DLL
    2000-01-03  15:58            2,196,752 ORAPLS8.DLL
    2000-01-25  18:29                3,072 ORAPRTOP8.DLL
    2000-02-23  14:41               77,072 ORAQSMASHR.DLL
    1999-11-15  14:56               14,096 ORASLAX8.dll
    2000-01-25  18:29                8,192 ORASPAWN.DLL
    2000-01-12  15:40              446,736 ORASQL8.DLL
    2000-01-28  07:33              249,104 ORATRACE8.DLL
    2000-01-25  17:40                5,392 oravsn8.dll
    2000-01-25  17:40                6,928 orawtc8.dll
    2000-01-19  15:43               33,280 owasmus.dll
    1999-08-11  12:10              136,192 owasmzhs.dll
    2000-01-19  15:49               32,768 owastsvr.dll
    2000-01-19  16:21              723,968 owastus.dll
    1999-08-11  12:10              723,968 owastzhs.dll
    2000-01-25  18:07              237,568 owm2.dll
    1999-08-30  14:22              119,268 sccch.dll
    1999-08-30  14:22               18,432 sccda.dll
    1999-08-30  14:22              226,304 sccdu.dll
    1999-08-30  14:22               29,696 sccex.dll
      

  14.   

    1999-08-30  14:22              108,544 sccfa.dll
    1999-08-30  14:22              166,400 sccfi.dll
    1999-08-30  14:23               80,384 scclo.dll
    1999-08-30  14:23               41,472 sccole2.dll
    1999-08-30  14:23              140,288 sccut.dll
    2000-01-21  13:17                7,680 snmidl.dll
    2000-02-03  13:10                3,072 snmimsg.dll
    1998-09-14  09:51                3,584 snmimsgd.dll
    1998-09-14  09:51                4,096 snmimsgf.dll
    2000-01-27  05:32              409,600 SQORA32.dll
    2000-01-17  09:20               28,672 SQORAS32.dll
    2000-01-17  09:20               61,440 sqresus.dll
    2000-02-03  11:14               65,024 svpxos.dll
    2004-04-06  09:12              353,792 tcl75.dll
    1999-12-16  17:28              177,152 vbj30ssl.dll
    1999-12-16  17:29            1,281,536 vbjruntime.dll
    2000-02-03  14:39               65,536 vdbjdbcext.dll
    2000-02-03  14:37               53,248 vdg.dll
    2004-04-06  09:12              393,728 vppdc.dll
    2000-02-03  11:14               60,928 vpsqlsrv.dll
    2000-02-03  11:28              539,648 vpxoafnd.dll
    2000-02-03  11:26              305,152 vpxodb.dll
    1999-08-30  14:23               22,528 vsacs.dll
    1999-08-30  14:23               79,360 vsami.dll
    1999-08-30  14:23               11,776 vsbdr.dll
    1999-08-30  14:23               16,384 vsbmp.dll
    1999-08-30  14:23               40,448 vscgm.dll
    1999-08-30  14:23               12,288 vsdbs.dll
    1999-08-30  14:23               15,360 vsdez.dll
    1999-08-30  14:23               38,400 vsdif.dll
    1999-08-30  14:23               19,968 vsdrw.dll
    1999-08-30  14:23               15,872 vsdx.dll
    1999-08-30  14:23               59,904 vsdxf.dll
    1999-08-30  14:23               20,480 vsemf.dll
    1999-08-30  14:23               16,384 vsen4.dll
    1999-08-30  14:23               14,336 vsens.dll
    1999-08-30  14:23               14,848 vsenw.dll
    1999-08-30  14:23              160,768 vseshr.dll
    1999-08-30  14:23               30,208 vsexe2.dll
    1999-08-30  14:23               11,776 vsfax.dll
    1999-08-30  14:23               13,312 vsfcd.dll
    1999-08-30  14:23               16,896 vsfcs.dll
    1999-08-30  14:23               14,848 vsfft.dll
    1999-08-30  14:23              117,760 vsflw.dll
    2004-04-06  09:14               23,552 vsfwk.dll
    1999-08-30  14:23              117,248 vsgdsf.dll
    1999-08-30  14:23               12,800 vsgif.dll
    1999-08-30  14:23               41,984 vsgzip.dll
    1999-08-30  14:23               32,768 vshgs.dll
    1999-08-30  14:23               88,576 vshtml.dll
    1999-08-30  14:23              125,952 vsich.dll
    1999-08-30  14:23               11,264 vsimg.dll
    1999-08-30  14:23               13,824 vsiwp.dll
    1999-08-30  14:23               15,872 vsjw.dll
    1999-08-30  14:23               20,992 vsleg.dll
    1999-08-30  14:23              119,296 vslwp.dll
    1999-08-30  14:23               48,128 vslzh.dll
    1999-08-30  14:23               15,360 vsm11.dll
    1999-08-30  14:23               22,016 vsmanu.dll
    1999-08-30  14:23               22,016 vsmcw.dll
    1999-08-30  14:24               18,944 vsmm.dll
    1999-08-30  14:24               20,480 vsmm4.dll
    1999-08-30  14:24               15,360 vsmmfn.dll
    1999-08-30  14:24               14,848 vsmp.dll
    1999-08-30  14:24               26,112 vsmsw.dll
    1999-08-30  14:24               11,264 vsmwkd.dll
    1999-08-30  14:24               10,752 vsmwks.dll
    1999-08-30  14:24               30,208 vsmwp2.dll
    1999-08-30  14:24               17,920 vsmwpf.dll
    1999-08-30  14:24               12,800 vsmwrk.dll
    1999-08-30  14:24               11,264 vsow.dll
    1999-08-30  14:24               10,752 vspbm.dll
    1999-08-30  14:24                9,216 vspcl.dll
    1999-08-30  14:24               12,800 vspcx.dll
    1999-08-30  14:24               13,824 vspdx.dll
    1999-08-30  14:24               23,552 vspfs.dll
    1999-08-30  14:24               90,112 vspgl.dll
    1999-08-30  14:24               10,752 vspic.dll
    1999-08-30  14:24               17,920 vspict.dll
    1999-08-30  14:24               29,184 vspng.dll
    1999-08-30  14:24                9,216 vspntg.dll
    1999-08-30  14:24               41,472 vspp2.dll
    1999-08-30  14:24               45,568 vspp7.dll
    1999-08-30  14:24              169,984 vspp97.dll
    1999-08-30  14:24               19,968 vsppl.dll
    1999-08-30  14:24              108,544 vspsp.dll
    1999-08-30  14:24               14,336 vsqa.dll
    1999-08-30  14:24               44,544 vsqad.dll
    2004-04-06  09:14               53,248 vsqp6.dll
    1999-08-30  14:24               33,792 vsras.dll
    1999-08-30  14:24               16,384 vsrbs.dll
    1999-08-30  14:24               19,968 vsrft.dll
    1999-08-30  14:24               13,312 vsrfx.dll
    1999-08-30  14:24              116,736 vsrtf.dll
    1999-08-30  14:24               13,312 vssam.dll
    1999-08-30  14:24               16,384 vssc5.dll
    1999-08-30  14:24               15,360 vssdw.dll
    1999-08-30  14:24               12,800 vsshw3.dll
    1999-08-30  14:24               12,288 vssmd.dll
    1999-08-30  14:24               12,800 vssms.dll
    1999-08-30  14:24               43,008 vssmt.dll
    1999-08-30  14:25               13,824 vssnap.dll
    1999-08-30  14:25               40,448 vsspt.dll
    1999-08-30  14:25               56,320 vstaz.dll
    1999-08-30  14:25               25,088 vstext.dll
    1999-08-30  14:25               12,288 vstga.dll
    1999-08-30  14:25               47,616 vstif6.dll
    1999-08-30  14:25               45,056 vstw.dll
    1999-08-30  14:25               21,504 vstxt.dll
    1999-08-30  14:25               36,352 vsvcrd.dll
    1999-08-30  14:25               40,960 vsvw3.dll
    1999-08-30  14:25               88,064 vsw6.dll
    1999-08-30  14:25              101,376 vsw97.dll
    1999-08-30  14:25               77,312 vswg2.dll
    1999-08-30  14:25               96,768 vswk4.dll
    1999-08-30  14:25              122,368 vswk6.dll
    1999-08-30  14:25               28,160 vswks.dll
    1999-08-30  14:25               13,824 vswm.dll
    1999-08-30  14:25               22,528 vswmf.dll
    1999-08-30  14:25               63,488 vsword.dll
    1999-08-30  14:25               18,944 vswork.dll
    1999-08-30  14:25               50,688 vswp5.dll
    1999-08-30  14:25               62,464 vswp6.dll
    1999-08-30  14:25               16,384 vswpf.dll
    1999-08-30  14:25               34,816 vswpg.dll
    1999-08-30  14:25               86,016 vswpg2.dll
    1999-08-30  14:25               19,456 vswpl.dll
    1999-08-30  14:25               41,472 vswpw.dll
    1999-08-30  14:25               20,480 vsws.dll
    1999-08-30  14:25               14,848 vsws2.dll
    1999-08-30  14:25              173,568 vsxl5.dll
    1999-08-30  14:25               21,504 vsxy.dll
    2004-04-06  09:14               21,504 vszip.dll
    1999-11-17  00:52               28,672 vxxxstacktrace.dll
    2000-02-04  19:19               58,368 WizOSD.dll
    2002-08-09  22:00            4,082,688 qtintf70.dll
    2004-04-06  09:00                   23 oracle.key
    2000-02-09  12:06              481,120 SQLPLUS.EXE
                 238 个文件     38,967,905 字节
                   2 个目录 21,490,073,600 可用字节===========================================================================
    1.上面的文件复制到c:\ora812.\network\ADMIN\tnsnames.ora文件设置（SERVICE_NAME = 服务器的连接）
    ORCL =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
        )
        (CONNECT_DATA =
          (SERVICE_NAME = orcl)
        )
      )3.注册Oracle主目录
    [HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0]
    "ORACLE_HOME"="C:\Ora81"4.注册系统环境变量
    [HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Control\Session Manager\Environment]
    "path"="C:\Ora81 " 
      

  15.   

    to iihero(阿黑哥)：
    这办法,可行,我前段时间试过!