squirrel-sql-users — A subscriber only discussion list for SQuirreL

Re: [Squirrel-sql-users] can't connect to MS SQL Server

[David C. <Dav...@ve...>]

'Gentoo' -


Try a url of the FORM:

	jdbc:jtds:sqlserver://localhost:3048/employees

substituting, of course, your OWN correct values for 'host', and 'port' and
'db-name',
instead of the ones I'm showing here.  In other words, try the fixed
'prefix':

	jdbc:jtds:sqlserver://

and then supply your own values in the form shown on the tail-end.

Hope this works for you...that's what works for me.

Cheers...

	Dave



-----Original Message-----
From: squ...@li...
[mailto:squ...@li...]On Behalf Of
Gentoo @ Paradyme
Sent: Friday, June 02, 2006 4:42 PM
To: Matthew Dahlman
Cc: 'David Cook'; squ...@li...; 'Rainer F.
Cornely'
Subject: Re: [Squirrel-sql-users] can't connect to MS SQL Server


On Thu, 2006-05-11 at 09:26 +0800, Matthew Dahlman wrote:
> Hi Rainer,
>
> Dave is correct.
>
> To add a little explanation: the url that you used is correct for the MS
SQL
> Server 2000 driver, but it won't work for the 2005 driver.

Then what is the proper connection string? I too have this problem.



_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: [Squirrel-sql-users] can't connect to MS SQL Server

[Gentoo @ P. <ge...@pa...>]

On Thu, 2006-05-11 at 09:26 +0800, Matthew Dahlman wrote:
> Hi Rainer,
>  
> Dave is correct.
>  
> To add a little explanation: the url that you used is correct for the MS SQL
> Server 2000 driver, but it won't work for the 2005 driver.

Then what is the proper connection string? I too have this problem.

Re: [Squirrel-sql-users] Oracle plugin and schema restriction

[Gerd W. <bir...@t-...>]

Mathieu Maxime wrote:
> The restriction established on the tree view with the last version of 
> the Oracle plugin is too restrictive. I use a read-only schema (names 
> XX_RO) that have only readonly access to an other schema (XX_OWN).
> 
> When I connect using XX_RO, I can't visualize XX_OWN, I only have access 
> to SYS.
> This occurs with Squirrel 2.2 and in the last snapshot (release 0.16 of 
> the plugin). My XX_TO schema have only "grant-access" to XX_OWN, there 
> is no synonym defined.
> 
> Is there an option to inactivate this restriction ?
Yes, there is. See menu File --> Global Preferences --> Tab: Oracle.

By the way all these loading things are in development at the moment. I'm in 
contact with somebody who has quite a big Oracle database and has considerable 
startup performance problems. Some more changes will be done to solve these kind 
of problems.


> Thanks for your help.
> 
> Maxime Mathieu
> A long term SquirrelSQL happy user.
Nice to know. Thank you for using SquirrelSQL.

Gerd

[Squirrel-sql-users] Oracle plugin and schema restriction

[Mathieu M. <Max...@jc...>]

The restriction established on the tree view with the last version of
the Oracle plugin is too restrictive. I use a read-only schema (names
XX_RO) that have only readonly access to an other schema (XX_OWN).
When I connect using XX_RO, I can't visualize XX_OWN, I only have access
to SYS.
This occurs with Squirrel 2.2 and in the last snapshot (release 0.16 of
the plugin). My XX_TO schema have only "grant-access" to XX_OWN, there
is no synonym defined.
Is there an option to inactivate this restriction ?
Thanks for your help.

Maxime Mathieu
A long term SquirrelSQL happy user.

Re: [Squirrel-sql-users] Issues With Oracle

[Gerd W. <bir...@t-...>]

Hi Nathan,

I just committed some changes to CVS that may help solve your problem. For 
details see the latest change log entry about Oracle performance here:

http://squirrel-sql.cvs.sourceforge.net/*checkout*/squirrel-sql/sql12/doc/changes.txt


I would be very grateful if you could tell me if my changes solve your problem. 
If you don't have the chance to build SQuirreL from CVS you will have to wait 
till next weekends snapshot.

Please note that the Oracle Plugin is needed for my changes to take effect.

