Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#21 Databased not displayed in object browsr

closed-fixed
Colin Bell
None
5
2002-07-31
2002-02-20
Anonymous
No

I'm using the i-net opta2000 driver to access
Microsoft SQL Server. Under the 'Database' node in the
object tree, I see all the users for the database.

What I do not see, are any of the databases. They do
show up properly with SQL Query Analyzer (a sql client
that ships with sql server).

Discussion

  • Colin Bell
    Colin Bell
    2002-02-22

    Logged In: YES
    user_id=233132

    SQuirreL works with both the Microsoft and Weblogic JDBC
    drivers so it should't be too hard to get it working with
    the i-net driver.

    If you try to expand one of the user nodes in the object
    tree, what do you see? Are then any nodes below it and if
    so can they be expanded?

    Could you paste the Database MetaData into this bug report.
    To get it just click on the root or top level node (should
    be called database) and then click on the Metadata tab in
    the tabbed folder. Right click in the metadata and
    take "Select All" and then "Copy" from the popup menu and
    paste it in here.

    Thanks
    Col

     
  • Colin Bell
    Colin Bell
    2002-02-22

    • assigned_to: nobody --> colbell
     
  • Colin Bell
    Colin Bell
    2002-07-31

    Logged In: YES
    user_id=233132

    The next version of SQuirreL (1.1beta6) has a rewritten
    object tree. For MSSQL this now shows the catalogs
    (databases in MSSQL parlance) and for each catalog the
    schemas (owner in MSSQL). This should address your problem.

    Col

     
  • Colin Bell
    Colin Bell
    2002-07-31

    • status: open --> closed-fixed