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!

SQLSetConnectAttr failed.

user12210196Jan 28 2010 — edited Jan 29 2010

I get this error when ever I try to report from Excel or Access Database.

The flat file is not accessed by anybody nor its open.

Can I know what exact driver to use for excel and access...
and also if the file is in a remote location in a shared folder what should be the location given? I create the ODBC and change the location in the registry to reflect remote location \\server\folder\file

Whats wrong?

Any help appreciated...

Note: I do not get this error when I have the file in the same box as BI Server...

A general error has occurred. [nQSError: 16001] ODBC error state: IM006 code: 0 message: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed. [nQSError: 16001] ODBC error state: S1000 code: -1032 message: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data

Edited by: user12210196 on Jan 28, 2010 3:14 PM

This post has been answered by 687696 on Jan 28 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 26 2010

Added on Jan 28 2010

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

2 comments

1,918 views