Re: Can't see table contents

Yes, this looks like a bug.  If you create a database in MS SQL-Server
called pop-dev,
and try to execute the following query it fails:

SELECT * FROM pop-dev.dbo.mytab

We reference the table incorrectly by not quoting the catalog as in:

SELECT * FROM "pop-dev".dbo.mytab

Can you write a bug report here (if you login you will get
notification when the bug is fixed/closed)

Rob

On 5/10/07, Robert Manning <robert.m.manning@xxxxxxxxx> wrote:
> On 5/10/07, Dale Bronk <dbronk@xxxxxxxxxxxxx> wrote:
> >
> >
> >
> >
> > Hello…
> >
> >
> >
> > I just downloaded SQuirreL 2.5 and installed.  I can connect to my MS SQL
> > database just fine using the sourceforge jTDS jdbc driver.  My problem is
> > that when I select my table for the left pane and then select either
> > contents or row count tabs I see nothing but a gray blank tab content.  It
> > doesn't even show a blank row.  If I jump over to the sql tab I can enter
> > select, insert, update statements and they all process just fine and allow
> > me to view the contents so I don't believe it is anything to do with rights
> > of the user.  Please advise.
> >
>
> Sorry - just noticed the rest of the thread.  Will take a look and get
> back to you.
>
> Rob
>

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/