本来以为可能是因为8i与9i的版本差异导致的,因此我就将本机的8i_oo4o改装为9i的了,在本机运行正常,不管是通过odbc,ole还是oracle object for ole都可以正常连接,但是只要将程序放到服务器上就不行,用odbc,ole时提示打开数据库时出错,用oo4o时提示不能创建orasession对象,说是创建时没有权限被拒,请问有哪位知道,该如何解决呀!,服务器上有装和客户机一样的9i的客户端程序
呵呵,看了下面的代码,估计要oralce跟微软打官司了!
我看你还是用oracle8.0.*的客户端吧
Microsoft is in the process of testing Oracle 9i client software on Microsoft Windows XP. Microsoft recommends using Oracle 8.1.7 client software, with the latest patches, because it is known to be a stable build. This client version is able to connect to Oracle 8i and 9i servers; however, the current Microsoft OLEDB Provider and ODBC Driver do not recognize the newer functionality and data types available in Oracle 8i and 9i. If you require Oracle 9i functionality and decide to use the Oracle 9i client, note that Microsoft has not tested this configuration and that you may encounter problems.