Thanks

Gerd

Nathan Aaron wrote:
> I am using Squirrel 2.2 to connect to a Oracle Apps DB(lots of 
> objects).  After I login it takes about 10 minutes before Squirrel is 
> functional.  At the bottom of the screen I see "Loading Tables... 
> Loading stored procedures...".  This process is taking way too long.  Is 
> there a way to only load the objects for the user who is loggin in?  It 
> appears to be loading all objects in the DB.  Disabling Load 
> Schemas/Catalogs into object tree has no effect.
> 
> Thanks,
> Nathan
> 
> 
> 
> -------------------------------------------------------
> All the advantages of Linux Managed Hosting--Without the Cost and Risk!
> Fully trained technicians. The highest number of Red Hat certifications in
> the hosting industry. Fanatical Support. Click to learn more
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> 

[Squirrel-sql-users] Issues With Oracle

[Nathan A. <na...@gl...>]

I am using Squirrel 2.2 to connect to a Oracle Apps DB(lots of 
objects).  After I login it takes about 10 minutes before Squirrel is 
functional.  At the bottom of the screen I see "Loading Tables... 
Loading stored procedures...".  This process is taking way too long.  Is 
there a way to only load the objects for the user who is loggin in?  It 
appears to be loading all objects in the DB.  Disabling Load 
Schemas/Catalogs into object tree has no effect.

Thanks,
Nathan

Re: [Squirrel-sql-users] RFE: Save SQL SELECT statement result into parametrised TXT file

[Gerd W. <bir...@t-...>]

Stepan RYBAR wrote:
> Gerd,
> I was thinking little bit more about requested feature and I do not need 
> really fixed width of columns. And not only because it can be more 
> complicated to implement it comparing to tab, space, semicolon... 
> delimiter.
Is available in CVS. See change log for further details. As you suggested I left 
out fixed column widths.

Gerd

> Stepan
> 
> <  ------------ Původní zpráva ------------
> <  Od: Gerd Wagner <bir...@t-...>
> <  another user already asked for this feature not long ago. I'll see if 
> I can get
> <  it in to 2.3. For the moment all I can offer is to copy and paste the 
> result. <  The delimiter will then be a tab character.
> <  <  Stepan RYBAR wrote:
> <  > It would be quite usefull for me to be able to save result of SQL 
> SELECT
> <  statement into parametrised TXT file. I want to be able select string 
> delimiter
> <  of fields (tab, comma, semicolon, space) or fixed width of column and 
> text
> <  qualifier (quotes). What about this? I am using SQuirreL 2.2 final.
> 

Re: [Squirrel-sql-users] RFE: Info, that loading data into "Content" sheet is done

[Gerd W. <bir...@t-...>]

Stepan RYBAR wrote:
 > Hallo!
 >
 > I have another suggestion for SQuirreL. I am inside Object Browser, I
 > have activated "Content" sheet in the right panel, I have selected some
 > table in the left panel. Now when I switch to other table in the left
 > panel using e. g. arrow keys, the content of the "Content" sheet in the
 > right panel changes. But...
 >
 > Let assume, I have several tables with the same structure (column names)
 > or I do not remember structure of tables. When I switch from one table
 > to another, there is no indication, that loading TOP X data was done.
 > Some loading of data can be slow. Workaround is to switch between "Row
 > Count" and "Content", but this needs to use mouse and precise mouse
 > clicking.
You may look at the Session windows status bar. It shows which table is active. 
I don't think we are going to do more about this issue in the near future.

 >
 > So what about some indication, that loading of TOP X data was done, when
 > "Content" sheet is active? I hope, that I explained it well. But this
 > RFE is not so much important for me - I can wait for some seconds.
 >
 > One question - is there any way, how to remove items from content menu,
 > when I right-click on the table in the Object Browser? I really do not
 > want to have "Drop" and "Delete Records" there! If not, RFE with much
 > more higher priority than above one... ;-)))
The "Drop" and "Delete Records" items where on top of the menu list. I moved 
them further down (available in CVS). We are not going to remove them.


Gerd

[Squirrel-sql-users] =?us-ascii?Q?RFE=3A=20Info=2C=20that=20loading=20data=20into=20=22Content=22=20sheet=20is=20done?=

