LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: joygupta

Hi I am getting following error while connecting DBquery to my Oracle DB, which i am able to access properly from access or Toad..

"Unable to load symbol 'OCINlsEnvironmentVariableGet': The specified procedure could not be found."

I have oracle client 8 and 9 both. Please help.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: timonk

Good Day,

While the forums are an excellent place to look for answers to "how do I do this" type questions and other helpful tips and techniques, if you encounter an apparent problem with the software or its use, the appropriate (and best) place to look for support is the

DesktopSupport@mda-data.com

Support email list. MDA's support staff will recieve it and begin a triage of your issue.

Regards,
Timon Koufopoulos
MDA Support.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: joygupta

This issue has been resolved:

Few areas to check and steps to follow:
1. Check the registry value for NLS_LANG in your system, should match the character set in your DB.
2. Install Oracle client first and then MDA as for reason unknown still, it doesnt recognize Oracle to be on your system if installed after.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: mermacora

			
				2. Install Oracle client first and then MDA as for reason unknown still, it doesnt recognize Oracle to be on your system if installed after.
			

I don't believe this to be true, since I've been able to install/update Lavastorm Desktop and then install/update an Oracle client and get everything to work.
I use the Oracle instant client http://www.oracle.com/technetwork/da...ex-100365.html since I don't need all the stuff in the full blown client and the instant client has a very small disk footprint.
The installation is a simple unzip and all you need to do is ensure that the location of the OCI dll files is included in your PATH environment variable. You may need to restart the BRAIN Server process using the Lavastorm Console so that environment changes are in effect.

Kind regards,
Mario Ermacora
MDA

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

Would this happen to be a Windows 7 installation?

It seems that the Oracle Client on Win7 doesn't like the parenthesis in C:\Program Files (x86)

In one case, we had to install Oracle in a folder such as C:\Oracle to get it to work right.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rboccuzzi

This is not an issue with Windows 7, but rather 64 bit windows. If you have (x86) in your path in our application, the Oracle client does not behave well. This is a known issue, and more information can be found here and here.

Cheers
Rich