在asp.net中直接调用oracle数据库,pull拉式水晶报表常见问题
1 oarcle客户端配置,设置数据库服务器监听端口
例如(18客户端)上配置:
D:\app\oms\product\11.2.0\client_1\Network\Admin\tnsnames.ora
inmind =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.224.32)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = inmind.fls)
)
)
配置好,可以供水晶报表,VS2010使用,以及PL/Sql等使用
2 crdb_oracle.dll调用失败
1) Search for crdb_oracle.dll. «C:\Program Files\Common Files\Business Objects\3.0\bin», if installed XI Crystal
or «C:\Program Files\Common Files\Crystal Decisions\2.0\bin», if Crystal 9?
2)Copy to «C:\Program Files\Common Files\Business Objects\2.7\Bin» (I think for Crystal 10)
3)Reload solution.
1 oarcle客户端配置,设置数据库服务器监听端口
例如(18客户端)上配置:
D:\app\oms\product\11.2.0\client_1\Network\Admin\tnsnames.ora
inmind =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.224.32)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = inmind.fls)
)
)
配置好,可以供水晶报表,VS2010使用,以及PL/Sql等使用
2 crdb_oracle.dll调用失败
1) Search for crdb_oracle.dll. «C:\Program Files\Common Files\Business Objects\3.0\bin», if installed XI Crystal
or «C:\Program Files\Common Files\Crystal Decisions\2.0\bin», if Crystal 9?
2)Copy to «C:\Program Files\Common Files\Business Objects\2.7\Bin» (I think for Crystal 10)
3)Reload solution.