Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [client]

The tag has no usage guidance.

0
votes
1answer
28 views

What happens when the same application from different server tries to connect to the always on primary server

In our environment we have an always on availability group and the reporting server is acting as a secondary replica with Synchronous Mode, manual failover. XSLT report editor that is a vendor ...
0
votes
1answer
19 views

Difference between Client Access Name in SQL server Fail over Cluster and Always on availability group

We are migrating from SQL Server Fail over Instance to Always On Availability group. The current network name is ABC\ABCTEST where ABC is the SQL server Virtual Name and ABCTEST is the named instance ...
0
votes
0answers
20 views

DB-Library not loading, SQL Client Configuration

When I open Client Network Utility (cliconfg.exe) on my laptop it generates an error that C:\WINDOWS\SYSTEM32\NTWDBLIB.DLL is either not designed to run on Windows or it contains an error. etc. ...
1
vote
0answers
29 views

Deployed application (Oracle 11g, VB.NET 2015 and Crystal Reports) cannot connect to database

I'm developing an application using Oracle 11g, VB.NET 2015 and Crystal Reports on Windows 10. I created a package and installed it on another PC on same network. The package is running fine but ...
0
votes
2answers
100 views

Do I need to update Oracle Client?

How does Oracle maintain Oracle Client software? I don't find Patch Updates for the Client Software of Oracle.
0
votes
1answer
184 views

How does Pymongo connection work?

I created a small speed test from misc.Database import Database import time db = Database.getDb() def main(): test_db = db.test_db.find({}) return "done" if __name__ == '__main__': ...
1
vote
3answers
43 views

MariaDB / MySQL client table-formatting like `psql`?

I hate to nitpick over style, but for the purposes of use Database Administrators is there a way to clean this up a bit, SELECT 1 AS "myCol1", 2 AS "myCol2"; +--------+--------+ | myCol1 | myCol2 | +-...
0
votes
1answer
17 views

Average Time That an App's Client is connected to a Database?

I'm studying Tuning Aspects, and my professor told me that a good practice it's to expect some stuff, between them there is this fact of Exoext the Average time that a client will be connected. Is ...
1
vote
2answers
166 views

Configure MariaDB client with host-specific credentials?

How can I configure my MariaDB client (mysql) so that I don't have to enter a password to connect, regardless of which host I am connecting to? I can't just put a password in the [client] section of ~...
0
votes
0answers
32 views

Resetting password when connecting to Oracle 11g database from a 12c client

I'm getting an invalid username/password after resetting my password when connecting to Oracle 11g database from a 12c client
2
votes
1answer
50 views

How can I make PQExecPrepared() not hang if the network connection has been lost?

We're using prepared statements and have found that if, after successfully connecting and executing some statements, the network link the connection was usning goes away, PQExecPrepared() hangs ...
0
votes
0answers
1k views

Oracle Database Client 12c Product Components

When installing the Oracle Database Client 12c Release 2 software on a Windows client the user has the option to select an installation type. These are: Administrator RunTime InstantClient Custom ...
2
votes
1answer
2k views

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 ...
0
votes
1answer
2k views

Any MYSQL Client with fully dark theme?

I would like to find a MYSQL Client program which can be config as FULLY DARK THEME. Many of them can not be dark theme in displaying result in grid.
0
votes
1answer
96 views

Interrupting query sends wrong thread ID

In the MySQL command line client (Linux) when I kill a query by pressing CTRL+c this usually works fine. mysql (slave) > select sleep(5); ^CCtrl-C -- sending "KILL QUERY 117920686" to server ... ...
1
vote
0answers
28 views

SSAS 2016 and XMLA: Problem retreiving “MDSCHEMA_ACTIONS” Rowsets under specific scenario

I'm developing a Web client that uses XMLA over HTTP calls to communicate with a SSAS 2016 Cube. When my client's user clicks on a cell in a pivot grid that is based on this cube, I would like to ...
1
vote
0answers
197 views

