Can't see Tables in SqlServer 2008 in PB

[Kongsjs]

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

 

[miguelleeuwe]

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.

 

[miguelleeuwe]

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.

 

[miguelleeuwe]

at last: the user might be case sensitive!

regards,
Miguel L.

 

[mbalent]

It could be a new security 'feature' added by MS to SQL2008.

Matt

"Nature forges everything on the anvil of time

 

[Kongsjs]

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