Language

Home>Knowledge Base>Root>Campaign CSi>ReportSmith v3.10 gives "Unable to load database access DLL" when connecting to Oracle

Forgot Login?

User Login

Username
Password
	Remember Me
	Login

Information

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

Actions

Print this Page

Add Favorite

Share With Others

	del.icio.us
	Digg
	Facebook
	MySpace
	Reddit
	Twitter
	Yahoo Bookmarks

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.