Questions tagged [client]
91 questions
15
votes
1 answer
What's the differences between the two version of oracle client download file, "client" and "client home"?
I noticed the Oracle database download page has two groups of clients for users to download. There is a thing called "client" and has 32-bit version and 64-bit version. Also, there is a thing called "client home", which also has both 32-bit and…
Just a learner
- 2,082
- 7
- 36
- 57
12
votes
2 answers
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 argument types. You might need to add explicit type…
András Váczi
- 31,778
- 13
- 102
- 151
8
votes
2 answers
Client application disconnects from database/s it is connected to after 10 minutes of inactivity
When working with pgAdmin 4 (and actually, several other programs that act as clients to the database), the connection to the server disconnects after some 10 or 15 minutes of inactivity. One coffee and one phone call, and you get a message similar…
joanolo
- 13,657
- 8
- 39
- 67
8
votes
1 answer
How to display Postgres version in the CLI pompt?
I whish to display the version of the server I am connected to in the command-line (console) interface prompt. From what I read in the documentation, it is possible to execute a shell command, it is possible to display a psql variable value.
The…
greg
- 255
- 1
- 7
6
votes
2 answers
How do I get the Query Timing with sqlcmd?
Running SQL Server 2017, using the interactive REPL client sqlcmd how do I get the time for Query Execution?
You can sp_BlitzErik showing this in his answer here,
SQL Server Execution Times:
CPU time = 1859 ms, elapsed time = 321 ms.
Evan Carroll
- 65,432
- 50
- 254
- 507
6
votes
3 answers
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 connection. Bam—transaction rolled back. But client #1…
Trevor Burnham
- 171
- 7
5
votes
1 answer
Installation of Oracle Instant Client on an Ubuntu 64 machine
I would like to install Oracle Instant Client on a Ubuntu 64 bit machine.
Following this link, I have installed the rpm packages basic, development and sqlplus using alien.
Then:
sqlplus username/password@//dbhost:1521/SID
sqlplus: command not…
Henk
- 181
- 1
- 5
5
votes
3 answers
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
mysql-5.5.28-osx10.6-x86_64.pkg -> I double-clicked…
athos
- 163
- 2
- 7
5
votes
1 answer
PostgreSQL PSQL client-side commands and new lines (\COPY)
The error message is the same with super user using COPY. The files are located on the same server as the postgres server. Saw many similar posting but not a single one answer my question.
\copy table_name from '/path/to/csv/file.csv'
with format…
Kemin Zhou
- 219
- 2
- 3
- 10
5
votes
2 answers
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 \
&& echo "Row $LOOKUP exists"
|| echo "Row $LOOKUP…
artfulrobot
- 427
- 9
- 19
4
votes
3 answers
What's a good (free) client for Informix on Windows?
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 not be available. Perhaps the best option is set…
newenglander
- 1,075
- 5
- 13
- 23
4
votes
1 answer
How can I connect to a network MySQL server using ODBC?
Somewhere on my company's network there's a (Oracle) MySQL server named FOO. I see FOO reference in SAS code written by my team's analysts, who use SAS's PROC SQL command to connect to it using ODBC.
I need to connect to FOO in a MySQL client rather…
Hack-R
- 141
- 8
4
votes
1 answer
Where I can find the tnsnames.ora file for my Oracle Windows client?
I installed Oracle client for my Windows 7 machine. I can connect to a remote Oracle database using Toad for Oracle using the direct method (giving host, port and service name for the connection).
Now I tried to find the tnsnames.ora file from the…
jrara
- 5,393
- 20
- 58
- 65
4
votes
2 answers
How to persistently set MySQL (Linux mysql command) session time zone to UTC?
I'm using MySQL on Linux (CentOS, recent release). I want the MySQL system variable time_zone to reflect UTC.
When I start a MySQL session (using the command-line tool mysql) and check the time zone setting, I see this:
mysql> select…
rich p
- 233
- 1
- 3
- 6
4
votes
1 answer
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 has MS Studio Express.
Here is the Error:
Msg…
Jakub
- 354
- 1
- 9