Unable to view tables when connected to database on PB10

[JimBoberoons]

Hi There,

I am a newbie to powerbuilder. I have an SQL Server database, which I connect to from Powerbuilder by first creating a DBProfile and then connecting to the profile.

The problem is when I connect to the profile, and then select tables, it never shows the user tables, just about ten or so tables beginning with spt_*.

Any ideas? I presume its a permissions problem but I dont seem to be able to crack this. I know the tables exist because I can see them from the SQL server query analyser.

thanks,

- Jim.

 

[early105]

Have you gave the Name of Database in the Profile? I should be the name of the DB your defined, it seems it was connected to the master DB.