cancel
Showing results for 
Search instead for 
Did you mean: 

IDT Data Foundation Error

Former Member
0 Kudos

Hi,

I am trying to create a universe in IDT and I am receiving  an error when trying to insert a table.  Everything created successfully upon inserting a table.  The error is "[Microsoft][ODBC SQL SERVER Driver][SQL SERVER]The cursor was not declared".  I tried researching on the web but nothing pop up. Have anyone ever ran across this problem? Any help is appreciated. I have attach a screen shot below.

Thanks

Hung

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Hung,

Did you solve this problem?

I have the same. I can connect to MS SQL from UDT, but I get the same error from IDT.

Regards,

Anton.

ketan_patel
Discoverer
0 Kudos

Hi Hung and Anton,

I am encounting the same issue in BO IDT but works fine in UDT.

Please share the solution/ideas to resolve this issue.

Appericiate and thanks in advance,

~Ketan

CdnConnection
Active Contributor
0 Kudos

Hung,

     Did you make sure the ODBC driver installed is 64-bit and using the SQL Native 2005 or higher.   Did you try testing the ODBC driver using Universe designer as well to make sure ODBC driver is working properly.

If the client is installed on the same machine, you will need to create 32-bit and 64-bit ODBC with the same DSN name.

Regards,

Ajay

Former Member
0 Kudos

Hi Ajay,

Thanks for the reply. 32 bit and 64 bit ODBC work fine in Universe designer, but when I use Information Designer Tool I have an error. Same error happen when I try to  convert a universe from Universe designer to IDT.

I am using SAP BO BI Platform 4.0 SP4 Patch 7

Former Member
0 Kudos

Hi,

The user does not have the appropriate rights to the SQL database.

Check the rights for the user to the Company Database.

Former Member
0 Kudos

Hi Ravi,

Thanks for the reply. If the user did not have the appropriate rights to the SQL database which is SQL Server, wouldn't I get the same error in the Universe Design Tool like the Information Design Tool? I can see and insert table in the UDT but I can not in IDT.  The database I connecting to is located on a different server.