For help with installation, bugs reports or feature requests, please head over to our new forums.
Genuitec Community on GitHub
- This topic has 8 replies, 3 voices, and was last updated 21 years, 11 months ago by
.
-
Posts
-
I have managed to get a connection via jTDS to a SQL Server 2000 server but the database _name_ is being ignored – I always get a list of ALL the databases under the open connection node, is this the correct behaviour?
The URL I use is ‘jdbc:jtds:sqlserver://servername/fred’, I know with some RDBMS systems you have to add ‘;database=fred’ to the server name but the docs for jTDS do not show this?
Thanks
Chris Parsons
Chris,
I’m not sure about jTDS but with the SQL Server driver from MS you do need to specify the database name as arguments in the URL… have you tried this?Yes, I believe the MS argument is ‘;databasename=fred’ but this doesn’t make any diffference – using the database name at the end of the URL works for a Java program, it’s just the database explorer that ignores it?
Cheers
Chris
Jeez I am sorry for such a long delay, let me check with the DB guy. I must have never sent him an email about this. (I have no SQL server to test this with so I’m really in the dark).
I suspect that it is like MySQL and does not support schemas, just catalogs, and the DatabaseMetaData.getCatalogs() call returns all available databases. You will have to live with it for only a few more days. ME 3.8.2 will allow you to specify only the schemas/catalogs/databases you wish to see.
Well,, I eagerly downloaded and installed 3.8.2 but alas this still does not resolve the above problem *sigh*
I can specify the schema, namely ‘dbo’ and when I connect as a user with restricted database ownership the database list is also restricted – yahoo!
But try and open a table – as soon as you click the table link the + symbol vanishes and no tables are listed 🙁
You can specify ALL schemas and it works but this is the same behaviour as before!
Chris