[<xr...@se...>]

Hallo! 

I have another suggestion for SQuirreL. I am inside Object Browser, I have activated "Content" sheet in the right panel, I have selected some table in the left panel. Now when I switch to other table in the left panel using e. g. arrow keys, the content of the "Content" sheet in the right panel changes. But... 

Let assume, I have several tables with the same structure (column names) or I do not remember structure of tables. When I switch from one table to another, there is no indication, that loading TOP X data was done. Some loading of data can be slow. Workaround is to switch between "Row Count" and "Content", but this needs to use mouse and precise mouse clicking. 

So what about some indication, that loading of TOP X data was done, when "Content" sheet is active? I hope, that I explained it well. But this RFE is not so much important for me - I can wait for some seconds. 

One question - is there any way, how to remove items from content menu, when I right-click on the table in the Object Browser? I really do not want to have "Drop" and "Delete Records" there! If not, RFE with much more higher priority than above one... ;-)))

Thank You, Stepan.

Re: [Squirrel-sql-users] RFE: Save SQL SELECT statement result into parametrised TXT file

[Gerd W. <bir...@t-...>]

Stepan,

thanks for your hint. I'll see how much extra coding fixed sizes will take. If 
it's much I'll skip it.

Gerd

Stepan RYBAR wrote:
> Gerd,
> I was thinking little bit more about requested feature and I do not need 
> really fixed width of columns. And not only because it can be more 
> complicated to implement it comparing to tab, space, semicolon... 
> delimiter.
> Stepan
> 
> <  ------------ Původní zpráva ------------
> <  Od: Gerd Wagner <bir...@t-...>
> <  another user already asked for this feature not long ago. I'll see if 
> I can get
> <  it in to 2.3. For the moment all I can offer is to copy and paste the 
> result. <  The delimiter will then be a tab character.
> <  <  Stepan RYBAR wrote:
> <  > It would be quite usefull for me to be able to save result of SQL 
> SELECT
> <  statement into parametrised TXT file. I want to be able select string 
> delimiter
> <  of fields (tab, comma, semicolon, space) or fixed width of column and 
> text
> <  qualifier (quotes). What about this? I am using SQuirreL 2.2 final.
> 

[Squirrel-sql-users] =?us-ascii?Q?Re=3A=20=5BSquirrel=2Dsql=2Dusers=5D=20RFE=3A=20Save=20SQL=20SELECT=20statement=20result=20into=20parametrised=20TXT=20file?=

[<xr...@se...>]

Gerd, 

I was thinking little bit more about requested feature and I do not nee=
d really fixed width of columns. And not only because it can be more co=
mplicated to implement it comparing to tab, space, semicolon... delimit=
er. 

Stepan

<  ------------ P=F9vodn=ED zpr=E1va ------------
<  Od: Gerd Wagner <bir...@t-...>
<  another user already asked for this feature not long ago. I'll see i=
f I can get
<  it in to 2.3. For the moment all I can offer is to copy and paste th=
e result. 
<  The delimiter will then be a tab character.
<  
<  Stepan RYBAR wrote:
<  > It would be quite usefull for me to be able to save result of SQL =
SELECT
<  statement into parametrised TXT file. I want to be able select strin=
g delimiter
<  of fields (tab, comma, semicolon, space) or fixed width of column an=
d text
<  qualifier (quotes). What about this? I am using SQuirreL 2.2 final.

Re: [Squirrel-sql-users] RFE: Save SQL SELECT statement result into parametrised TXT file

[Gerd W. <bir...@t-...>]

Hi Stepan,

another user already asked for this feature not long ago. I'll see if I can get 
it in to 2.3. For the moment all I can offer is to copy and paste the result. 
The delimiter will then be a tab character.

Gerd

Stepan RYBAR wrote:
> Hello! 
> 
> It would be quite usefull for me to be able to save result of SQL SELECT statement into parametrised TXT file. I want to be able select string delimiter of fields (tab, comma, semicolon, space) or fixed width of column and text qualifier (quotes). What about this? I am using SQuirreL 2.2 final.
> 
> Thank You. Stepan
> 
> 
> -------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> 

