Just tried and let it sit for about 7-8 minutes. Still nothing in the =
contents or row count tabs. After looking a bit deeper I see that the =
logs have the following stack trace:
=20
40422 [Thread-4] ERROR =
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.Bas=
eDataSetTab -=20
java.sql.SQLException: Line 1: Incorrect syntax near '-'.
at =
net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:=
365)
at =
net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at =
net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at =
net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at =
net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.jav=
a:418)
at =
net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1=
258)
at =
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.tab=
le.ContentsTab.createDataSet(ContentsTab.java:325)
at =
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.Bas=
eDataSetTab$1.run(BaseDataSetTab.java:123)
at =
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:8=
2)
at java.lang.Thread.run(Unknown Source)
=20
I don=E2=80=99t know where I can go to see/modify the sql that is used =
for the contents tab. Any advice? One more thing, my db name is =
pop-dev. I hope that is not the =E2=80=9C-=E2=80=9C it is referencing.
=20
Thanks,
Dale
=20
=20
=20
From: JP...@ne... =
[mailto:JP...@ne...]=20
Sent: Thursday, May 10, 2007 11:48 AM
To: Dale Bronk
Subject: Re: [Squirrel-sql-users] Can't see table contents
=20
You know, when I first started using SQuirrel I was surprised about the =
amount of time it took for those tabs to populate. I thought at first =
there was an issue with the driver. This probably sounds strange, but =
have you tried to click on the tabs and leave them for 5 minutes or so?=20
JP Sabin
Database Mgr.
NMC
Phone: 402.891.7744
Fax: 402.891.7607
Cell: 402.616.5294
email: JP...@ne...=20
"Dale Bronk" <db...@wi...>=20
Sent by: squ...@li...=20
05/10/2007 10:43 AM=20
To
<squ...@li...>=20
cc
=09
Subject
[Squirrel-sql-users] Can't see table contents
=20
=09
Hello=E2=80=A6=20
=20
I just downloaded SQuirreL 2.5 and installed. I can connect to my MS =
SQL database just fine using the sourceforge jTDS jdbc driver. My =
problem is that when I select my table for the left pane and then select =
either contents or row count tabs I see nothing but a gray blank tab =
content. It doesn=E2=80=99t even show a blank row. If I jump over to =
the sql tab I can enter select, insert, update statements and they all =
process just fine and allow me to view the contents so I don=E2=80=99t =
believe it is anything to do with rights of the user. Please advise.=20
=20
Thanks,=20
Dale=20
=
-------------------------------------------------------------------------=
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/_____________________________________=
__________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
|
