Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     ODBC Create Synonym Missing Tables

Read-Only Read-Only Topic
Go
Search
Notify
Tools
ODBC Create Synonym Missing Tables
 Login/Join
 
George Brown
Gold member
posted
I have created an ODBC Adapter to an MS SQL Server Database. I have verified that the userid and password are correct.

When I go to create Synonym with both the "tables" and "views" checkboxes checked, I only get a subset of tables/views to which I have "select" access.

Example, when I connect directly to that database via odbc on my pc with the same userid and password I have select access to over 100 more tables than those that appear on the list from which to choose on the metadata screen.

I have the system admin of that datasource looking into any differences on the two tables.

Any suggestions?


George D. Brown
Loyola University Chicago
gbrown2@luc.edu
 
Posts: 77 | Location: Chicago, IL | Registered: May 06, 2004Report This Post
Qalqili
Platinum Member
posted Hide Post
hi George

you can Create MS SQL SERVER adapter rather than using ODBC from:
Server Web Console-->Adapter-->
New Adapter-->SQL-->choose MSSQLSERVER

from that adapter you can create Connnection and spicify your meta data

hope that help


WF 7.7.0.3HF3 / WinXP- WF-Client & Apache / DevStd 7.7.0.3HF3 win XP.
 
Posts: 118 | Registered: February 08, 2006Report This Post
<JG>
posted
George,

Are all your tables actually in the same MSSQL database.

Two access tables from multiple databases you must create an ODBC entry in the ODBC admin tool for each of them.
e.g. Northwind and pubs and set up a WebFocus adapter entry for each.

With regard using the MSSQL adapter. This will allow you to see all databases and associated
tables/views for a particular MSSQL server. HOWEVER as with most IB adapters it is not free and must be licensed.

If you have it available using the native adapter is far superior to using ODBC.
 
Report This Post
Kerry
Expert
posted Hide Post
FYI,

This issue has been resolved on George's site ... the issue was nothing to do with webfocus but rather a miss-communication between the DBA and the person configuring the ODBC adapter on the OS level.

The DBA never told us the "default database" needed for our connection.

It should be noted that even though the security for that userid had access to the tables the id could not see those tables until that database was selected as the default database. It would have been thought that the id would have seen the tables regardless but with some prefix like schemaname.tablename.


Thanks a lot for sharing, George. Big Grin

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
 
Posts: 1948 | Location: New York | Registered: November 16, 2004Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     ODBC Create Synonym Missing Tables

Copyright © 1996-2020 Information Builders