Post reply

Missing DSN Name in ODBC Connection on Server for SSRS Report

  • April 18, 2011 at 11:14 pm

    #235806

    Hi All,

    Need some help.

    a. When using Excel 2007 as data base for SSRS report I am able to generate and run SSRS report properly on Microsoft Visual Studio (on my pc)

    b. But when I deploy the report and data source on SSRS report server it asks for DSN name (here I get stuck)

    i. If I give full dsn path it says DSN name too long (dsn also on server in same folder)

    ii. Doesn't recognize the file if no address is given (even though dsn and datasource file are in same folder on report server)

    iii. If I remove DSN it says “Cant find datasource name and default driver not specified” (without DSN in connection string it is working fine on my PC)

    Thanks in Advance!

  • April 18, 2011 at 11:38 pm

    #1313176

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1095408-391-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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