Post reply

Permissions Problem I Think...

  • May 10, 2007 at 6:36 am

    #371225

    I have a report with an Excel data source - ODBC connection. The Excel worksheet is on my desktop. In VS.Net, it works great. I deploy it to the report manager, go to report manager from my desktop, it fails, with this error...

    • An error has occurred during report processing. (rsProcessingAborted) Get Online Help

      • Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection) Get Online Help

        • ERROR [HY000] [Microsoft][ODBC Excel 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. ERROR [01S00] [Microsoft][ODBC Excel Driver]Invalid connection string attribute Trusted_Connection ERROR [01S00] [Microsoft][ODBC Excel Driver]Invalid connection string attribute Trusted_Connection ERROR [01S00] [Microsoft][ODBC Excel Driver]Invalid connection string attribute Trusted_Connection ERROR [01S00] [Microsoft][ODBC Excel Driver]Invalid connection string attribute Trusted_Connection ERROR [01S00] [Microsoft][ODBC Excel Driver]Invalid connection string attribute Trusted_Connection ERROR [01S00] [Microsoft][ODBC Excel Driver]Invalid connection string attribute Trusted_Connection ERROR [01S00] [Microsoft][ODBC Excel Driver]Invalid connection string attribute Trusted_Connection ERROR [01S00] [Microsoft][ODBC Excel Driver]Invalid connection string attribute Trusted_Connection ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [01S00] [Microsoft][ODBC Excel Driver]Invalid connection string attribute Trusted_Connection ERROR [01S00] [Microsoft][ODBC Excel Driver]Invalid connection string attribute Trusted_Connection ERROR [01S00] [Microsoft][ODBC Excel Driver]Invalid connection string attribute Trusted_Connection ERROR [01S00] [Microsoft][ODBC Excel Driver]Invalid connection string attribute Trusted_Connection ERROR [01S00] [Microsoft][ODBC Excel Driver]Invalid connection string attribute Trusted_Connection ERROR [01S00] [Microsoft][ODBC Excel Driver]Invalid connection string attribute Trusted_Connection ERROR [01S00] [Microsoft][ODBC Excel Driver]Invalid connection string attribute Trusted_Connection ERROR [01S00] [Microsoft][ODBC Excel Driver]Invalid connection string attribute Trusted_Connection ERROR [HY000] [Microsoft][ODBC Excel 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.

    But what is weird, if I go to the report server box, go to the report manager, and run the report, it works fine. I have an ODBC connection on the report server box, with a network drive to my desktop, pointing the Excel data source. I am not sure what is going on. Any help would be appreciated, I was suppose to have this report done yesterday.

    Thanks In Advanced,

    Kerrie

  • May 10, 2007 at 9:56 am

    #705550

    Make sure you don't have it open while trying to run the report...

    Cheers,

    Ben Sullins
    bensullins.com
    Beer is my primary key...

  • May 10, 2007 at 10:32 am

    #705569

    I got it now...ID10T error! LOL

    Thanks for all of your help, I really appreciate it!!!

    I'll see you online...have a good day,

    Kerrie

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply