connecting to SQL from different domain

Posted on 2011-10-25
Last Modified: 2012-05-12
I am trying to connect to a database via odbc but for some reason it doesn't redirect me to the RERPORTDB database.

I get these tables....

Question by:epicazo
    LVL 39

    Expert Comment

    When you configure the ODBC connection, you define what database you will be attaching to.

    Author Comment

    yes....  REPORTDB
    LVL 39

    Expert Comment

    Information_Schema is the schema name for a lot of special objects, if you scroll down you should still see the objects in whatever schema your objects are in that you have permission to.

    Accepted Solution

    I am not able to see and the account REPORTDB_USR does have permission to ReportDB databsase.

    Author Closing Comment

    Never resolved

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now