How to run Oracle Client 10g from non Administrator account?

Hi I have 2 users configured on my Windows 10 Home machine. One is Administrator and another is my own user. Although my user is configured as an Administrator, I can use Oracle Client 10g from my ...
2
votes
1answer
607 views

32-bit oracle client install hangs

Windows 7/x64 . installing oracle 11.2 32-bit client. Install proceeds, then at 80% hangs on netca. I have not had any luck finding a solution. Any suggestions?
1
vote
0answers
46 views

Generic SQL Client that helps to apply a filters [closed]

Is there any SQL Client that facilities the filtering of a recordset? For example, let's say I have a table and want to make a simple query like this: select * from table where col1 = 'value1' and ...
-2
votes
1answer
17k views

Get the error message when open toad oracle client tool [closed]

I have a serious problem with toad oracle client. I got the error message as following when I open toad client (installed and then opened it): Error: No valid Oracle clients found. You need at ...
1
vote
1answer
194 views

How do I bypass the typing of `GO` in `sqlcmd`?

sqlcmd has this most annoying this of having to type GO after every command, how can I get around this? SELECT 1 AS "foo" 2> GO foo ----------- 1 (1 rows affected) Can I make ...
4
votes
2answers
857 views

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 ...
2
votes
1answer
5k views

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 ...
-2
votes
1answer
79 views

Where can I find Oracle Admin client download link for version 11.2.0.3

I was trying to download oracle admin client for 11.2.0.3 ,however only 11.2.0.1 version is available. http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461....
3
votes
0answers
877 views

SQL Server Native Client ODBC Connection Fails

I am trying to troubleshoot an issue where some clients can connect and others cannot. Server and Database is online, Browser started, Named Pipes & TPC/IP enabled All users use the same SQL ...
3
votes
1answer
506 views

Oracle Client Silent Install Fails

I'm creating an automated package in PDQ Deploy which installs the Oracle client, and some patches. Step 1 copies the staging files to the target, which completes successfully. Step 2 attempts to ...
1
vote
1answer
48 views

Table or dictionary in code on a client for data that's not changed often?

Suppose I have a table where data won't be changed frequently. Say, a table "currencies" with a list of currencies which I accept on my website. I'd change it once in a while probably. What are pros ...
0
votes
1answer
34 views

psql \watch implementation for MariaDB? Repeatedly execute the current query

