You can subscribe to this list here.
| 2001 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(7) |
Dec
(4) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2002 |
Jan
(9) |
Feb
(4) |
Mar
(20) |
Apr
(10) |
May
(5) |
Jun
(2) |
Jul
(10) |
Aug
(4) |
Sep
(15) |
Oct
(5) |
Nov
(8) |
Dec
(2) |
| 2003 |
Jan
(11) |
Feb
(5) |
Mar
(10) |
Apr
(20) |
May
(24) |
Jun
(13) |
Jul
(6) |
Aug
(5) |
Sep
(10) |
Oct
(10) |
Nov
(9) |
Dec
(7) |
| 2004 |
Jan
(4) |
Feb
(10) |
Mar
(5) |
Apr
(18) |
May
(18) |
Jun
(14) |
Jul
(24) |
Aug
(14) |
Sep
(6) |
Oct
(18) |
Nov
(5) |
Dec
(3) |
| 2005 |
Jan
(5) |
Feb
(1) |
Mar
(5) |
Apr
(10) |
May
(10) |
Jun
(16) |
Jul
(46) |
Aug
(36) |
Sep
(16) |
Oct
(11) |
Nov
(12) |
Dec
(29) |
| 2006 |
Jan
(33) |
Feb
(45) |
Mar
(42) |
Apr
(23) |
May
(23) |
Jun
(21) |
Jul
(19) |
Aug
(23) |
Sep
(17) |
Oct
(50) |
Nov
(74) |
Dec
(44) |
| 2007 |
Jan
(35) |
Feb
(18) |
Mar
(46) |
Apr
(25) |
May
(26) |
Jun
(24) |
Jul
(33) |
Aug
(4) |
Sep
(41) |
Oct
(43) |
Nov
(23) |
Dec
(42) |
| 2008 |
Jan
(26) |
Feb
(20) |
Mar
(21) |
Apr
(18) |
May
(28) |
Jun
(32) |
Jul
(25) |
Aug
(28) |
Sep
(27) |
Oct
(34) |
Nov
(16) |
Dec
(42) |
| 2009 |
Jan
(21) |
Feb
(36) |
Mar
(40) |
Apr
(51) |
May
(27) |
Jun
(13) |
Jul
(38) |
Aug
(40) |
Sep
(5) |
Oct
(14) |
Nov
(4) |
Dec
(7) |
| 2010 |
Jan
(16) |
Feb
(10) |
Mar
(38) |
Apr
(83) |
May
(27) |
Jun
(41) |
Jul
(57) |
Aug
(24) |
Sep
(14) |
Oct
(22) |
Nov
(28) |
Dec
(42) |
| 2011 |
Jan
(52) |
Feb
(13) |
Mar
(41) |
Apr
(14) |
May
(24) |
Jun
(14) |
Jul
(16) |
Aug
(15) |
Sep
(19) |
Oct
(20) |
Nov
(35) |
Dec
(48) |
| 2012 |
Jan
(30) |
Feb
(9) |
Mar
(33) |
Apr
(15) |
May
(13) |
Jun
(13) |
Jul
(57) |
Aug
(20) |
Sep
(18) |
Oct
(29) |
Nov
(28) |
Dec
(9) |
| 2013 |
Jan
(19) |
Feb
(26) |
Mar
(44) |
Apr
(13) |
May
(38) |
Jun
(6) |
Jul
(24) |
Aug
(8) |
Sep
(7) |
Oct
(10) |
Nov
(12) |
Dec
(6) |
| 2014 |
Jan
(13) |
Feb
(6) |
Mar
(41) |
Apr
(5) |
May
(4) |
Jun
(3) |
Jul
(13) |
Aug
(9) |
Sep
(35) |
Oct
(36) |
Nov
(16) |
Dec
(4) |
| 2015 |
Jan
(6) |
Feb
(4) |
Mar
(7) |
Apr
|
May
|
Jun
|
Jul
(1) |
Aug
(2) |
Sep
(10) |
Oct
(4) |
Nov
(13) |
Dec
(3) |
| 2016 |
Jan
(6) |
Feb
(12) |
Mar
(6) |
Apr
(21) |
May
(9) |
Jun
(16) |
Jul
(13) |
Aug
(13) |
Sep
(11) |
Oct
(9) |
Nov
(20) |
Dec
(18) |
| 2017 |
Jan
(7) |
Feb
(19) |
Mar
(9) |
Apr
(12) |
May
(12) |
Jun
(35) |
Jul
(7) |
Aug
(3) |
Sep
|
Oct
(1) |
Nov
(4) |
Dec
|
| 2018 |
Jan
(4) |
Feb
(1) |
Mar
(3) |
Apr
(8) |
May
(9) |
Jun
(8) |
Jul
(6) |
Aug
(7) |
Sep
(8) |
Oct
(1) |
Nov
(6) |
Dec
|
| 2019 |
Jan
(6) |
Feb
(9) |
Mar
(3) |
Apr
(3) |
May
(4) |
Jun
|
Jul
|
Aug
(4) |
Sep
(3) |
Oct
(3) |
Nov
(3) |
Dec
(1) |
| 2020 |
Jan
(4) |
Feb
(4) |
Mar
(22) |
Apr
(1) |
May
(16) |
Jun
(12) |
Jul
(3) |
Aug
(10) |
Sep
(5) |
Oct
(1) |
Nov
(24) |
Dec
(1) |
| 2021 |
Jan
(2) |
Feb
(10) |
Mar
(9) |
Apr
(7) |
May
(8) |
Jun
(10) |
Jul
(2) |
Aug
|
Sep
|
Oct
|
Nov
(2) |
Dec
|
| 2022 |
Jan
(3) |
Feb
(4) |
Mar
(5) |
Apr
(2) |
May
|
Jun
|
Jul
|
Aug
(6) |
Sep
(1) |
Oct
(2) |
Nov
(2) |
Dec
|
| 2023 |
Jan
(2) |
Feb
(6) |
Mar
|
Apr
|
May
(13) |
Jun
|
Jul
|
Aug
(6) |
Sep
|
Oct
|
Nov
(1) |
Dec
(4) |
| 2024 |
Jan
(3) |
Feb
|
Mar
(5) |
Apr
(1) |
May
(5) |
Jun
(1) |
Jul
(1) |
Aug
|
Sep
|
Oct
(3) |
Nov
(3) |
Dec
|
| 2025 |
Jan
|
Feb
(5) |
Mar
(33) |
Apr
(8) |
May
(10) |
Jun
(7) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Robert R. <rog...@gm...> - 2012-07-25 16:06:24
|
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<font face="Arial">Hi all,<br>
<br>
I have checked the documentation and googled for a solution/advise
but not found any.<br>
<br>
I have just started using Squirrel 3.3.0 with the intention of
replacing iNavigator's Run SQL Scripts. I am accessing DB2 on an
iSeries at V7.1<br>
<br>
The biggest problem I have experienced is it takes over 30 seconds
to return a query. <br>
<br>
The status bar tells me<br>
"Query 1 of 1, Rows read: 100, Elapsed time (seconds) - Total:
45.186, SQL query: 0.577, Building output: 44.609"<br>
<br>
The the query is a simple SELECT * FROM mytable. I have read that
the number of columns returned slows down execution. <br>
<br>
What I'd like to know is there a way of limiting the Building
Output step. One thought was to only return the Results tab not
the MetaData, Info and Overview tabs, but I have been unable to
find how to turn these off.<br>
<br>
Any help would be appreciated. I am impressed with this tool but
if a simple query takes over 39 to return I don't think it will be
of use top me.<br>
<br>
Thanks,<br>
<br>
Robert Rogerson<br>
</font>
</body>
</html>
|
|
From: John H. <jh...@im...> - 2012-07-25 15:32:18
|
On Wed, 25 Jul 2012, leeand00 wrote: > What is a good JDBC driver for accessing SQL Server 2005 with Squirell SQL > 3.3.0? The one you download for free from the MSFT website? -- John Hardin KA7OHZ http://www.impsec.org/~jhardin/ jh...@im... FALaholic #11174 pgpk -a jh...@im... key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 ----------------------------------------------------------------------- Justice is justice, whereas "social justice" is code for one set of rules for the rich, another for the poor; one set for whites, another set for minorities; one set for straight men, another for women and gays. In short, it's the opposite of actual justice. -- Burt Prelutsky ----------------------------------------------------------------------- 11 days until the rover Curiosity lands on Mars |
|
From: leeand00 <lee...@gm...> - 2012-07-25 15:22:58
|
What is a good JDBC driver for accessing SQL Server 2005 with Squirell SQL 3.3.0? Thank you, Andrew J. Leer ----- Thank you, Andrew J. Leer - http://leeand00.tiddlyspot.com/ My Blog -- View this message in context: http://old.nabble.com/Suggestion-for-a-good-JDBC-Driver-for-accessing-SQL-Server-2005-with-Squirrel-SQL--tp34211041p34211041.html Sent from the squirrel-sql-users mailing list archive at Nabble.com. |
|
From: leeand00 <lee...@gm...> - 2012-07-25 15:22:53
|
What is a good JDBC driver for accessing SQL Server 2005 with Squirell SQL 3.3.0? Thank you, Andrew J. Leer ----- Thank you, Andrew J. Leer - http://leeand00.tiddlyspot.com/ My Blog -- View this message in context: http://old.nabble.com/Suggestion-for-a-good-JDBC-Driver-for-accessing-SQL-Server-2005-with-Squirrel-SQL--tp34211040p34211040.html Sent from the squirrel-sql-users mailing list archive at Nabble.com. |
|
From: leeand00 <lee...@gm...> - 2012-07-25 14:46:04
|
Can you suggest a good JDBC driver for accessing a MS-Access 2007 database with Squirrel-SQL? Thank you, Andrew J. Leer ----- Thank you, Andrew J. Leer - http://leeand00.tiddlyspot.com/ My Blog -- View this message in context: http://old.nabble.com/Suggestion-for-a-good-JDBC-Driver-for-accessing-MS-Access-2007-with-SquirrelSQL--tp34210791p34210791.html Sent from the squirrel-sql-users mailing list archive at Nabble.com. |
|
From: Stefan G. <new...@sg...> - 2012-07-24 21:12:27
|
Hi Melinda, did you check if your newly created user is allowed to access the tables in your database? I see the same behavior if the SQL-user I'm using is not allowed to access tables in the database. You will find the rights in the security section of the database. Furtheron I can confirm SQirreL to be capable to connect from my linux box (debian) to SQL-Server 2008R2 installation on our network using SQL Login (but you already solved this one :-) ) Cheers Stefan Am Dienstag, den 24.07.2012, 11:37 -0500 schrieb Savoy, Melinda: > Pardon my ignorance, but I’m not a SQL Server DBA but a Java developer > and consequently here is what I’ve done to date: > > > > 1. I finally fixed the problem whereby I could not get logged in > to the SQL Server DB by going in and creating a local SQL Server user > (msavoy) instead of using the Windows Domain user (wccampus\admin-mxs) > by mapping user msavoy to user wccampus\admin-mxs. The DEFAULT SCHEMA > used for this domain user is: ICS_NET (one of the databases – hope > that is correct) > > 2. The PROBLEM that I now face is that when I open up the > ICS_NET database I do NOT see the tables but the different DATABASE > ROLE MEMBERSHIPS for ICS_NET: > > a. Db_accessadmin > > b. Db_backupoperator > > c. DB_datareader > > d. DB_datawriter > > e. Db_ddladmin > > and then at the bottom of this long list a WCCAMPUS\admin-mxs > > > > I’m not sure what happened to the list of my tables, views, etc., that > are supposed to be listed under the database name. > > > > I hope this makes sense. Any help/direction would be greatly > appreciated. > > > > Regards. > > > > From: Robert Manning [mailto:rob...@gm...] > Sent: Tuesday, July 24, 2012 8:41 AM > To: Savoy, Melinda > Cc: Alexandre Peshansky; squ...@li... > Subject: Re: [Squirrel-sql-users] Problem trying to connect to SQL > Server 2008 R2 box > > > > Oops - should have read the rest of the thread first ;) > > Rob > > On Tue, Jul 24, 2012 at 9:39 AM, Robert Manning > <rob...@gm...> wrote: > > > And the obvious question - have the credentials for user 'admin-mxs' > been added as an account to the SQL-Server instance for SQL-Server > authentication ? > > Rob > > On Mon, Jul 23, 2012 at 1:32 PM, Savoy, Melinda <ms...@wc...> wrote: > > > Thanks for the quick reply. Each server is setup for allowing > both SQL and Windows authentication (mixed mode). > > > > Any other suggestions? > > > > From: Alexandre Peshansky > [mailto:Ale...@ei...] > Sent: Monday, July 23, 2012 12:20 PM > To: Savoy, Melinda > Subject: RE: [Squirrel-sql-users] Problem trying to connect to > SQL Server 2008 R2 box > > > > > Check that these boxes allow login by SQL-Server credentials. > > By default, MS SQL is set to only allow login by Windows > credentials, and won’t accept other forms of login (even if > you present the same user name and password). > > -- > > Alexandre Peshansky, MS > > Senior Bioinformatics Analyst, Research Informatics Core (RIC) > > Einstein-Montefiore Institute for Clinical and Translational > Research (ICTR) > > Albert Einstein College of Medicine > > 1300 Morris Park Ave, Mazer Bldg., Rm 534 > > Bronx, NY 10461 > > (718) 430-2440 (Mo, Th, Fr) (718) 920-4885 (Tu & We) > > Einstein-Monti.GIF > > > > > From: Savoy, Melinda [mailto:ms...@wc...] > Sent: Monday, July 23, 2012 1:01 PM > To: squ...@li... > Subject: [Squirrel-sql-users] Problem trying to connect to SQL > Server 2008 R2 box > Importance: High > > > > > I have downloaded SQuirreL 3.3.0 on my Debian 6 Linux box and > it loaded great. I’m trying to setup my Alias to connect to > the 3 SQL Server 2008 R2 boxes on our network. > > > > I can connect to these boxes remotely from my own SQL Server > 2008 client on my Windows 7 box but when I try to connect to > these SQL Server boxes from my SQuirreL client in Debian I get > the following error: > > > > Golden: Login failed for user 'admin-mxs'. > ClientConnectionId:5dea83e5-3407-4d05-b307-84e826b4436f > > > > I’ve tried entering the username with and without the DOMAIN > NAME\admin-mxs but still get the same error. > > > > Any help/direction would be appreciated. > > > > Regards. > > > > > > ------------------------------------------------------------------------------ > Live Security Virtual Conference > Exclusive live event will cover all the ways today's security > and > threat landscape has changed and how IT managers can respond. > Discussions > will include endpoint security, mobile security and the latest > in malware > threats. > http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > > > > > > > > ------------------------------------------------------------------------------ > Live Security Virtual Conference > Exclusive live event will cover all the ways today's security and > threat landscape has changed and how IT managers can respond. Discussions > will include endpoint security, mobile security and the latest in malware > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
From: Andreas O. <cpt...@gm...> - 2012-07-23 20:25:51
|
Hi Melinda, which JDBC driver do you use? Using the jtds driver /http://jtds.sourceforge.net//worked quite well for me for connecting to a SQL 2005 database. I'll give it a try on a Linux Box at work tomorrow. Take care Anreas Am 23.07.2012 19:46, schrieb Savoy, Melinda: > Hi John. Yes each SQL Server is setup to accept both Windows and SQL authentication (mixed mode). > > I am able to login from my SQL Server 2008 Client via the management studio to each of these boxes. I just can't seem to connect via SQuirreL from my Debian 6 Linux box. > > Thanks. > > -----Original Message----- > From: John Hardin [mailto:jh...@im...] > Sent: Monday, July 23, 2012 12:44 PM > To: Savoy, Melinda > Cc: squ...@li... > Subject: Re: [Squirrel-sql-users] Problem trying to connect to SQL Server 2008 R2 box > > On Mon, 23 Jul 2012, Savoy, Melinda wrote: > >> I have downloaded SQuirreL 3.3.0 on my Debian 6 Linux box and it loaded great. I'm trying to setup my Alias to connect to the 3 SQL Server 2008 R2 boxes on our network. >> >> I can connect to these boxes remotely from my own SQL Server 2008 client on my Windows 7 box but when I try to connect to these SQL Server boxes from my SQuirreL client in Debian I get the following error: >> >> Golden: Login failed for user 'admin-mxs'. >> ClientConnectionId:5dea83e5-3407-4d05-b307-84e826b4436f >> >> I've tried entering the username with and without the DOMAIN NAME\admin-mxs but still get the same error. >> >> Any help/direction would be appreciated. > I can confirm that Squirrel does work with MSSQL2008R2 from W7 x64 using SQL Server logins. I am not sure that Windows Domain logins work. > > Are you able to configure your server to accept SQL Server logins (Mixed mode)? > |
|
From: Gerd W. <ger...@t-...> - 2012-07-23 20:14:24
|
On 23.07.2012 22:00, Savoy, Melinda wrote: > John, > > I have the latest STABLE version 3.3.0. I will try and get the latest snapshot version. Does anyone know when 3.4.0 version is coming out? I may wait for that. > Within the next few weeks. The current snapshot is supposed to be the last one before the release (unless some severe problem is found within the next days). Gerd |
|
From: Savoy, M. <ms...@wc...> - 2012-07-23 20:01:00
|
John, I have the latest STABLE version 3.3.0. I will try and get the latest snapshot version. Does anyone know when 3.4.0 version is coming out? I may wait for that. Also, I did download the latest SQL Server drivers from the MS site. Thanks again. -----Original Message----- From: John Hardin [mailto:jh...@im...] Sent: Monday, July 23, 2012 2:49 PM To: Savoy, Melinda Cc: squ...@li... Subject: RE: [Squirrel-sql-users] Problem trying to connect to SQL Server 2008 R2 box On Mon, 23 Jul 2012, Savoy, Melinda wrote: > Thanks John. I appreciate ALL your help. Ok, since my last post I installed Squirrel on my Linux laptop (It's gloomy here and this is better than sitting in front of the teevee...) and confirmed it works against my MSSQL2008 dev install on my work box using a SQL Server login. I did not try a Domain login. (1) I upgraded to the current snapshot version. Are you using stable or snapshot? If stable, you might want try switching to the snapshot. (2) I downloaded the MSSQL JDBC drivers from the MSFT website. Did you do that? Here is the URL: http://download.microsoft.com/download/0/2/A/02AAE597-3865-456C-AE7F-613F99F850A8/sqljdbc_4.0.2206.100_enu.tar.gz > Still trying to get a zip file to install on my windows box and see if > I can get it to work just like you have it working. Still prefer to > get it working on Linux if I can. > > Have a GREAT vacation! > > Regards. > > -----Original Message----- > From: John Hardin [mailto:jh...@im...] > Sent: Monday, July 23, 2012 1:10 PM > To: Savoy, Melinda > Cc: squ...@li... > Subject: RE: [Squirrel-sql-users] Problem trying to connect to SQL > Server 2008 R2 box > > On Mon, 23 Jul 2012, Savoy, Melinda wrote: > >> Sorry. Yes, I have indeed tried the SQL Server login as well as the windows authentication but to no avail. > > Bother. > > Unfortunately I don't have Squirrel set up on Linux here (I need to do > that) or I'd test in my environment. > > I might do that this week (I'm on vaca) and let you know if nobody else offers a solution. > >> -----Original Message----- >> From: John Hardin [mailto:jh...@im...] >> Sent: Monday, July 23, 2012 12:55 PM >> To: Savoy, Melinda >> Cc: squ...@li... >> Subject: RE: [Squirrel-sql-users] Problem trying to connect to SQL >> Server 2008 R2 box >> >> On Mon, 23 Jul 2012, Savoy, Melinda wrote: >> >>> Hi John. Yes each SQL Server is setup to accept both Windows and >>> SQL authentication (mixed mode). >>> >>> I am able to login from my SQL Server 2008 Client via the management >>> studio to each of these boxes. I just can't seem to connect via >>> SQuirreL from my Debian 6 Linux box. >> >> I could see attempting to use a Domain login having problems in that situation. Have you tried a SQL Server login? You haven't clearly stated whether you've tried that, and if you have, whether or not it works. >> >>> Thanks. >>> >>> -----Original Message----- >>> From: John Hardin [mailto:jh...@im...] >>> Sent: Monday, July 23, 2012 12:44 PM >>> To: Savoy, Melinda >>> Cc: squ...@li... >>> Subject: Re: [Squirrel-sql-users] Problem trying to connect to SQL >>> Server 2008 R2 box >>> >>> On Mon, 23 Jul 2012, Savoy, Melinda wrote: >>> >>>> I have downloaded SQuirreL 3.3.0 on my Debian 6 Linux box and it loaded great. I'm trying to setup my Alias to connect to the 3 SQL Server 2008 R2 boxes on our network. >>>> >>>> I can connect to these boxes remotely from my own SQL Server 2008 client on my Windows 7 box but when I try to connect to these SQL Server boxes from my SQuirreL client in Debian I get the following error: >>>> >>>> Golden: Login failed for user 'admin-mxs'. >>>> ClientConnectionId:5dea83e5-3407-4d05-b307-84e826b4436f >>>> >>>> I've tried entering the username with and without the DOMAIN NAME\admin-mxs but still get the same error. >>>> >>>> Any help/direction would be appreciated. >>> >>> I can confirm that Squirrel does work with MSSQL2008R2 from W7 x64 using SQL Server logins. I am not sure that Windows Domain logins work. >>> >>> Are you able to configure your server to accept SQL Server logins (Mixed mode)? 5~ -- John Hardin KA7OHZ http://www.impsec.org/~jhardin/ jh...@im... FALaholic #11174 pgpk -a jh...@im... key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 ----------------------------------------------------------------------- It is not the place of government to make right every tragedy and woe that befalls every resident of the nation. ----------------------------------------------------------------------- 13 days until the rover Curiosity lands on Mars |
|
From: John H. <jh...@im...> - 2012-07-23 19:49:02
|
On Mon, 23 Jul 2012, Savoy, Melinda wrote: > Thanks John. I appreciate ALL your help. Ok, since my last post I installed Squirrel on my Linux laptop (It's gloomy here and this is better than sitting in front of the teevee...) and confirmed it works against my MSSQL2008 dev install on my work box using a SQL Server login. I did not try a Domain login. (1) I upgraded to the current snapshot version. Are you using stable or snapshot? If stable, you might want try switching to the snapshot. (2) I downloaded the MSSQL JDBC drivers from the MSFT website. Did you do that? Here is the URL: http://download.microsoft.com/download/0/2/A/02AAE597-3865-456C-AE7F-613F99F850A8/sqljdbc_4.0.2206.100_enu.tar.gz > Still trying to get a zip file to install on my windows box and see if I > can get it to work just like you have it working. Still prefer to get > it working on Linux if I can. > > Have a GREAT vacation! > > Regards. > > -----Original Message----- > From: John Hardin [mailto:jh...@im...] > Sent: Monday, July 23, 2012 1:10 PM > To: Savoy, Melinda > Cc: squ...@li... > Subject: RE: [Squirrel-sql-users] Problem trying to connect to SQL Server 2008 R2 box > > On Mon, 23 Jul 2012, Savoy, Melinda wrote: > >> Sorry. Yes, I have indeed tried the SQL Server login as well as the windows authentication but to no avail. > > Bother. > > Unfortunately I don't have Squirrel set up on Linux here (I need to do > that) or I'd test in my environment. > > I might do that this week (I'm on vaca) and let you know if nobody else offers a solution. > >> -----Original Message----- >> From: John Hardin [mailto:jh...@im...] >> Sent: Monday, July 23, 2012 12:55 PM >> To: Savoy, Melinda >> Cc: squ...@li... >> Subject: RE: [Squirrel-sql-users] Problem trying to connect to SQL >> Server 2008 R2 box >> >> On Mon, 23 Jul 2012, Savoy, Melinda wrote: >> >>> Hi John. Yes each SQL Server is setup to accept both Windows and SQL >>> authentication (mixed mode). >>> >>> I am able to login from my SQL Server 2008 Client via the management >>> studio to each of these boxes. I just can't seem to connect via >>> SQuirreL from my Debian 6 Linux box. >> >> I could see attempting to use a Domain login having problems in that situation. Have you tried a SQL Server login? You haven't clearly stated whether you've tried that, and if you have, whether or not it works. >> >>> Thanks. >>> >>> -----Original Message----- >>> From: John Hardin [mailto:jh...@im...] >>> Sent: Monday, July 23, 2012 12:44 PM >>> To: Savoy, Melinda >>> Cc: squ...@li... >>> Subject: Re: [Squirrel-sql-users] Problem trying to connect to SQL >>> Server 2008 R2 box >>> >>> On Mon, 23 Jul 2012, Savoy, Melinda wrote: >>> >>>> I have downloaded SQuirreL 3.3.0 on my Debian 6 Linux box and it loaded great. I'm trying to setup my Alias to connect to the 3 SQL Server 2008 R2 boxes on our network. >>>> >>>> I can connect to these boxes remotely from my own SQL Server 2008 client on my Windows 7 box but when I try to connect to these SQL Server boxes from my SQuirreL client in Debian I get the following error: >>>> >>>> Golden: Login failed for user 'admin-mxs'. >>>> ClientConnectionId:5dea83e5-3407-4d05-b307-84e826b4436f >>>> >>>> I've tried entering the username with and without the DOMAIN NAME\admin-mxs but still get the same error. >>>> >>>> Any help/direction would be appreciated. >>> >>> I can confirm that Squirrel does work with MSSQL2008R2 from W7 x64 using SQL Server logins. I am not sure that Windows Domain logins work. >>> >>> Are you able to configure your server to accept SQL Server logins (Mixed mode)? 5~ -- John Hardin KA7OHZ http://www.impsec.org/~jhardin/ jh...@im... FALaholic #11174 pgpk -a jh...@im... key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 ----------------------------------------------------------------------- It is not the place of government to make right every tragedy and woe that befalls every resident of the nation. ----------------------------------------------------------------------- 13 days until the rover Curiosity lands on Mars |
|
From: Roger H. <rh...@hi...> - 2012-07-23 19:09:17
|
You might try opening a DOS window (Start/Run/Cmd), and executing the bat file from there. That way you would see the errors generated. Roger > It was suggested on a previous post that I try to see if I can make the SQuirreL client program > run on my Windows 7 box and when I tried to follow the instructions and execute the file > squirrel-sql.bat to run the application the window just opens and closes automatically. I think I > have a goblin following me around today... UGHHH! > > Any suggestions on what the problem is? Again, any help/direction would be appreciated. > > I have a Window 7 64 bit OS. > > Thanks. > ------------------------------------------------------------------------------ > Live Security Virtual Conference > Exclusive live event will cover all the ways today's security and > threat landscape has changed and how IT managers can respond. Discussions > will include endpoint security, mobile security and the latest in malware > threats. > http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/_______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > **************************************** Roger Hill **************************************** |
|
From: Savoy, M. <ms...@wc...> - 2012-07-23 18:57:09
|
Here is what was returned to me: C:\SQuirreL\squirrel-sql.bat \Java\jdk1.7.0_04\bin\bin\javaw.exe was unexpected at this time. I'm not sure where it's getting the double "bin\bin". -----Original Message----- From: Roger Hill [mailto:rh...@hi...] Sent: Monday, July 23, 2012 1:52 PM To: Savoy, Melinda Cc: squ...@li... Subject: Re: [Squirrel-sql-users] Windows issue You might try opening a DOS window (Start/Run/Cmd), and executing the bat file from there. That way you would see the errors generated. Roger > It was suggested on a previous post that I try to see if I can make > the SQuirreL client program run on my Windows 7 box and when I tried > to follow the instructions and execute the file squirrel-sql.bat to > run the application the window just opens and closes automatically. I think I have a goblin following me around today... UGHHH! > > Any suggestions on what the problem is? Again, any help/direction would be appreciated. > > I have a Window 7 64 bit OS. > > Thanks. > ---------------------------------------------------------------------- > -------- > Live Security Virtual Conference > Exclusive live event will cover all the ways today's security and > threat landscape has changed and how IT managers can respond. > Discussions will include endpoint security, mobile security and the > latest in malware threats. > http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/_____________ > __________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > **************************************** Roger Hill **************************************** |
|
From: Savoy, M. <ms...@wc...> - 2012-07-23 18:48:16
|
It was suggested on a previous post that I try to see if I can make the SQuirreL client program run on my Windows 7 box and when I tried to follow the instructions and execute the file squirrel-sql.bat to run the application the window just opens and closes automatically. I think I have a goblin following me around today... UGHHH! Any suggestions on what the problem is? Again, any help/direction would be appreciated. I have a Window 7 64 bit OS. Thanks. |
|
From: Savoy, M. <ms...@wc...> - 2012-07-23 18:11:55
|
Thanks John. I appreciate ALL your help. Still trying to get a zip file to install on my windows box and see if I can get it to work just like you have it working. Still prefer to get it working on Linux if I can. Have a GREAT vacation! Regards. -----Original Message----- From: John Hardin [mailto:jh...@im...] Sent: Monday, July 23, 2012 1:10 PM To: Savoy, Melinda Cc: squ...@li... Subject: RE: [Squirrel-sql-users] Problem trying to connect to SQL Server 2008 R2 box On Mon, 23 Jul 2012, Savoy, Melinda wrote: > Sorry. Yes, I have indeed tried the SQL Server login as well as the windows authentication but to no avail. Bother. Unfortunately I don't have Squirrel set up on Linux here (I need to do that) or I'd test in my environment. I might do that this week (I'm on vaca) and let you know if nobody else offers a solution. > -----Original Message----- > From: John Hardin [mailto:jh...@im...] > Sent: Monday, July 23, 2012 12:55 PM > To: Savoy, Melinda > Cc: squ...@li... > Subject: RE: [Squirrel-sql-users] Problem trying to connect to SQL > Server 2008 R2 box > > On Mon, 23 Jul 2012, Savoy, Melinda wrote: > >> Hi John. Yes each SQL Server is setup to accept both Windows and SQL >> authentication (mixed mode). >> >> I am able to login from my SQL Server 2008 Client via the management >> studio to each of these boxes. I just can't seem to connect via >> SQuirreL from my Debian 6 Linux box. > > I could see attempting to use a Domain login having problems in that situation. Have you tried a SQL Server login? You haven't clearly stated whether you've tried that, and if you have, whether or not it works. > >> Thanks. >> >> -----Original Message----- >> From: John Hardin [mailto:jh...@im...] >> Sent: Monday, July 23, 2012 12:44 PM >> To: Savoy, Melinda >> Cc: squ...@li... >> Subject: Re: [Squirrel-sql-users] Problem trying to connect to SQL >> Server 2008 R2 box >> >> On Mon, 23 Jul 2012, Savoy, Melinda wrote: >> >>> I have downloaded SQuirreL 3.3.0 on my Debian 6 Linux box and it loaded great. I'm trying to setup my Alias to connect to the 3 SQL Server 2008 R2 boxes on our network. >>> >>> I can connect to these boxes remotely from my own SQL Server 2008 client on my Windows 7 box but when I try to connect to these SQL Server boxes from my SQuirreL client in Debian I get the following error: >>> >>> Golden: Login failed for user 'admin-mxs'. >>> ClientConnectionId:5dea83e5-3407-4d05-b307-84e826b4436f >>> >>> I've tried entering the username with and without the DOMAIN NAME\admin-mxs but still get the same error. >>> >>> Any help/direction would be appreciated. >> >> I can confirm that Squirrel does work with MSSQL2008R2 from W7 x64 using SQL Server logins. I am not sure that Windows Domain logins work. >> >> Are you able to configure your server to accept SQL Server logins (Mixed mode)? -- John Hardin KA7OHZ http://www.impsec.org/~jhardin/ jh...@im... FALaholic #11174 pgpk -a jh...@im... key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 ----------------------------------------------------------------------- Efficiency can magnify good, but it magnifies evil just as well. So, we should not be surprised to find that modern electronic communication magnifies stupidity as *efficiently* as it magnifies intelligence. -- Robert A. Matern ----------------------------------------------------------------------- 13 days until the rover Curiosity lands on Mars |
|
From: John H. <jh...@im...> - 2012-07-23 18:10:24
|
On Mon, 23 Jul 2012, Savoy, Melinda wrote: > Sorry. Yes, I have indeed tried the SQL Server login as well as the windows authentication but to no avail. Bother. Unfortunately I don't have Squirrel set up on Linux here (I need to do that) or I'd test in my environment. I might do that this week (I'm on vaca) and let you know if nobody else offers a solution. > -----Original Message----- > From: John Hardin [mailto:jh...@im...] > Sent: Monday, July 23, 2012 12:55 PM > To: Savoy, Melinda > Cc: squ...@li... > Subject: RE: [Squirrel-sql-users] Problem trying to connect to SQL Server 2008 R2 box > > On Mon, 23 Jul 2012, Savoy, Melinda wrote: > >> Hi John. Yes each SQL Server is setup to accept both Windows and SQL >> authentication (mixed mode). >> >> I am able to login from my SQL Server 2008 Client via the management >> studio to each of these boxes. I just can't seem to connect via >> SQuirreL from my Debian 6 Linux box. > > I could see attempting to use a Domain login having problems in that situation. Have you tried a SQL Server login? You haven't clearly stated whether you've tried that, and if you have, whether or not it works. > >> Thanks. >> >> -----Original Message----- >> From: John Hardin [mailto:jh...@im...] >> Sent: Monday, July 23, 2012 12:44 PM >> To: Savoy, Melinda >> Cc: squ...@li... >> Subject: Re: [Squirrel-sql-users] Problem trying to connect to SQL >> Server 2008 R2 box >> >> On Mon, 23 Jul 2012, Savoy, Melinda wrote: >> >>> I have downloaded SQuirreL 3.3.0 on my Debian 6 Linux box and it loaded great. I'm trying to setup my Alias to connect to the 3 SQL Server 2008 R2 boxes on our network. >>> >>> I can connect to these boxes remotely from my own SQL Server 2008 client on my Windows 7 box but when I try to connect to these SQL Server boxes from my SQuirreL client in Debian I get the following error: >>> >>> Golden: Login failed for user 'admin-mxs'. >>> ClientConnectionId:5dea83e5-3407-4d05-b307-84e826b4436f >>> >>> I've tried entering the username with and without the DOMAIN NAME\admin-mxs but still get the same error. >>> >>> Any help/direction would be appreciated. >> >> I can confirm that Squirrel does work with MSSQL2008R2 from W7 x64 using SQL Server logins. I am not sure that Windows Domain logins work. >> >> Are you able to configure your server to accept SQL Server logins (Mixed mode)? -- John Hardin KA7OHZ http://www.impsec.org/~jhardin/ jh...@im... FALaholic #11174 pgpk -a jh...@im... key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 ----------------------------------------------------------------------- Efficiency can magnify good, but it magnifies evil just as well. So, we should not be surprised to find that modern electronic communication magnifies stupidity as *efficiently* as it magnifies intelligence. -- Robert A. Matern ----------------------------------------------------------------------- 13 days until the rover Curiosity lands on Mars |
|
From: Savoy, M. <ms...@wc...> - 2012-07-23 17:56:28
|
Sorry. Yes, I have indeed tried the SQL Server login as well as the windows authentication but to no avail. -----Original Message----- From: John Hardin [mailto:jh...@im...] Sent: Monday, July 23, 2012 12:55 PM To: Savoy, Melinda Cc: squ...@li... Subject: RE: [Squirrel-sql-users] Problem trying to connect to SQL Server 2008 R2 box On Mon, 23 Jul 2012, Savoy, Melinda wrote: > Hi John. Yes each SQL Server is setup to accept both Windows and SQL > authentication (mixed mode). > > I am able to login from my SQL Server 2008 Client via the management > studio to each of these boxes. I just can't seem to connect via > SQuirreL from my Debian 6 Linux box. I could see attempting to use a Domain login having problems in that situation. Have you tried a SQL Server login? You haven't clearly stated whether you've tried that, and if you have, whether or not it works. > Thanks. > > -----Original Message----- > From: John Hardin [mailto:jh...@im...] > Sent: Monday, July 23, 2012 12:44 PM > To: Savoy, Melinda > Cc: squ...@li... > Subject: Re: [Squirrel-sql-users] Problem trying to connect to SQL > Server 2008 R2 box > > On Mon, 23 Jul 2012, Savoy, Melinda wrote: > >> I have downloaded SQuirreL 3.3.0 on my Debian 6 Linux box and it loaded great. I'm trying to setup my Alias to connect to the 3 SQL Server 2008 R2 boxes on our network. >> >> I can connect to these boxes remotely from my own SQL Server 2008 client on my Windows 7 box but when I try to connect to these SQL Server boxes from my SQuirreL client in Debian I get the following error: >> >> Golden: Login failed for user 'admin-mxs'. >> ClientConnectionId:5dea83e5-3407-4d05-b307-84e826b4436f >> >> I've tried entering the username with and without the DOMAIN NAME\admin-mxs but still get the same error. >> >> Any help/direction would be appreciated. > > I can confirm that Squirrel does work with MSSQL2008R2 from W7 x64 using SQL Server logins. I am not sure that Windows Domain logins work. > > Are you able to configure your server to accept SQL Server logins (Mixed mode)? -- John Hardin KA7OHZ http://www.impsec.org/~jhardin/ jh...@im... FALaholic #11174 pgpk -a jh...@im... key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 ----------------------------------------------------------------------- If guns kill people, then... -- pencils miss spel words. -- cars make people drive drunk. -- spoons make people fat. ----------------------------------------------------------------------- 13 days until the rover Curiosity lands on Mars |
|
From: John H. <jh...@im...> - 2012-07-23 17:55:17
|
On Mon, 23 Jul 2012, Savoy, Melinda wrote: > Hi John. Yes each SQL Server is setup to accept both Windows and SQL > authentication (mixed mode). > > I am able to login from my SQL Server 2008 Client via the management > studio to each of these boxes. I just can't seem to connect via > SQuirreL from my Debian 6 Linux box. I could see attempting to use a Domain login having problems in that situation. Have you tried a SQL Server login? You haven't clearly stated whether you've tried that, and if you have, whether or not it works. > Thanks. > > -----Original Message----- > From: John Hardin [mailto:jh...@im...] > Sent: Monday, July 23, 2012 12:44 PM > To: Savoy, Melinda > Cc: squ...@li... > Subject: Re: [Squirrel-sql-users] Problem trying to connect to SQL Server 2008 R2 box > > On Mon, 23 Jul 2012, Savoy, Melinda wrote: > >> I have downloaded SQuirreL 3.3.0 on my Debian 6 Linux box and it loaded great. I'm trying to setup my Alias to connect to the 3 SQL Server 2008 R2 boxes on our network. >> >> I can connect to these boxes remotely from my own SQL Server 2008 client on my Windows 7 box but when I try to connect to these SQL Server boxes from my SQuirreL client in Debian I get the following error: >> >> Golden: Login failed for user 'admin-mxs'. >> ClientConnectionId:5dea83e5-3407-4d05-b307-84e826b4436f >> >> I've tried entering the username with and without the DOMAIN NAME\admin-mxs but still get the same error. >> >> Any help/direction would be appreciated. > > I can confirm that Squirrel does work with MSSQL2008R2 from W7 x64 using SQL Server logins. I am not sure that Windows Domain logins work. > > Are you able to configure your server to accept SQL Server logins (Mixed mode)? -- John Hardin KA7OHZ http://www.impsec.org/~jhardin/ jh...@im... FALaholic #11174 pgpk -a jh...@im... key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 ----------------------------------------------------------------------- If guns kill people, then... -- pencils miss spel words. -- cars make people drive drunk. -- spoons make people fat. ----------------------------------------------------------------------- 13 days until the rover Curiosity lands on Mars |
|
From: Savoy, M. <ms...@wc...> - 2012-07-23 17:46:20
|
Hi John. Yes each SQL Server is setup to accept both Windows and SQL authentication (mixed mode). I am able to login from my SQL Server 2008 Client via the management studio to each of these boxes. I just can't seem to connect via SQuirreL from my Debian 6 Linux box. Thanks. -----Original Message----- From: John Hardin [mailto:jh...@im...] Sent: Monday, July 23, 2012 12:44 PM To: Savoy, Melinda Cc: squ...@li... Subject: Re: [Squirrel-sql-users] Problem trying to connect to SQL Server 2008 R2 box On Mon, 23 Jul 2012, Savoy, Melinda wrote: > I have downloaded SQuirreL 3.3.0 on my Debian 6 Linux box and it loaded great. I'm trying to setup my Alias to connect to the 3 SQL Server 2008 R2 boxes on our network. > > I can connect to these boxes remotely from my own SQL Server 2008 client on my Windows 7 box but when I try to connect to these SQL Server boxes from my SQuirreL client in Debian I get the following error: > > Golden: Login failed for user 'admin-mxs'. > ClientConnectionId:5dea83e5-3407-4d05-b307-84e826b4436f > > I've tried entering the username with and without the DOMAIN NAME\admin-mxs but still get the same error. > > Any help/direction would be appreciated. I can confirm that Squirrel does work with MSSQL2008R2 from W7 x64 using SQL Server logins. I am not sure that Windows Domain logins work. Are you able to configure your server to accept SQL Server logins (Mixed mode)? -- John Hardin KA7OHZ http://www.impsec.org/~jhardin/ jh...@im... FALaholic #11174 pgpk -a jh...@im... key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 ----------------------------------------------------------------------- If guns kill people, then... -- pencils miss spel words. -- cars make people drive drunk. -- spoons make people fat. ----------------------------------------------------------------------- 13 days until the rover Curiosity lands on Mars |
|
From: John H. <jh...@im...> - 2012-07-23 17:43:42
|
On Mon, 23 Jul 2012, Savoy, Melinda wrote: > I have downloaded SQuirreL 3.3.0 on my Debian 6 Linux box and it loaded great. I'm trying to setup my Alias to connect to the 3 SQL Server 2008 R2 boxes on our network. > > I can connect to these boxes remotely from my own SQL Server 2008 client on my Windows 7 box but when I try to connect to these SQL Server boxes from my SQuirreL client in Debian I get the following error: > > Golden: Login failed for user 'admin-mxs'. ClientConnectionId:5dea83e5-3407-4d05-b307-84e826b4436f > > I've tried entering the username with and without the DOMAIN NAME\admin-mxs but still get the same error. > > Any help/direction would be appreciated. I can confirm that Squirrel does work with MSSQL2008R2 from W7 x64 using SQL Server logins. I am not sure that Windows Domain logins work. Are you able to configure your server to accept SQL Server logins (Mixed mode)? -- John Hardin KA7OHZ http://www.impsec.org/~jhardin/ jh...@im... FALaholic #11174 pgpk -a jh...@im... key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 ----------------------------------------------------------------------- If guns kill people, then... -- pencils miss spel words. -- cars make people drive drunk. -- spoons make people fat. ----------------------------------------------------------------------- 13 days until the rover Curiosity lands on Mars |
|
From: Savoy, M. <ms...@wc...> - 2012-07-23 17:13:33
|
I have downloaded SQuirreL 3.3.0 on my Debian 6 Linux box and it loaded great. I'm trying to setup my Alias to connect to the 3 SQL Server 2008 R2 boxes on our network. I can connect to these boxes remotely from my own SQL Server 2008 client on my Windows 7 box but when I try to connect to these SQL Server boxes from my SQuirreL client in Debian I get the following error: Golden: Login failed for user 'admin-mxs'. ClientConnectionId:5dea83e5-3407-4d05-b307-84e826b4436f I've tried entering the username with and without the DOMAIN NAME\admin-mxs but still get the same error. Any help/direction would be appreciated. Regards. |
|
From: strucki75 <old...@st...> - 2012-07-18 14:40:58
|
Some default parameters can be edited in the file prefs.xml in the directory .squirrel-sql in the windows user directory. In the database alias properties you can additionally specify what schemas you want to load. -- View this message in context: http://old.nabble.com/Saving-Object-tree-filters-tp31977362p34179420.html Sent from the squirrel-sql-users mailing list archive at Nabble.com. |
|
From: John H. <jh...@im...> - 2012-07-16 23:17:25
|
On Mon, 16 Jul 2012, Licata,Mary wrote: > We have a shared Windows box that is used by several analysts. I did > the initial setup of Vertica drivers and the ODBC connection for the > database. I installed Squirrel, which all users ( logged on as > themselves) can access. All users can see the ODBC driver and the > system DSN connection I created. However, when they open Squirrel, they > are unable to find the ODBC driver in the dropdown list. > > Any suggestions? ...which dropdown list? Squirrel is a Java application which uses JDBC, which is a different protocol and interface than ODBC. ODBC data source names will not appear by default in the Squirrel "Drivers" list. There is a JDBC-to-ODBC bridge installed by default that would probably allow you to use the ODBC data source you created, but you'd be better served by getting the Vertica JDBC drivers, installing them, and configuring Squirrel to use them. Translation through ODBC means you might lose some features of Vertica. -- John Hardin KA7OHZ http://www.impsec.org/~jhardin/ jh...@im... FALaholic #11174 pgpk -a jh...@im... key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 ----------------------------------------------------------------------- Men by their constitutions are naturally divided in to two parties: 1. Those who fear and distrust the people and wish to draw all powers from them into the hands of the higher classes. 2. Those who identify themselves with the people, have confidence in them, cherish and consider them as the most honest and safe, although not the most wise, depository of the public interests. -- Thomas Jefferson ----------------------------------------------------------------------- Today: the 67th anniversary of the dawn of the Atomic Age |
|
From: Licata,Mary <ML...@CE...> - 2012-07-16 21:18:49
|
We have a shared Windows box that is used by several analysts. I did the initial setup of Vertica drivers and the ODBC connection for the database. I installed Squirrel, which all users ( logged on as themselves) can access. All users can see the ODBC driver and the system DSN connection I created. However, when they open Squirrel, they are unable to find the ODBC driver in the dropdown list. Any suggestions? mel ---------------------------------------------------------------------- CONFIDENTIALITY NOTICE This message and any included attachments are from Cerner Corporation and are intended only for the addressee. The information contained in this message is confidential and may constitute inside or non-public information under international, federal, or state securities laws. Unauthorized forwarding, printing, copying, distribution, or use of such information is strictly prohibited and may be unlawful. If you are not the addressee, please promptly delete this message and notify the sender of the delivery error by e-mail or you may call Cerner's corporate offices in Kansas City, Missouri, U.S.A at (+1) (816)221-1024. |
|
From: <ant...@ke...> - 2012-07-11 06:03:40
|
Hi,
I’m a DBA from Finish Social Insurance Institution. Our developers are
using Squirrel to browse tables in our test environment. We are using DB2
on z/OS.
After a latest update on DB2 we faced a new problem in Squirrel. The
update was APAR PM58842 (PTF-number UK78737). Are there any known problems
with Squirrel with that APAR? I try to describe how the problem occurs.
We have configured a driver to DB2 and it works fine. We face the error
when we try to create an alias. I choose radio button “Specify Schema
loading and caching”. I have chosen drop down boxes to be like “Set All
Objects in all Schemas to Load but don’t cache”. Then I press the button
“Connect database to refresh Schema table” and give my user id and
password to connect. After these steps I get nothing in the Schema table,
although I should get. Following error message is written in the Squirrel
Logs:
2012-07-10 13:16:33,512 [Thread-4] ERROR
net.sourceforge.squirrel_sql.client.session.SessionManager - Failed to
get allowed Schemas
java.lang.NullPointerException
at
net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getSchemas(SQLDatabaseMetaData.java:289)
at
net.sourceforge.squirrel_sql.client.session.SessionManager.getAllowedSchemas(SessionManager.java:686)
at
net.sourceforge.squirrel_sql.client.gui.db.aliasproperties.SchemaPropertiesController.onConnected(SchemaPropertiesController.java:261)
at
net.sourceforge.squirrel_sql.client.gui.db.aliasproperties.SchemaPropertiesController.access$500(SchemaPropertiesController.java:25)
at
net.sourceforge.squirrel_sql.client.gui.db.aliasproperties.SchemaPropertiesController$8.connected(SchemaPropertiesController.java:212)
at
net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.run(ConnectToAliasCommand.java:307)
at java.lang.Thread.run(Unknown Source)
Anyway, the Alias can be created. But when I take connection to that
alias, no objects can be seen in the “Objects” tab. If I choose the “SQL”
tab, everything works fine. I can give straight SQL-commands and get
desired result in that way.
Also the old aliases lost their information about tables etc., when we
installed the DB2 APAR. So we cannot see for example tables anymore in the
object tree in the “Objects” tab. Straight SQL-commands work fine with old
aliases too.
Do you have faced the same kind of problem before? If you have something
to ask, I will be delighted to answer.
Thanks for your support.
Best regards
Antti Liesjärvi
IT Specialist
+358 400767752
+358505919655
|
|
From: Robert M. <rob...@gm...> - 2012-07-04 14:56:45
|
It might help to let us know which database you are using. Rob On Tue, Jul 3, 2012 at 6:56 AM, Jai Sumaria <Jai...@ka...> wrote: > Hi,**** > > ** ** > > I work for a company where developers are based in Stockholm (CET) and I > am based in london.**** > > ** ** > > We have a time_dimension table in our DW which looks like this for the > developers:**** > > ** ** > > ** ** > > Time_dimension_id**** > > Full_time**** > > hour**** > > minute**** > > second**** > > 1**** > > 00:00:00**** > > 0**** > > 0**** > > 0**** > > 2**** > > 00:00:01**** > > 0**** > > 0**** > > 1**** > > 3**** > > 00:00:02**** > > 0**** > > 0**** > > 2**** > > ** ** > > However on mine, it shows up as:**** > > ** ** > > Time_dimension_id**** > > Full_time**** > > hour**** > > minute**** > > second**** > > 1**** > > 01:00:00**** > > 0**** > > 0**** > > 0**** > > 2**** > > 01:00:01**** > > 0**** > > 0**** > > 1**** > > 3**** > > 01:00:02**** > > 0**** > > 0**** > > 2**** > > ** ** > > As you can see there is an error with my full_time column. This is because > I am not in CET time zone like the developers.**** > > ** ** > > I have tried other client software and with theirs im able to change my > timezone to ‘CET’ and the problem is fixed. However I cant seem to change > the timezone within SquirreL SQL.**** > > ** ** > > Any help would be appreciated!**** > > ** ** > > Br**** > > Jai**** > > The information in this email is confidential and may be legally > privileged. > If you are not the intended recipient, you must not read, use or > disseminate that information > and upon reception, permanently delete the original and destroy any copies. > Although this email and any attachments are believed to be free of any > virus > or any other defect which might affect any computer or IT system into which > they are received and opened, it is the responsibility of the recipient to > ensure that they are virus free and no responsibility is accepted by Kambi > for any loss or damage arising in any way from receipt or use thereof. > > > ------------------------------------------------------------------------------ > Live Security Virtual Conference > Exclusive live event will cover all the ways today's security and > threat landscape has changed and how IT managers can respond. Discussions > will include endpoint security, mobile security and the latest in malware > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > |
