Stack Overflow
Stack Overflow

Questions tagged [dbvisualizer]

DBVisualizer is a popular database tool by DbVis Software AB. Written in Java, it runs on Windows, Mac OS X, and Unix/Linux, and will connect to any JDBC enabled database server.

DBVisualizer is a popular database tool by DBVis Software AB. Written in Java, it runs on Windows, Mac OSX, and Unix/Linux, and will connect to any database server.

214 questions
0
votes
2 answers

Insertion Of data into temp table

I am using sybase database and i use DB visulazier, I have two tables one of the table has 30 million and other table has 3 million which has archive data of the first table. Both the tables grow by date, i mean every day we get records into the…
Mahesh Sambu
  • 349
  • 2
  • 15
0
votes
1 answer

DbVisualizer inserts a paramter into my Oracle DB Function call

I'm trying to write an Function in an Oracle database. When i'm in the function editor and attempt to run it, DbVis inserts an additional parameter. @call [dbvis - v0] = SP_GET_ANNUAL_SALES_HISTORY( [dbvis - v1], 'DAL', '00105315', '2013' ); @echo…
Davidson
  • 1,064
  • 3
  • 20
  • 35
0
votes
1 answer

Edit table data inline with DBVisualizer Free

I'm trying to edit table data in inline mode with DBVisualizer 9 Free version and i just can't. Is it possible?
R01010010
  • 5,670
  • 11
  • 47
  • 77
0
votes
1 answer

How to delete duplicate rows from table from DbVisualiser

I have a table called ORG_MAP, it contained 200 records, I executed a query to copy those 200 records to other table called ORG_MAP_1 (duplicate table of ORG_MAP), but what happened was the same 200 records got inserted into the same ORG_MAP table.…
madhu
  • 1,010
  • 5
  • 20
  • 38
0
votes
4 answers

ORA-00907: missing right parenthesis 2

I am trying to execute this query to get some results in db-visualizer, but I keep getting the following response: Response: [Error Code: 907, SQL State: 42000] ORA-00907: missing right parenthesis Edited Query: SELECT * FROM ( SELECT …
Ish
  • 671
  • 5
  • 21
  • 36
0
votes
1 answer

Database management tool that support Database server address in IPv6 format

I use Sybase ASE 15.5 on Windows server 2008 and use Sybase central (JDBC driver) for management. After configured my machine to IPv6 only mode ( pure IPv6) and correct the DSEDIT connection properties, I can ping Datase server and access Database…
Tuan
  • 2,303
  • 2
  • 25
  • 37
0
votes
1 answer

DbVisualizer Cannot Find Database on Mac OS X 10.7

I'm trying to connect to an SQL database, but am having a lot of trouble with it. Any and all help would be greatly appreciated. As you can see below, the location of the sql file is /Users/agoodkind/mockup/test-database.sql: In DbVisualizer, I…
Adam_G
  • 7,337
  • 20
  • 86
  • 148
0
votes
1 answer

DBVisualizer not showing SP source code

I'm using DBVisualizer with against my shared hosting database. I'm not able to see the actual SP code, if I log from a different IP address, than the one from what I have created the SPs. Any ideas? I was not able to find any option in CPanel that…
user1359575
  • 99
  • 1
  • 3
  • 12
0
votes
2 answers

not able to run "group by" query in dbvisualizer 6.5

I am executing the following sql in dbvisualizer Select column1,column2,column3 from table group by column3; It is showing the following error: 15:47:09 [SELECT - 0 row(s), 0.000 secs] [Error Code: 979, SQL State: 42000] ORA-00979: not a GROUP…
pankaj_ar
  • 757
  • 2
  • 10
  • 33
-1
votes
2 answers

How to verify SSL Enablement in Netezza Database using a query in client tool like DBVISUALIZER?

I am trying to check or verify SSL is enabled or not for my current Netezza connection. I have tried multiple queries, but none of the them is working. Below are some listed queries, which I tried in DBVISUALIZER:- SELECT * FROM…
sujay777
  • 41
  • 5
-1
votes
1 answer

SQL create counter column for duplicate

I am trying to create a count column when the same customer contacts regarding an item ("attached_to col" below). Attempt below shows the total count, but is not a counter. I would like it to show as a counter by date as per screenshot select …
msulol
  • 67
  • 6
-1
votes
1 answer

DBVisualizer is only showing Schemas, but not showing tables, and not letting me see data

For some reason, when I started DBVisualizer this time, it stopped showing me tables and data. It only shows me Schemas. I have checked using the host's online portal and the tables/data is all still there. Any ideas why DBVis stopped letting me…
CodyBugstein
  • 21,984
  • 61
  • 207
  • 363
-1
votes
1 answer

How to create a live excel connection to Redshift

I want to be able to connect excel with redshift. So when I refresh this live connection in excel, it will refresh the query I write in redshift and return the newest result in excel. I used to do it in a SQL Server using a stored procedure, and…
Danqi Liu
  • 1
  • 1
-1
votes
1 answer

Joining and filtering out unnecessary data

I need to build a query with the following requirements. The two tables to use are MASTER_ARCHIVE and REP_PROFILE As of now we are only interested in reps at the wirehouses: Wells Fargo, Morgan Stanley, UBS, Merrill Lynch To get reps from only…
ace123
  • 35
  • 1
  • 7
-1
votes
1 answer

famous "@localhost" connect issue mysql and dbVisualizer

Seems to be a well known issue with connecting to mysql and the @localhost: Connects when: mysql -uadmin2 -p Does not connect when (duplicate @localhost) $ mysql -uadmin2@localhost -p Enter password: ERROR 1045 (28000): Access denied for user…
KevinY
  • 1,229
  • 1
  • 12
  • 27
1 2 3
…
14
15