The client tag has no wiki summary.
1
vote
1answer
19 views
psql coloured prompt misbehaving
In theory, there is a possibility to use coloured prompts in psql. I decided (not the first time :) that I need them, so I thought I would give them a try. So I have in my .psqlrc the following:
...
0
votes
0answers
35 views
minimum software required to connect to an Oracle server on a lan
I'm an OK dba with MySQL, passable with SQL Server, awful with Oracle.
I have a Windows Server 2008 R2 running Oracle 11g. I'd like to connect to this server with SQL Developer running on Windows XP ...
1
vote
0answers
240 views
Oracle 11g release 2 32 bit client Installation
I have installed a 32 bit Oracle 11g Release 2 (11.2.0.3) client on my Solaris 64 bit machine. But I am getting:
Generic Status: Library Open failed, Library Name: libclntsh.so, Platform Status: ...
-1
votes
1answer
174 views
Connecting to database using Toad in windows
I am trying to connect to a database using Toad on windows 7.
But I am not able to connect because I dont have SQLNET Editor, TNSNames Editor and LDAP Editor installed.
Please help me with this. I ...
2
votes
1answer
92 views
Getting SQLSTATE in psql error messages
I have the following problem.
SELECT * FROM tgvbn();
ERROR: function tgvbn() does not exist
LINE 1: SELECT * FROM tgvbn();
^
HINT: No function matches the given name and ...
2
votes
3answers
447 views
how to install mysql on mac?
My Mac runs Mac OS X, version 10.7.5., so it's a 64 bit system.
First, I downloaded mysql-5.5.28-osx10.6-x86_64.dmg.
Then I double clicked mysql-5.5.28-osx10.6-x86_64.dmg, it's mounted, and shows
...
1
vote
1answer
95 views
Does Oracle server installation include client components?
I installed Oracle personal edition on a Windows Server 2008 virtual machine for testing purposes. My intention is to test Linked server functionality with SQL Server. Does Oracle Server installation ...
1
vote
1answer
261 views
Oracle Client vs Oracle Instant Client on Linux!
to have the following setup on a Linux box:
SQLPlus
client library (oci.dll)!!!!
ORACLE_HOME is set for users
is Oracle Instant Client enough or I need to have the Oracle Client installed on the ...
0
votes
1answer
114 views
Postgres Client - save table sorting
Is there a Postgres client (for Windows) that can save customized sorting when viewing tables? Obviously I could write and save a query for this, but perhaps there's a client that can do this for me. ...
0
votes
1answer
2k views
What's a good (free) client for MySQL on Windows? [closed]
I am almost repeating a question done here by another user, but related to MySQL. What do you think is the best free (if any) MySQL client software?
Thank you!
3
votes
1answer
171 views
Odd SQL Server Studio error, but not on SQL Server Express?
I'm running a query that I got today from a previous question, and I just noticed an error that only happens when I run this query ON the server (RDC + MS Studio -- not express) vs on my machine which ...
1
vote
1answer
358 views
can mysql cli exit with error if no records returned?
I would like to execute a sql command in bash, and do something based on whether or not there was a result.
e.g.
$ LOOKUP=123; mysql -e \
'SELECT id FROM table WHERE id='$LOOKUP dbname \
...
3
votes
1answer
1k views
Installing 10g client next to 11g database on same computer
I have Oracle 11.2.0.1.0 installed on Windows 7 64 bit
I want to import data from warehouse which has Oracle 10.2.0.4.0 installed.
When I try to import
impdp usr/pass@WAREHOUSE TABLES=TABLE ...
0
votes
1answer
502 views
32-bit versus 64-bit ODP.NET to Oracle connection
I seem to be having an issue connecting a 32-bit .NET application to a 64-bit server, without a full Oracle client.
If I build a 64-bit application, using the 64-bit ODP.NET dll's or a 64-bit instant ...
2
votes
3answers
3k views
What's a good (free) client for Informix on Windows? [closed]
I'm looking for a GUI client for Informix on Windows (mainly to view data and execute queries), free would obviously be nice but I know Informix is used mostly in corporate environments and free may ...
5
votes
3answers
606 views
MySQL client believes they're in a transaction, gets KILLed, wreaks havoc
Open up two mysql command-line clients and connect to your database. In client #1, enter
START TRANSACTION;
In client #2, use SHOW PROCESSLIST, then
KILL [n];
where n is the id for client #1's ...
4
votes
2answers
996 views
What's a free client for Oracle 8 on Linux / Ubuntu?
I need to connect to a legacy Oracle 8 database.
Oracle SQL Developer would be my tool of choice, but the current version doesn't support Oracle 8 anymore.
I tried Squirrel too, but the connection ...
