PerkinElmer Informatics Support Forum
Decrease font size
Increase font size
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
Topic Tools Topic Tools
View topic in raw text format. Print this topic.
 10/14/2014 3:48 PM
User is offline View Users Profile Print this message


Kinetics

Posts: 1
Joined: 10/14/2014

Hi all, I try to open a oracle connection like this:

DatabaseDataSourceSettings dbSettings = new DatabaseDataSourceSettings(
"System.Data.OracleClient",
"Data Source= jdbc:tibcosoftwareincracle:@rw-pc:1521:XE;user=Spotfire;pwd=Spotfire", String.Empty);

dbSettings.SqlStatement = "select * from v$version";
DatabaseDataSource ds = new DatabaseDataSource(dbSettings);
this.app.Open(ds);

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.

FuseTalk Basic Edition v4.0 - © 1999-2017 FuseTalk Inc. All rights reserved.