[Squirrel-sql-users] Io exception

[James P. <je...@ob...>]

I started using SQuirrel SQL Client 2.2 Final on FEdora Core 4 and it
worked great. I've since update to Fedora Core 5 and reinstalled
SQuirreL SQL Client a couple times. I can't get it to connect to my
databases. I keep getting this error:

User Maintenance Database: Io exception: The Network Adapter could not
establish the connection

java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
	at oracle.jdbc.ttc7.TTC7Protocol.handleIOException(TTC7Protocol.java:3678)
	at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:352)
	at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:365)
	at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:547)
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:347)
	at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:125)
	at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.execute(OpenConnectionCommand.java:97)
	at net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.run(ConnectToAliasCommand.java:381)
	at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
	at java.lang.Thread.run(Thread.java:595)

This is the only application I have a problem with. I can connect to the
databases with another java application with no trouble at all. 

Anyone know what could be causing this?

Thanks,
James

[Squirrel-sql-users] Re: How to remove commas from numeric results?

[Robert M. <rob...@gm...>]

On 5/16/06, Zarbock, Eric <Eri...@de...> wrote:
> :)
>
> Thanks.  However, no luck here.  Is my tab different because it's the
> oracle thin client?  I tried the 'Display as string' options...
>

There is a scrollbar on the right side of the dialog.  If you scroll down, =
you
should see a section covering "FLOAT, REAL, DOUBLE..." data types.

Rob

[Squirrel-sql-users] =?us-ascii?Q?RFE=3A=20Save=20SQL=20SELECT=20statement=20result=20into=20parametrised=20TXT=20file?=

[<xr...@se...>]

Hello! 

It would be quite usefull for me to be able to save result of SQL SELECT statement into parametrised TXT file. I want to be able select string delimiter of fields (tab, comma, semicolon, space) or fixed width of column and text qualifier (quotes). What about this? I am using SQuirreL 2.2 final.

Thank You. Stepan

[Squirrel-sql-users] Re: How to remove commas from numeric results?

[Robert M. <rob...@gm...>]

Eric,

No problem.

File->Global Preferences->Data Type Controls

At the bottom of the tab there is a section covering "FLOAT, REAL, DOUBLE..=
."

Be sure to pick "Use default format"

We should probably have a FAQ item for this :)

Rob

On 5/15/06, Zarbock, Eric <Eri...@de...> wrote:
> Hello Rob,
>
> Regret having to ping your inbox again.  No rush on a reply.
>
> I have some 16 digit numbers from Oracle, using thin client.  They
> appear in Results with commas every 3 digits, which I have to manually
> remove before pasting the value elsewhere.  I've spent most of an hour
> looking, do you know of a way to dispense with the commas?
>
> Thanks again,
>
> Eric Zarbock
>

RE: [Squirrel-sql-users] can't connect to MS SQL Server

[Matthew D. <mda...@su...>]

Hi Ranier,
 
In case you are still working on this problem...
"TCP/IP connection could not be established" generally happens when the
client can't connect to the database server at all. The reasons are usually
things like these:
- The server isn't running
- The server is listening on a different port
- With SQL Server, TCP/IP access isn't always activated
- A firewall is blocking your access
 
Your problem may be different, but it's likely to be similar to something
like this.
 
I troubleshoot this sort of error like this:
1. Confirm that ping mobil-cor works.
2. Confirm that telnet mobil-cor 1433 works.
 
Good luck.
 
Regards,
Matt

  _____  

From: Rainer F. Cornely [mailto:Co...@ls...] 
Sent: Thursday, May 11, 2006 17:18 PM
To: Matthew Dahlman; David Cook; squ...@li...
Subject: AW: [Squirrel-sql-users] can't connect to MS SQL Server



Hi,  thanks for Your reply.

 

If I use the URL without the "microsoft." Then I get another error :

test: Es konnte keine TCP/IP-Verbindung zu Host "" hergestellt werden

(Translation: TCP/IP connection could not be established to Host "")

. java.net.ConnectException: Connection refused: connect

This Error message  is thrown even with the URL: jdbc:sqlserver://

That means for me it seems to be a version problem not a URL problem

