Oracle database connection string PLSQL compatibility

Question

I'm using an application called Logi info. it requires a connection string to my oracle database. the connection works fine but in order to configure the connection to recive ref cursors from the database, I apparently need to add PLSQLRSet=1 to the end of the string. when I do that I recieve an error "invalid connection string"

Here is my connection string without plsqlrset=1

Data Source=SID; User Id=username; Password=password;

My concern is that PLSQLRSet=1 might be .NET paramater only. Can anyone shed some light on the issue.

Thanks

how do you want to connect to the dabase? jdbc,..?

bert
– bert

2011-01-07 12:52:53 +00:00
Commented Jan 7, 2011 at 12:52 — bert
– bert, Commented Jan 7, 2011 at 12:52

Dave Costa · Accepted Answer · 2011-01-07 15:14:56Z

3

It appears that the PLSQLRset option is a feature of the OraOLEDB provider (per http://download.oracle.com/docs/cd/B10501_01/win.920/a95498/using.htm).

Therefore I would guess that you have to add Provider=OraOLEDB.Oracle to the connect string -- as shown in the screenshot on the page you linked to -- in order to use this option.

answered Jan 7, 2011 at 15:14

Dave Costa

48.3k8 gold badges61 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Oracle database connection string PLSQL compatibility

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related