Mironov, Leonid {BIS} | 21 Aug 12:04 2014

cannot browse tables in multiple MS SQL databases

Squirrel 3.5.3 on windows 7 with jtds 1.3.1 is used to connect to MS SQL 10 with several databases on the same server using AD authentication, connection string is 'jdbc:jtds:sqlserver://address:1433/db;;integratedSecurity=true;authenticationScheme=JavaKerberos'. The problem is that with this connection string I can browse tables (i.e. expand <database>.<schema>.TABLE in the objects pane) only of the database specified in the connection string, others are empty, and if I don't specify database name there I cannot browse tables at all. All tables of all databases are still accessible in SQL queries but having to remember tables and fields by heart is rather trying, creating individual aliases for each of the databases is only a little better. Is it possible to browse tables of multiple databases?

------------------------------------------------------------------------------
Slashdot TV.  
Video for Nerds.  Stuff that matters.
http://tv.slashdot.org/
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
hany bardissi | 2 Aug 04:56 2014
Picon

hany bardissi

http://turkstationery.com/uzufitrq/ucouylvhhihsa.cynhlefsdhtdh















hany bardissi





8/2/2014 2:56:15 AM
------------------------------------------------------------------------------
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
David G | 31 Jul 21:12 2014
Picon

How to Run Whole Script at Once?

To Run a whole script/page of several queries...
Currently I'm doing a Select All, then a Ctrl - Enter.

Surely there's a single command/shortcut I could use?

Tried looking in Help and online, but no luck.

thanks!
------------------------------------------------------------------------------
Infragistics Professional
Build stunning WinForms apps today!
Reboot your WinForms applications with our WinForms controls. 
Build a bridge from your legacy apps to the future.
http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
David Gardner | 31 Jul 21:08 2014

How to Run Whole Script at Once?

To Run a whole script/page of several queries...
Currently I'm doing a Select All, then a Ctrl - Enter.

Surely there's a single command/shortcut I could use?

Tried looking in Help and online, but no luck.

thanks!
------------------------------------------------------------------------------
Infragistics Professional
Build stunning WinForms apps today!
Reboot your WinForms applications with our WinForms controls. 
Build a bridge from your legacy apps to the future.
http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Federico Bruni | 28 Jul 10:59 2014
Picon

load only one schema in a DB2 database

Hi all

I've started using Squirrel to learn a bit of SQL.
I have a simple question that I can't figure out by myself. I'm connecting to a DB2 database which has several schemas, but I'm interested in querying only one. Currently I must specify the schema or I get an error. For example:

SELECT column FROM schema.table

works, while:

SELECT column FROM table

doesn't.

I'd like to set a certain schema to be the default to reduce the length of my SQL instructions.
IIUC I should change the properties of the alias. But I can load or not load _all_ the schemas; I cannot say "load only this schema and don't load the others". I'm missing something?

Thanks a lot in advance
Federico

------------------------------------------------------------------------------
Infragistics Professional
Build stunning WinForms apps today!
Reboot your WinForms applications with our WinForms controls. 
Build a bridge from your legacy apps to the future.
http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
David | 25 Jul 16:53 2014
Picon

Re: FW: Instructions for upgrading SQL Squirrel version?

Wary users back up the $HOME/.squirrel-sql/ dir where your settings reside in case a file is overwritten.
------------------------------------------------------------------------------
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
David | 25 Jul 16:53 2014
Picon

Re: FW: Instructions for upgrading SQL Squirrel version?

Wary users back up the $HOME/.squirrel-sql/ dir where your settings reside in case a file is overwritten.
------------------------------------------------------------------------------
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

FW: Instructions for upgrading SQL Squirrel version?

To any future readers – I got responses from one user who successfully installs new versions on top of the existing install, and another user that installs in a new directory each time.  I chose to install in a new directory and it worked for me; my existing driver config and aliases worked in the new version without any work on my part.

 

Thanks

 

Martin

 

From: Herbener, Martin - Division of Engineering and Management
Sent: Wednesday, July 23, 2014 12:53 PM
To: 'squirrel-sql-users <at> lists.sourceforge.net'
Subject: Instructions for upgrading SQL Squirrel version?

 

Hi,

 

I am getting ready to upgrade an existing SQL Squirrel 3.4.0 installation on 64-bit Windows 7 to the most current release of SQL Squirrel; are there any instructions I should follow to preserve driver settings, aliases, etc?

 

Thanks!

 

Martin

 

 

Martin Herbener

Kentucky Department of Education

502 564 2020

 

KDE on Facebook: www.facebook.com/kydeptofed

KDE on Twitter: twitter.com/KyDeptofEd

 

------------------------------------------------------------------------------
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Instructions for upgrading SQL Squirrel version?

Hi,

 

I am getting ready to upgrade an existing SQL Squirrel 3.4.0 installation on 64-bit Windows 7 to the most current release of SQL Squirrel; are there any instructions I should follow to preserve driver settings, aliases, etc?

 

Thanks!

 

Martin

 

 

Martin Herbener

Kentucky Department of Education

502 564 2020

 

KDE on Facebook: www.facebook.com/kydeptofed

KDE on Twitter: twitter.com/KyDeptofEd

 

------------------------------------------------------------------------------
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Wesley Newswanger | 17 Jul 14:43 2014

Unexpected Error with snapshot-20140709_2314

I'm using Squirrel 3.53 to access a Pervasive database and it works great.

With snapshot-20140709_2314 I receive the following error:

Unexpected Error occurred attempting to open an SQL connection.

java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.lang.NullPointerException
	at java.util.concurrent.FutureTask.report(Unknown Source)
	at java.util.concurrent.FutureTask.get(Unknown Source)
	at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132)
	at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45)
	at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115)
	at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.RuntimeException: java.lang.NullPointerException
	at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:175)
	at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$000(OpenConnectionCommand.java:45)
	at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$1.run(OpenConnectionCommand.java:104)
	... 5 more
Caused by: java.lang.NullPointerException
	at net.sourceforge.squirrel_sql.fw.sql.SQLConnection.<init>(SQLConnection.java:86)
	at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:138)
	at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167)
	... 7 more

Best regards,
 
Wesley S. Newswanger
 IT & Database Administrator

Keystone CollectionsT 
         by Martin's Wood Products LLC

Office: 866.881.6680     ext. 1028
Fax:    877.517.8121
Email:  wesleyn <at> keystonecollections.com

www.keystonecollections.com

------------------------------------------------------------------------------
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
Rhonda Dupree | 26 Jun 15:47 2014

Progressive SQL Connection

Hi,

 

I am not familiar with Progressive PSQL database. We have installed new software package that uses Progressive. I would like to connect to it with my Squirrel SQL client. Do I need to create a new driver definition? Does anyone have an example to go by? I have tried searching with google and I am at a loss. The Progressive manual says I should use the pvjdbd2.jar driver. Thanks in advance for any insight.

 

R. Dupree

 

 

------------------------------------------------------------------------------
Open source business process management suite built on Java and Eclipse
Turn processes into business applications with Bonita BPM Community Edition
Quickly connect people, data, and systems into organized workflows
Winner of BOSSIE, CODIE, OW2 and Gartner awards
http://p.sf.net/sfu/Bonitasoft
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Gmane