Regards

Rainer

 

 

 

  _____  

Von: Matthew Dahlman [mailto:mda...@su...] 
Gesendet: Donnerstag, 11. Mai 2006 03:27
An: 'David Cook'; Rainer F. Cornely;
squ...@li...
Betreff: RE: [Squirrel-sql-users] can't connect to MS SQL Server

 

Hi Rainer,

 

Dave is correct.

 

To add a little explanation: the url that you used is correct for the MS SQL
Server 2000 driver, but it won't work for the 2005 driver.

 

By the way, property names like 'databaseName' are case insenstive--no
problems there. But it's standard practice to follow the suggested format
(databaseName, lastUpdateCount, etc.).

 

Regards,

Matt

 

  _____  

From: squ...@li...
[mailto:squ...@li...] On Behalf Of David
Cook
Sent: Wednesday, May 10, 2006 21:31 PM
To: 'Rainer F. Cornely'; squ...@li...
Subject: RE: [Squirrel-sql-users] can't connect to MS SQL Server

Rainer -

 

    Hmm...that looks like the same driver's JAR name that I use.  So, here;s

some differences I noticed between your URL and what my working URL looks
like:

 

You used:     jdbc:microsoft:sqlserver://mobil-cor:1433;databasename=xyz

 

Try taking the 'microsoft' part out of your URL 'prefix'...e.g.

      jdbc:sqlserver://mobil-cor:1433;databaseName=xyz

 

Also, I notice I use a CAPITAL N in 'databaseName'...don't know whether that

key is case-sensitive.

 

(I don't know anything about 'Extra' classpath vsjust classpath, so I can't
speak

to how you have that part set up.)

 

Hope this helps...

 

        Dave

-----Original Message-----
From: squ...@li...
[mailto:squ...@li...]On Behalf Of Rainer
F. Cornely
Sent: Wednesday, May 10, 2006 6:07 AM
To: squ...@li...
Subject: [Squirrel-sql-users] can't connect to MS SQL Server

 

Hi to all.

I'm new to SquirreL which is the best tool I've seen.

 

Everything is fine with all features including the plugins while connected
to Oracle 10g.

 

But I can't make it to get a connection to MS SQL

 

The System is XP Pro

Squirrel is 2.2 final

 

The Settings are:

 

Class Path: com.microsoft.sqlserver.jdbc.SQLServerDriver

Extra Class Path: .....\Microsoft SQL Server 2005 JDBC
Driver\sqljdbc_1.0\enu\sqljdbc.jar

 

Release Information

Microsoft SQL Server 2005 JDBC Driver

Version 1.0

January 2006

 

The database is up and running.

 

The URL's used: jdbc:microsoft:sqlserver://mobil-cor:1433

 
jdbc:microsoft:sqlserver://mobil-cor:1433;databasename=xyz

 

The Error Message: Test: Unable to create connection. Check your URL.

 

Can somebody help me?

Thanks in advance

 

Rainer

 

 

AW: [Squirrel-sql-users] can't connect to MS SQL Server

[Rainer F. C. <Co...@ls...>]

Hi,  thanks for Your reply.

=20

If I use the URL without the "microsoft." Then I get another error :

test: Es konnte keine TCP/IP-Verbindung zu Host "" hergestellt werden

(Translation: TCP/IP connection could not be established to Host "")

. java.net.ConnectException: Connection refused: connect

This Error message  is thrown even with the URL: jdbc:sqlserver://

That means for me it seems to be a version problem not a URL problem

Regards

Rainer

=20

=20

=20

________________________________

Von: Matthew Dahlman [mailto:mda...@su...]=20
Gesendet: Donnerstag, 11. Mai 2006 03:27
An: 'David Cook'; Rainer F. Cornely;
squ...@li...
Betreff: RE: [Squirrel-sql-users] can't connect to MS SQL Server

=20

Hi Rainer,

=20

Dave is correct.

=20

To add a little explanation: the url that you used is correct for the MS
SQL Server 2000 driver, but it won't work for the 2005 driver.

=20

By the way, property names like 'databaseName' are case insenstive--no
problems there. But it's standard practice to follow the suggested
format (databaseName, lastUpdateCount, etc.).

