Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

connecting to SQL from different domain

Posted on 2011-10-25
5
Medium Priority
?
253 Views
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....

 tables
0
Comment
Question by:epicazo
  • 3
  • 2
5 Comments
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 37026334
When you configure the ODBC connection, you define what database you will be attaching to.
0
 

Author Comment

by:epicazo
ID: 37026372
yes....  REPORTDB
0
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 37026406
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.
0
 

Accepted Solution

by:
epicazo earned 0 total points
ID: 37034569
I am not able to see and the account REPORTDB_USR does have permission to ReportDB databsase.
0
 

Author Closing Comment

by:epicazo
ID: 37166477
Never resolved
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
Viewers will learn how the fundamental information of how to create a table.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

572 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