![]() |
PerkinElmer Informatics Support Forum | ![]() |
Topic Title: Spotfire Database DataSource for Oracle Topic Summary: Datasource Connection error Created On: 10/14/2014 3:48 PM Status Post and Reply |
Linear : Threading : Single : Branch |
![]()
|
![]() |
|
Hi all, I try to open a oracle connection like this: DatabaseDataSourceSettings dbSettings = new DatabaseDataSourceSettings( But I receive always an error: {"Failed to execute data source query."} Inner Exception: {"User input is need"}
Any advice is welcome. Thank in advance. |
|
|
|
![]() |
|
dbSettings.SqlStatement = "select * from v$version";
|
|
|
|
![]() |
|
The first thing we should check is if the driver are installed correctly. Have you used the Oracle database directly in Spotfire before? If you go to Edit > Data Connection Properties > Add New. Is Oracle grayed out or is it available? If it is grayed out you have to download the Oracle Data Provider for .NET for 32-bit and 64-bit ODAC respectively. You can find it here: http://www.oracle.com/technetwork/topics/dotnet/downloads/index.html There is some indication that this might also work. The setting prameter "sqlnet.ora" (ORACLE HOME\NETWORK\ADMIN directory) for the database. Find setting "sqlnet.authentication_services" and change it to (none). If you already have the oracle client installed then please make sure sqlplus works and the connection through spotfire will also work then.
|
|
|
|
![]() |
FuseTalk Basic Edition v4.0 - © 1999-2021 FuseTalk Inc. All rights reserved.