=20

Regards,

Matt

=20

________________________________

From: squ...@li...
[mailto:squ...@li...] On Behalf Of
David Cook
Sent: Wednesday, May 10, 2006 21:31 PM
To: 'Rainer F. Cornely'; squ...@li...
Subject: RE: [Squirrel-sql-users] can't connect to MS SQL Server

Rainer -

=20

    Hmm...that looks like the same driver's JAR name that I use.  So,
here;s

some differences I noticed between your URL and what my working URL
looks like:

=20

You used:     =
jdbc:microsoft:sqlserver://mobil-cor:1433;databasename=3Dxyz

=20

Try taking the 'microsoft' part out of your URL 'prefix'...e.g.

      jdbc:sqlserver://mobil-cor:1433;databaseName=3Dxyz

=20

Also, I notice I use a CAPITAL N in 'databaseName'...don't know whether
that

key is case-sensitive.

=20

(I don't know anything about 'Extra' classpath vsjust classpath, so I
can't speak

to how you have that part set up.)

=20

Hope this helps...

=20

        Dave

	-----Original Message-----
	From: squ...@li...
[mailto:squ...@li...]On Behalf Of
Rainer F. Cornely
	Sent: Wednesday, May 10, 2006 6:07 AM
	To: squ...@li...
	Subject: [Squirrel-sql-users] can't connect to MS SQL Server

	=20

	Hi to all.

	I'm new to SquirreL which is the best tool I've seen.

	=20

	Everything is fine with all features including the plugins while
connected to Oracle 10g.

	=20

	But I can't make it to get a connection to MS SQL

	=20

	The System is XP Pro

	Squirrel is 2.2 final

	=20

	The Settings are:

	=20

	Class Path: com.microsoft.sqlserver.jdbc.SQLServerDriver

	Extra Class Path: .....\Microsoft SQL Server 2005 JDBC
Driver\sqljdbc_1.0\enu\sqljdbc.jar

	=20

	Release Information

	Microsoft SQL Server 2005 JDBC Driver

	Version 1.0

	January 2006

	=20

	The database is up and running.

	=20

	The URL's used: jdbc:microsoft:sqlserver://mobil-cor:1433

=09
jdbc:microsoft:sqlserver://mobil-cor:1433;databasename=3Dxyz

	=20

	The Error Message: Test: Unable to create connection. Check your
URL.

	=20

	Can somebody help me?

	Thanks in advance

	=20

	Rainer

	=20

	=20

RE: [Squirrel-sql-users] can't connect to MS SQL Server

[Matthew D. <mda...@su...>]

Hi Rainer,
 
Dave is correct.
 
To add a little explanation: the url that you used is correct for the MS SQL
Server 2000 driver, but it won't work for the 2005 driver.
 
By the way, property names like 'databaseName' are case insenstive--no
problems there. But it's standard practice to follow the suggested format
(databaseName, lastUpdateCount, etc.).
 
Regards,
Matt

  _____  

From: squ...@li...
[mailto:squ...@li...] On Behalf Of David
Cook
Sent: Wednesday, May 10, 2006 21:31 PM
To: 'Rainer F. Cornely'; squ...@li...
Subject: RE: [Squirrel-sql-users] can't connect to MS SQL Server


Rainer -
 
    Hmm...that looks like the same driver's JAR name that I use.  So, here;s
some differences I noticed between your URL and what my working URL looks
like:
 
You used:     jdbc:microsoft:sqlserver://mobil-cor:1433;databasename=xyz
 
Try taking the 'microsoft' part out of your URL 'prefix'...e.g.
       jdbc:sqlserver://mobil-cor:1433;databaseName=xyz
 
Also, I notice I use a CAPITAL N in 'databaseName'...don't know whether that
key is case-sensitive.
 
(I don't know anything about 'Extra' classpath vs just classpath, so I can't
speak
 to how you have that part set up.)
 
Hope this helps...
 
         Dave

-----Original Message-----
From: squ...@li...
[mailto:squ...@li...]On Behalf Of Rainer
F. Cornely
Sent: Wednesday, May 10, 2006 6:07 AM
To: squ...@li...
Subject: [Squirrel-sql-users] can't connect to MS SQL Server



 

