Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can't see Tables in SqlServer 2008 in PB

Status
Not open for further replies.

Kongsjs

Programmer
Jul 20, 2007
17
NO
Hi

We have startet to user SqlServer 2008, and when I connect to a database I can see views, Stored Procedures, but not the Tables. I use normaly PB 7.0.3 and have the problem there. I tried PB 10.5 aswell, but same problem there.
I use normal ODBC in PB and Microsoft SqlServer ODBC as the driver (installed from MS Sqlserver 2000). I have not SqlServer 2008 installed on my PC (and should not have that either, it is installed on a server in the network).

Anyone that know what I'm doing wrong or can help me in any way ?

Regards
Kongsjs
 
Even though you don't see the tables, can you do a select succesfully?

Try to specify the "powerbuilder catalog owner" and "table owner" in the connection profile (system tab). Try to connect with the userid that created the tables also...

hope it helps.

regards,
Miguel L.
 
additional:

you probably do see the 'views' because they've been created using the user you connect with from your profile.
You'll probably have to connect as 'dbo' or 'dba' ... If not wrong: tables are create within a certain SCHEME. Simply check you table definitions and "whereabouts" using a tool from sqlserver to find out. It might also be a matter of GRANT for the user you are using.

regards,
Miguel L.
 
It could be a new security 'feature' added by MS to SQL2008.

Matt

"Nature forges everything on the anvil of time
 
Hi

Found a solution on this problem.
We made the user I use "dbo", then it worked.

I tried "powerbuilder catalog owner" and "table owner", but that did'nt work.
The 'views' was not created with the user I use.

Thanks for all suggestions :)

Regards
Kongsjs
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top