ReportSmith v3.10 gives "Unable to load database access DLL" when connecting to Oracle

Customer Support

Language

Home

Knowledge Base

Campaign CSi

ReportSmith v3.10 gives "Unable to load database access DLL" when connecting to Oracle

Information

Article ID	167
Created On	3/6/2009
Modified	3/6/2009

Actions

Print this Page

Add to Favorites

Share With Others

	del.icio.us
	Digg
	FaceBook
	Reddit

ReportSmith v3.10 gives "Unable to load database access DLL" when connecting to Oracle

This problem can usually be resolved by editing the RS_SQLIF.INI file as follows:

[Oracle]
;LD=ORAWE850
ORACLEDLL=c:\oracle\bin\ociw32.dll
SynonymSupport=1
QualifySynonymsWithOwners=0
HasOwners=1
SQLHasOwners=0
SQLHasDatabases=0

Make sure that the OracleDLL setting has the correct path. Depending on how Oracle was installed, you may need to change this setting.

The default location of the RS_SQLIF.INI file is in the C:\Windows directory.