Hi to all.

I'm new to SquirreL which is the best tool I've seen.

 

Everything is fine with all features including the plugins while connected
to Oracle 10g.

 

But I can't make it to get a connection to MS SQL

 

The System is XP Pro

Squirrel is 2.2 final

 

The Settings are:

 

Class Path: com.microsoft.sqlserver.jdbc.SQLServerDriver

Extra Class Path: .....\Microsoft SQL Server 2005 JDBC
Driver\sqljdbc_1.0\enu\sqljdbc.jar

 

Release Information

Microsoft SQL Server 2005 JDBC Driver

Version 1.0

January 2006

 

The database is up and running.

 

The URL's used: jdbc:microsoft:sqlserver://mobil-cor:1433

 
jdbc:microsoft:sqlserver://mobil-cor:1433;databasename=xyz

 

The Error Message: Test: Unable to create connection. Check your URL.

 

Can somebody help me?

Thanks in advance

 

Rainer

 

 

RE: [Squirrel-sql-users] can't connect to MS SQL Server

[David C. <Dav...@ve...>]

Rainer -
 
    Hmm...that looks like the same driver's JAR name that I use.  So, here;s
some differences I noticed between your URL and what my working URL looks
like:
 
You used:     jdbc:microsoft:sqlserver://mobil-cor:1433;databasename=xyz
 
Try taking the 'microsoft' part out of your URL 'prefix'...e.g.
       jdbc:sqlserver://mobil-cor:1433;databaseName=xyz
 
Also, I notice I use a CAPITAL N in 'databaseName'...don't know whether that
key is case-sensitive.
 
(I don't know anything about 'Extra' classpath vs just classpath, so I can't
speak
 to how you have that part set up.)
 
Hope this helps...
 
         Dave

-----Original Message-----
From: squ...@li...
[mailto:squ...@li...]On Behalf Of Rainer
F. Cornely
Sent: Wednesday, May 10, 2006 6:07 AM
To: squ...@li...
Subject: [Squirrel-sql-users] can't connect to MS SQL Server



 

Hi to all.

I'm new to SquirreL which is the best tool I've seen.

 

Everything is fine with all features including the plugins while connected
to Oracle 10g.

 

But I can't make it to get a connection to MS SQL

 

The System is XP Pro

Squirrel is 2.2 final

 

The Settings are:

 

Class Path: com.microsoft.sqlserver.jdbc.SQLServerDriver

Extra Class Path: .....\Microsoft SQL Server 2005 JDBC
Driver\sqljdbc_1.0\enu\sqljdbc.jar

 

Release Information

Microsoft SQL Server 2005 JDBC Driver

Version 1.0

January 2006

 

The database is up and running.

 

The URL's used: jdbc:microsoft:sqlserver://mobil-cor:1433

 
jdbc:microsoft:sqlserver://mobil-cor:1433;databasename=xyz

 

The Error Message: Test: Unable to create connection. Check your URL.

 

Can somebody help me?

Thanks in advance

 

Rainer

 

 

[Squirrel-sql-users] can't connect to MS SQL Server

[Rainer F. C. <Co...@ls...>]

=20

Hi to all.

I'm new to SquirreL which is the best tool I've seen.

=20

Everything is fine with all features including the plugins while
connected to Oracle 10g.

=20

But I can't make it to get a connection to MS SQL

=20

The System is XP Pro

Squirrel is 2.2 final

=20

The Settings are:

=20

Class Path: com.microsoft.sqlserver.jdbc.SQLServerDriver

Extra Class Path: .....\Microsoft SQL Server 2005 JDBC
Driver\sqljdbc_1.0\enu\sqljdbc.jar

=20

Release Information

Microsoft SQL Server 2005 JDBC Driver

Version 1.0

January 2006

=20

The database is up and running.

=20

The URL's used: jdbc:microsoft:sqlserver://mobil-cor:1433

=20
jdbc:microsoft:sqlserver://mobil-cor:1433;databasename=3Dxyz

=20

The Error Message: Test: Unable to create connection. Check your URL.

=20

Can somebody help me?

Thanks in advance

