Showing posts with label vs2005. Show all posts
Showing posts with label vs2005. Show all posts

Monday, March 26, 2012

ODBC datasource wont work on report server!!

Hi,

I have VS2005 and sql server express and ive created some reports using sql server
as a backend. everything works as it should.

THEN...

i created a report that uses a system DSN odbc source and it works in VS2005 it works fine.
i have deployed it to the report server and the datasource appears t be there, but when i try and run the report i ge the following message

  • An error has occurred during report processing.
  • An attempt has been made to use a data extension 'ODBC' that is not registered for this report server.anyone got any ideas how i can make this work? i have tried to find an explanation using google, but i cannot seem to see any thing that answers the question.

    Regards,

    Russ
    Express versions of Reporting Services allow for data sources to only be local and must be a matching SKU of SQL Server.

  • Wednesday, March 21, 2012

    ODBC Connection Failure

    I am having a problem getting the ODBC driver to connect.

    I just installed VS2005 and can't connect to my SQL2000 server. It is there. I can't connect using either one of the mix mode authentication.

    I can login to SQL from another pc when logged in with this user name. It has to be something on this pc blocking it.

    Iam not rying to do this from a ASP web page just trying to setup a ODBC driver and I get these errors.

    I get the error:" Login failed for user (null)" Not associated with a trusted connection

    Thanks

    Mike

    I downloaded and installed manager studio and I can see the server in the network tab but still can't connect. I get the error 11001

    Any Ideas?

    Thanks

    |||

    Let's see your connection string. I would also read: http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html

    |||

    This link was broken for a while and I could not reply.

    William,

    Little background. I have had this application up and running since Oct 05 with the connection string on several different pc's.

    There is no problem with the connection string.

    I recently had difficulty on two new PC, one laptop and one desktop. Neither could access SQL2000 running on another PC. Both could run the application and connection string locally if I copied the DB down to express. This application is a smart client app not an ASP app.

    Both instances had newly installed VS2005 and SQL Express installed on them.

    I could not even set up a DSN using ODBC manager. It would not connect to the SQL 2000 server.

    When I tried using SQL Mgr Studio Express, it could see the SQL 2000 server but not connect to it.

    I always got some kind of connection error.

    Thanks.