Hi
I am trying to connect to Osisoft PI through Oledb but get "Index was outside the bounds of the array" message that prevents me from making the connection. I'm using the 32-bit Report designer and 32-bit oledb on 64-bit Windows.
Any ideas? Is there any way I can get more details about the error?
I am trying to connect to Osisoft PI through Oledb but get "Index was outside the bounds of the array" message that prevents me from making the connection. I'm using the 32-bit Report designer and 32-bit oledb on 64-bit Windows.
Any ideas? Is there any way I can get more details about the error?
4 Answers, 1 is accepted
0
Hinata
Top achievements
Rank 1
Rank 1
answered on 04 Feb 2015, 04:18 PM
Hi Magnus,
Can you share the whole select statement?
Also check if it is specific to this select statement text, or the error is shown regardless of what you write in the select statement box.
Can you share the whole select statement?
Also check if it is specific to this select statement text, or the error is shown regardless of what you write in the select statement box.
0
Magnus
Top achievements
Rank 1
Rank 1
answered on 04 Feb 2015, 07:30 PM
Thanks for your reply, Hardik.
It is regardless of what I write. The exact same statement works in an other Reporting tool.
It is regardless of what I write. The exact same statement works in an other Reporting tool.
0
Hinata
Top achievements
Rank 1
Rank 1
answered on 09 Feb 2015, 01:02 PM
Hi Magnus,
Can you describe some way or steps to test this?
Note that eventually support for OLE DB will be dropped: Microsoft is Aligning with ODBC for Native Relational Data Access.
The article also mentions that ODBC is better than OLE DB, so you might want to try that as well in order to get the work done.
Can you describe some way or steps to test this?
Note that eventually support for OLE DB will be dropped: Microsoft is Aligning with ODBC for Native Relational Data Access.
The article also mentions that ODBC is better than OLE DB, so you might want to try that as well in order to get the work done.
0
Paul
Top achievements
Rank 1
Rank 1
answered on 11 Jan 2016, 06:45 PM
PI-ODBC sql and configuration can be very touchy. I am working on a similar task. Can you share your <ConnectionString> entry made for the PI instance?