Quote from current Postgres manual \watch [ seconds ] Repeatedly execute the current query buffer (as \g does) until interrupted or the query fails. Wait the specified number of seconds (...
-3
votes
1answer
41 views

While doing client server connection i am geting this error TNS-12535

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 13-DEC-2016 16:57:44 Copyright (c) 1997, 2010, Oracle. All rights reserved. Used parameter files: D:\app\jayraj\product\11.2....
1
vote
1answer
404 views

How are multiple my.cnf's loaded by MySQL?

If I want to replicate how the MySQL/Maria client reads ~/.my.cnf, /etc/my.cnf, etc, how would I do it? The MySQL docs give a list of paths and mention "top files are read first, files read later ...
4
votes
2answers
1k views

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 ...
0
votes
1answer
67 views

Can't find the client download for SSMS

I need the SQL Server Management Studio client so I can use it to access a 2014 instance but am having a hard time finding it via Google. Where would I find only the client instead of the whole SSMS ...
0
votes
0answers
161 views

Is it possible to have Postgresql client libpq.so installed and running on both 32bit and 64bit?

Some time ago I had a problem running with a conflict between the 32bit and 64 bit clients on PostgreSQL which I described here Is my system configuration restricting me to psql:i386?. I have come to ...
0
votes
1answer
126 views

Why is installing ORACLE ODBC client a complex task? [closed]

I'm following the ODBC driver instructions in the link below. I think it would help me deal with issues if I understood why this has to be so complex. Cannot be that ORACLE would not make it easier if ...
0
votes
0answers
620 views

TNS Time out Error ORA-12170

I am trying to connect to a remote Oracle 12c database from a client machine that has 11g oracle drivers for ODBC. I can reach to remote machine through ping but can not Telnet the remote machine on ...
1
vote
1answer
4k views

Oracle connection from Squirrel SQL

I am trying to set up Squirrel SQL for the first time on my Ubuntu Desktop. Here is the SQLPlus command I use to connect to my DB: sqlplus64 "user/pw@pashratgdb01.lex.bb.com:1876/atgpen1.lex.bb.com" ...
2
votes
1answer
377 views

is there a GUI client that can execute multiple queries and show its multiple results? [closed]

I'm currently using pgadmin and it appears that it is not possible to send more than one query and retrieve multiple data sets back. For example, if I try to do this: select travelerId, name from ...
-1
votes
2answers
234 views

Vertica 6.1: vsql creashes with large resultset

I'm writing a script to export data from our Vertica cluster. The command I'm using is: vsql MY_DB_NAME -At -F$'\t' -o /data/vertica_archive/MY_DATA_2015_07_01.tsv -c "select * from DATA_TABLE where ...
3
votes
0answers
2k views

SSMS Client Error: Internal connection fatal error

I am running SSMS 11.0.5646.0 on a Windows 7.0 Pro desktop connected by UTP directly to same network switch as my development server (Windows 2008R2 Standard, SQL 2008R2 SE with SP3). All within the ...
8
votes
1answer
569 views

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 ...
1
vote
1answer
750 views

Oracle client in Windows 7: how to change looking path for sqlnet.ora

For some security reasons I'm not able to amend the file sqlnet.ora, must meet security policies applied. Is it possible to change the search path of this file to some other drive/folder? Thank you!
0
votes
1answer
10k views

Two Oracle clients on the same server

Is it okay to have two oracle clients (both 11g and 12c) in the same db server? What are the potential issues I could face? The reason im doing this is to connect the app server where I'm deploying ...
0
votes
1answer
206 views

Oracle instant client memory footprint

In the link mentioned here --> http://www.oracle.com/technetwork/database/features/oci/ic-faq-094177.html it says there is increased virtual memory footprint when running my applications in ...
2
votes
2answers
1k views

Oracle instant client

What is the difference between instant client and the original Oracle client? The Oracle client is almost 800MB and the instant client is not so much. I need to install oracle client, ODBC drivers and ...
3
votes
2answers
678 views

How do I connect to mysql without having to type an empty password?

I just installed MySQL, and by default the root user has no password. If I connect with this command: mysql --port=3307 --host=127.0.0.1 -uroot -p It asks me to enter a password, I just hit return, ...
3
votes
2answers
553 views

How to identify a client application whose host_process_id points to sqlserver.exe

I am in the process of trying to identify a client application which uses one of the SQL Servers I support (2008 R2). Periodic queries against sys.dm_exec_sessions regularly return sessions whose ...
0
votes
1answer
27k views

How to fix “TNS:listener does not currently know of SID given in connect descriptor” with DBVisualizer on Linux?

I am trying to connect with Oracle database from a server having Oracle client installed (RHEL Linux Environment). I installed DB Visualizer on client machine. But getting listner error on hitting ...
2
votes
0answers
584 views

Umlauts in DBeaver

I have a postgres Database set to UTF-8. I am working with DBeaver 3.1.4, and it seems to use a different encoding than UTF-8 (I suppose Latin-1 or something), which leads to 1) wrong display in the ...
0
votes
2answers
479 views

Best practices for generating a tnsnames.ora entry

I need to integrate some scripts that export and import data from Oracle databases. They are shell scripts that rely on the TNS name being set up (e.g., scott/tiger@tns). The application owners are ...
1
vote
1answer
7k views

Oracle Database Client 11g R2 Installation Types, which components?

I need to know which component is under each installation type! Instant Client Administrator Runtime Custom (No need as it shows all the components) ALSO? does it includes ODP.NET? is it the ...