Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Hyperion 11 oce SQL Server

mjohnJan 31 2017 — edited Feb 2 2017

I'm somewhat new to Hyperion Studio (11.1.2.3.000) and have connected successfully to several SQL Server db's where the collation has been Latin1_General_BIN.  I am wanting to connect to another SQL Server db that is SQL_Latin1_General_CP1_CI_AS collation and having issues with running queries.  The error is "SQL API:[SQLBindCol],SQL RETURN:[-1],SQL STATE:[HY003],SQL NATIVE ERROR:[0],SQL MESSAGE:[[Microsoft]]ODBC Driver Manager]Program type out of range]".  I figured it must be something in how I'm creating the oce file.  Does anyone have any recommendations or what I'm doing wrong?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 2 2017
Added on Jan 31 2017
8 comments
608 views