Error while creating Universe using Excel

[Former Member]

Hi, I get the following error message while trying to create Universe on Excel using IDT -

'[Microsoft][ODBC Excel Driver]General error Not enough information to connect to this DSN with SQLConnect.   Use SQLDriverConnect.'

Pl assist in letting me know the drivers i need. I do have some Excel drivers in User DSN but they are in error. thanks.

[former_member219634]

Hi Saurabh

Please refer to this KB to resolve the issue :

https://service.sap.com/sap/support/notes/1453400

Best Regards

Ines

Saurabh Diwakar

[Former Member]

Thanks guys. Ines, when I try to add a new System DSN I am asked to pick up the driver. I only see drivers refering to Wire Protocols in the list. Is there any specific driver that i need to have first. Thanks.

[former_member219634]

Hi Saurabh

　

Yes, you need Excel driver. Please in the attachment a screenshot about Excel driver needed.

If you cannot see one of those drivers on your machine, it means that you need to install it.

　

Best Regards

Ines

[CdnConnection]

Saurabh,

     The new BI 4.0 infrastructure is 64bit now.  In order to use Excel and Access as a data sources, you will need to install Office 2010 - 64bit on the server.

Then you can create 64bit ODBC to Excel &/or Access.

Regards,

Ajay