#518 Can't see data in content tab or row count tab

2.5
closed-fixed
Core (462)
5
2007-05-12
2007-05-11
Anonymous
No

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@gmail.com> wrote:
> On 5/10/07, Dale Bronk <dbronk@windscape.com> 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
>

Discussion

  • Rob Manning

    Rob Manning - 2007-05-12

    Logged In: YES
    user_id=1287991
    Originator: NO

    Fixed in CVS. We were ignoring the identifier quote string when querying the table for MS SQLServer and Sybase.

    Rob

     
  • Rob Manning

    Rob Manning - 2007-05-12
    • labels: 779786 --> Core
    • milestone: --> 2.5
    • assigned_to: nobody --> manningr
    • status: open --> closed-fixed
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks