The tag has no wiki summary.

learn more… | top users | synonyms

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

ORA-12541: TNS: No listener after adding new IPs to machine

We are receiving the ORA-12541 error since we added 2 new IP addresses to the machine. This may or may not be related to the problem at hand, but this is the latest severe change that was made, before ...
0
votes
0answers
55 views

SQL Server Data access does not connect unless we provide the port number

I have configured SQL Server 2008 R2 named instance on Windows Server 2008 R2 to listen to only one IP,1433. Some Office 2010 clients are trying to connect using the external data to SQL Server using ...
0
votes
0answers
17 views

How could I prevent the mysql cli-/terminal client from converting/altering multiline-statements (in the process of logging)?

Is there a way to prevent the default mysql client from ?: 'removing newlines' a.k.a. 'converting newlines to spaces' a.k.a. 'mapping newlines to spaces' Being more specific, with 'default mysql ...
3
votes
1answer
117 views

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

Postgresql database backup (and restore) from two servers to third storage place

I have two server machines with PostgreSQL: (A) is version 9.0.15 and (B) version 9.2. I wish to make backups of the databases stored in (A) and (B) - and be able to do restore if needed too! - to a ...
0
votes
1answer
31 views

MySQL Identifying Connection Attempt

I'm seeing the following errors repeatedly in the error log file for our production MySQL server: [Warning] Access denied for user 'root'@'remote.appserver.com' (using password: NO) So, I know ...
2
votes
0answers
236 views

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

Lookup data while in mysql cli edit mode (external editor) (\e)

I'm using the mysql cli in edit mode (\e). > Select * from \e Goes to vim and I finish typing my command. Select * from test_table; Only to realize I've forgotten to use the database I need. ...
0
votes
1answer
325 views

Oracle 11gr2 instant client installation

I have an application that uses Oracle 11gr2. For the Oracle client installation, I first install InstantClient and then run the setup again, choose Custom, and choose "Oracle Database Utilities" ...
1
vote
0answers
153 views

What are some light-weight clients of SQL Server 2012 that can utilize SQL spatial functions? [closed]

We're building our new enterprise database and it will include SQL server spatial (native) data (moved from ArcSDE). This is great news for our SQL analysts who will now be able to consume our spatial ...
0
votes
1answer
14k views

Where I can find the tnsnames.ora file for my Oracle Windows client? [duplicate]

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). ...
2
votes
1answer
61 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
100 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
583 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
1k 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 ...
3
votes
1answer
698 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
902 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
141 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
798 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
138 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
9k 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!
4
votes
1answer
225 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
797 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
2k 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
1k 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
7k 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
914 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
2k 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 ...