=20

Rainer

=20

=20

RE: [Squirrel-sql-users] Attaching to database with URL

[<sun...@us...>]

Hi Matthew & David,
I printed out both sets of comments and final got the chance to sit down
and read and see where it takes me.

I didn't have to go to far, as the solution popped out with Matthew's
first suggestion. The syntax is nothing close to what is presented when
you create a new connection in Squirrel.

The Firebird / Squirrel syntax is
jdbc:firebirdsql:[//host[:port]/]<database>.

I provided the syntax
jdbc:firebirdsql:localhost/3050:c:/Compiere/data/compiere.fdb and
received connection to the database.

Thanks for taking the time to reply. I'll have to practice my internet
search technique more to fine tune the relevant hits.

David, Thanks for hanging in there to answer my questions. I appreciate
the time taken to try and assist with a serious of questions.

Regards
Peter


----- Original message -----
From: "Matthew Dahlman" <mda...@su...>
To: sun...@us..., "'squirrel sql users'"
<squ...@li...>
Date: Wed, 3 May 2006 17:57:25 +0800
Subject: RE: [Squirrel-sql-users] Attaching to database with URL

Hi Peter,

It's possible that the problem is as simple as some typos in your url.
You
may have the correct idea after all.

[snip snip]

Fw: [Squirrel-sql-users] Question about results

[Fatbob <fat...@ho...>]

Thanks Gerd!

----- Original Message ----- 
From: "Gerd Wagner" <bir...@t-...>
To: "Fatbob" <fat...@ho...>
Cc: "SQuirreL Users List" <squ...@li...>
Sent: Saturday, May 06, 2006 3:50 AM
Subject: Re: [Squirrel-sql-users] Question about results


> Fatbob wrote:
> > Hi everyone, I'm new to SQuirreL, and so far I like what I see. I have a
> > question about the result from an SQL query. When ever I execute an SQL
> > statement, a new results tab opens up. Is there an option/way to stop
this
> > from happening? I'd like to always have the result open in the same
results
> > tab.
> To have one result tab permanently go to menu File --> New Session
Properties
> --> Tab SQL. Set "Maximum limit of SQL Result Tabs" to 1.
>
> For a sort of similar feature right mouse click the head of a result tab
and
> choose the "toggle sticky" option. The tab then gets a pin label. All
further
> results will got to that tab.
>
>
>
> >
> > Also, is it possible to have multiple SQL tabs? There's the Objects tab,
and
> > an SQL tab, can I open another SQL tab?
> You can't have more than one SQL tab but you can open further SQL
Worksheets for
> the same Session using the ctrl+n short cut or menu Session --> New SQL
Worksheet
>
> Gerd
>
>
> -------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job
easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

Re: [Squirrel-sql-users] Question about results

[Gerd W. <bir...@t-...>]

Fatbob wrote:
> Hi everyone, I'm new to SQuirreL, and so far I like what I see. I have a
> question about the result from an SQL query. When ever I execute an SQL
> statement, a new results tab opens up. Is there an option/way to stop this
> from happening? I'd like to always have the result open in the same results
> tab.
To have one result tab permanently go to menu File --> New Session Properties 
--> Tab SQL. Set "Maximum limit of SQL Result Tabs" to 1.

For a sort of similar feature right mouse click the head of a result tab and 
choose the "toggle sticky" option. The tab then gets a pin label. All further 
results will got to that tab.



> 
> Also, is it possible to have multiple SQL tabs? There's the Objects tab, and
> an SQL tab, can I open another SQL tab?
You can't have more than one SQL tab but you can open further SQL Worksheets for 
the same Session using the ctrl+n short cut or menu Session --> New SQL Worksheet

Gerd

[Squirrel-sql-users] Question about results

[Fatbob <fat...@ho...>]

Hi everyone, I'm new to SQuirreL, and so far I like what I see. I have a
question about the result from an SQL query. When ever I execute an SQL
statement, a new results tab opens up. Is there an option/way to stop this
from happening? I'd like to always have the result open in the same results
tab.

Also, is it possible to have multiple SQL tabs? There's the Objects tab, and
an SQL tab, can I open another SQL tab?

Thanks!