search

andialbrecht / crunchyfrog

Head over to RunSQLRun, the successor of CrunchyFrog
http://runsqlrun.org
GNU General Public License v3.0
4 stars 2 forks source link

No result and no error messages with MSSQL #31

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. installed from launchpad the intrepid version on Ubunutu 8.10.
2. Configured connection with MSSQL backend (all required dependencies
should be installed)
3. Connection is successful, shows target system: "Microsoft SQL Server
2000 - 8.00.2040(Intel X86) Enterprise Edition on Windows NT 5.2 (Build
3790:Service Pack 2).
4. In the navigator I can browse the tables and I see the individual
columns of each table.
5. Try to submit a simple query
select TOP 50 *
from mydbname
but the only thing that happens is that the bottom right pane jumps to
"Messages" but no message is shown.
6. Copy pasted same query to SquirrelSQL, where it runs fine.

What is the expected output? What do you see instead?
No results, no messages, not even error messages.

What version of the product are you using? On what operating system? Python
version?
Ubuntu 8.10, pyhton-all Ubuntu packages (python 2.5.2-1ubuntu1)

Please provide any additional information below.

Original issue reported on code.google.com by 4chanarc...@gmail.com on 3 Feb 2009 at 11:55

GoogleCodeExporter commented 9 years ago 
It looks like the MSSQL backend raises some exception not catched by the 
application.

When you start CrunchyFrog from a command line (e.g. in gnome-terminal with the
command "crunchyfrog"), do you see any error messages (note, you'll have to 
close all
running instance of CrunchyFrog before running it from command line)?

I've tried the MSSQL backend with the same SQL Server version without any 
problems,
so maybe there's some error message when started from the command line.

Original comment by albrecht.andi on 3 Feb 2009 at 12:17

GoogleCodeExporter commented 9 years ago 
Ah, of course, I could have thought of doing it that way of course.
Here are the results.

When I launch crunchyfrog from the command line it first outputs these two 
lines:
reload ipy_profile_none
reload ipy_user_conf

Then when I execute a query, this is put out:
Traceback (most recent call last):
  File "/usr/lib/python2.5/site-packages/cf/ui/mainwindow.py", line 547, in
on_query_execute
    self.get_active_editor().execute_query()
  File "/usr/lib/python2.5/site-packages/cf/ui/editor.py", line 338, in execute_query
    stmts = sqlparse.sqlsplit(statement, dialect=dialect)
AttributeError: 'module' object has no attribute 'sqlsplit'

BTW, I like what I see so far. A simple fast and not overly complicated looking 
SQL
client.
Looking forward to test drive this a bit more, when it works for me.

Original comment by 4chanarc...@gmail.com on 3 Feb 2009 at 12:29

GoogleCodeExporter commented 9 years ago 
ah, ok.. ;-) This is an ugly bug in 0.3.2 which is already fixed in the current
development version.

The problem (and a workaround) is reported in issue27 (for the workaround see 
comment
1). So I'm closing this bug as a duplicate. But big thanks for reporting and 
for your
feedback!

Expect a bug fix release sometimes next week.

Original comment by albrecht.andi on 3 Feb 2009 at 12:46